In this project, you will create a worksheet to summarize the total inventory of a retail store. You will calculate the total category value, the inventory total value, the East Valley store as a percent of the total quantity, and the total quantity minus the amount of inventory on customer layaway. You will also format and rename the worksheet.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step |
Instructions |
Points Possible |
1 |
Start Excel 2013, and then open the downloaded file skills_exl01_grader_a1.xlsx. |
0 |
2 |
Add the file name in the worksheet’s left footer. Return to Normal view. |
6 |
3 |
Select the range A1:H1 and then merge and center the text. |
6 |
4 |
Select the range A2:H2 and then apply the Heading 3 cell style. |
8 |
5 |
Select columns A:B and adjust the column width to 20. |
6 |
6 |
In cell F3, enter a formula that adds the values in cells D3 and E3. |
8 |
7 |
In cell G3, enter a formula that multiples the values in cell C3 and F3. |
8 |
8 |
In cell H3, enter a formula the divides cell D3 by cell F3. |
8 |
9 |
Select the range F3:H3 and then AutoFill the formulas down through row 14. |
6 |
10 |
In cells D15:G15, enter functions that sum each column. |
6 |
11 |
Format the ranges C3:C14 and G3:G14 with the Currency [0] cell style. |
6 |
12 |
Format the range H3:H14 with the Percent Style with one decimal place displayed. |
6 |
13 |
Format the range D15:G15 using the Total cell style. |
6 |
14 |
In cell C20, enter the formula that subtracts the value in cell B20 from cell F3. AutoFill the formula down through cell C31. |
8 |
15 |
Rename the Sheet1 tab as Inventory. |
6 |
16 |
Use the Spelling and Grammar dialog box to correct any spelling errors. |
6 |
17 |
Save the workbook, close the workbook window, and then submit the workbook as directed. |
0 |
Total Points |
100 |