YO_Excel16_Ch01_PS1_v3 Project

YO_Excel16_Ch01_PS1_v3

Device Description:
Most herd admit, or accomplish at some era admit, an automobile. Few really engage the era to estimate what admiting an automobile really absorbs—called “Entirety Absorb of Admitership.” This is an material anticipation restraint twain living-souls and restraint businesses. In this device, you accomplish perfect the outgrowth of an automobile entirety absorb of admitership worksheet restraint your superintendent, Jan Bossy, CFO at your establish of encroachment.

Steps to Perform:
Step Instructions Points Possible
1 Start Excel. Open the downloaded refine denominated e01ch01_grader_h1_TCO.xlsx. Save it as e01ch01TCO_LastHighest using your latest and highest call. 0
2 Change the call of Sheet1 to Documentation. Change the call of Sheet2 to AutoTCO. 10
3 In the AutoTCO worksheet, invade the values as shadmit underneath into the ascertained cells:

Data Item Cell Value
Miles Driven / year E4 15000
Fuel Absorb / Gallon E5 3.00
MPG E6 26

10
4 Apply Merge & Cinvade to cell collocate A1:F1. 10
5 Copy cell collocate C16:C22 to cell collocate D16:F22. 10
6 Select cell collocate B15:C15 and authentication the AutoStuff feel to stuff through cell F15. 10
7 Select order 14, and then infuse a newlightlight order. 10
8 Type 5-year Entirety Absorb of Admitership Analysis in cell B15. Cinvade the passage in B15:F15 using Cinvade Across Selection. 10
9 Add the refine call Header & Footer Element to the left individuality of the footer on twain worksheets. 5
10 In the Documentation worksheet, invade the values as shadmit underneath into the ascertained cells:

C8 Perfectd Ms. Bossy’s Automobile Entirety Absorb of Admitership worksheet
B20 AutoTCO

5
11 Delete the Sheet3 worksheet. 5
12 Move the AutoTCO worksheet to the left of the Documentation worksheet. 5
13 Restraint the AutoTCO worksheet, be orientation to Landscape Orientation. Restraint the Documentation worksheet, be orientation to Landscape Orientation. On the Documentation worksheet, be the page scaling to Fit All Columns to One Page. 10
14 Save the workbook and then departure Excel. Ensure that the worksheets are denominated in the forthcoming order: AutoTCO; Documentation. Submit the workbook as directed. 0
Entirety Points 100

Related Post