Tom’s Place Inventory
Project Description:
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 
Tom’s Place Inventory
Project Description:
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 
Tom’s Place Inventory
Project Description:
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 
Tom’s Place Inventory
Tom’s Place InventoryTom’s Place InventoryTom’s Place Inventory
Project Description:
Project Description: Project Description: Project Description:
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.
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.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.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:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
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 
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints 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
1
Start Excel 2013, and then open the downloaded file skills_exl01_grader_a1.xlsx.
0
1
1
111
Start Excel 2013, and then open the downloaded file skills_exl01_grader_a1.xlsx.
Start Excel 2013, and then open the downloaded file skills_exl01_grader_a1.xlsx.
Start Excel 2013, and then open the downloaded file skills_exl01_grader_a1.xlsx.skills_exl01_grader_a1.xlsx
0
0
0
2
Add the file name in the worksheet’s left footer. Return to Normal view.
6
2
2
222
Add the file name in the worksheet’s left footer. Return to Normal view.
Add the file name in the worksheet’s left footer. Return to Normal view.
Add the file name in the worksheet’s left footer. Return to Normal view.Add the file name in the worksheet’s left footer. Return to Normal view.
6
6
6
3
Select the range A1:H1 and then merge and center the text.
6
3
3
333
Select the range A1:H1 and then merge and center the text.
Select the range A1:H1 and then merge and center the text.
Select the range A1:H1 and then merge and center the text.
6
6
6
4
Select the range A2:H2 and then apply the Heading 3 cell style.
8
4
4
444
Select the range A2:H2 and then apply the Heading 3 cell style.
Select the range A2:H2 and then apply the Heading 3 cell style.
Select the range A2:H2 and then apply the Heading 3 cell style.
8
8
8
5
Select columns A:B and adjust the column width to 20.
6
5
5
555
Select columns A:B and adjust the column width to 20.
Select columns A:B and adjust the column width to 20.
Select columns A:B and adjust the column width to 20.20
6
6
6
6
In cell F3, enter a formula that adds the values in cells D3 and E3.
8
6
6
666
In cell F3, enter a formula that adds the values in cells D3 and E3.
In cell F3, enter a formula that adds the values in cells D3 and E3.
In cell F3, enter a formula that adds the values in cells D3 and E3.
8
8
8
7
In cell G3, enter a formula that multiples the values in cell C3 and F3.
8
7
7
777
In cell G3, enter a formula that multiples the values in cell C3 and F3.
In cell G3, enter a formula that multiples the values in cell C3 and F3.
In cell G3, enter a formula that multiples the values in cell C3 and F3.
8
8
8
8
In cell H3, enter a formula the divides cell D3 by cell F3.
8
8
8
888
In cell H3, enter a formula the divides cell D3 by cell F3.
In cell H3, enter a formula the divides cell D3 by cell F3.
In cell H3, enter a formula the divides cell D3 by cell F3.
8
8
8
9
Select the range F3:H3 and then AutoFill the formulas down through row 14.
6
9
9
999
Select the range F3:H3 and then AutoFill the formulas down through row 14.
Select the range F3:H3 and then AutoFill the formulas down through row 14.
Select the range F3:H3 and then AutoFill the formulas down through row 14.
6
6
6
10
In cells D15:G15, enter functions that sum each column.
6
10
10
101010
In cells D15:G15, enter functions that sum each column.
In cells D15:G15, enter functions that sum each column.
In cells D15:G15, enter functions that sum each column.
6
6
6
11
Format the ranges C3:C14 and G3:G14 with the Currency [0] cell style.
6
11
11
111111
Format the ranges C3:C14 and G3:G14 with the Currency [0] cell style.
Format the ranges C3:C14 and G3:G14 with the Currency [0] cell style.
Format the ranges C3:C14 and G3:G14 with the Currency [0] cell style.
6
6
6
12
Format the range H3:H14 with the Percent Style with one decimal place displayed.
6
12
12
121212
Format the range H3:H14 with the Percent Style with one decimal place displayed.
Format the range H3:H14 with the Percent Style with one decimal place displayed.
Format the range H3:H14 with the Percent Style with one decimal place displayed.
6
6
6
13
Format the range D15:G15 using the Total cell style.
6
13
13
131313
Format the range D15:G15 using the Total cell style.
Format the range D15:G15 using the Total cell style.
Format the range D15:G15 using the Total cell style.
6
6
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
14
14
141414
In cell C20, enter the formula that subtracts the value in cell B20 from cell F3. AutoFill the formula down through cell C31.
In cell C20, enter the formula that subtracts the value in cell B20 from cell F3. AutoFill the formula down through cell C31.
In cell C20, enter the formula that subtracts the value in cell B20 from cell F3. AutoFill the formula down through cell C31.
8
8
8
15
Rename the Sheet1 tab as Inventory.
6
15
15
151515
Rename the Sheet1 tab as Inventory.
Rename the Sheet1 tab as Inventory.
Rename the Sheet1 tab as Inventory.Inventory
6
6
6
16
Use the Spelling and Grammar dialog box to correct any spelling errors.
6
16
16
161616
Use the Spelling and Grammar dialog box to correct any spelling errors.
Use the Spelling and Grammar dialog box to correct any spelling errors.
Use the Spelling and Grammar dialog box to correct any spelling errors.
6
6
6
17
Save the workbook, close the workbook window, and then submit the workbook as directed.
0
17
17
171717
Save the workbook, close the workbook window, and then submit the workbook as directed.
Save the workbook, close the workbook window, and then submit the workbook as directed.
Save the workbook, close the workbook window, and then submit the workbook as directed.
0
0
0
Total Points
100
Total Points
Total Points
Total PointsTotal PointsTotal Points
100
100
100100100