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
e_ch01_sklv1_a1_instructions.docx
guo_skills_exl01_grader_a1.xlsx
Unformatted Attachment Preview
Office 2013 – myitlab:grader – Instructions
Skills for Success – Excel Chapter 1: Assessment Project 1
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
Points
Possible
Instructions
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
Updated: 03/06/2013
1
E_CH01_SKLV1_A1_Instructions.docx
Office 2013 – myitlab:grader – Instructions
Step
Skills for Success – Excel Chapter 1: Assessment Project 1
Points
Possible
Instructions
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
Updated: 03/06/2013
2
100
E_CH01_SKLV1_A1_Instructions.docx
Tom’s Place
Inventory Number
10-3034
67-2111
67-3137
67-5189
67-8267
55-3142
55-4184
29-5825
29-5835
29-5840
29-5845
29-5850
Inventory Total
Category
Price
Grills
Dishwashres
Freezers
Microwaves
Ovens
Gas Push Mowers
Electric Push Mowers
Adirondack Chairs
Deck Boxes
Folding Chairs
Hammocks
Patio Benchs
Category
Grills
Dishwashers
Freezers
Microwaves
Ovens
Gas Push Mowers
Electric Push Mowers
Adirondack Chairs
Deck Boxes
Folding Chairs
Hammocks
Patio Benches
299
550
459
249
469
129
109
109
59
49
149
259
Total Quantity
minus Quantity
on Layaway
Quantity on
Layaway
13
22
10
30
20
10
5
15
6
22
31
51
East Valley
Location
Quantity
20
67
21
88
35
19
28
47
21
45
53
81
Central
Location
Quantity
Total Quantity
7
27
19
80
31
13
23
46
18
36
35
44
Total
Category
Value
East Valley as a
Percent of Total
Quantity
…
Purchase answer to see full
attachment
Recent Comments