Towson Chapter 1 All Sports Athletics Tracking Supply Inventory Excel Sheet i would like help with completing this Excel sheet. i have made multiple attempts, and no matter how many times i try and follow the instructions, there is always an error present. Grader – Instructions
Excel 2016 Project
YO16_XL_CH01_GRADER_PS2_AS – Athletics 1.4
Project Description:
Darin Learn recently open a small sporting goods store next to the local community college. He wants to use Excel to track
supply inventory, the total cost of inventory, as well as items on back order. Darin has created a workbook containing a list of
the products in inventory, a list of items on back order, and a documentation worksheet. You have been asked enhance the
appearance of the worksheets, edit content, insert comments, and improve overall formatting, making the information easier to
review and analyze.
Steps to Perform:
Step
Points
Possible
Instructions
1
Start Excel. Open the file named e01ch01_grader_a1_Athletics.xlsx. Save the file with the
name e01ch01_grader_a1_Athletics_LastFirst using your last and first name.
0
2
Rename Sheet1 as Inventory.
Rename Sheet2 as BackOrders.
8
3
On the Inventory worksheet, in cell A27, insert the comment Unisex.
6
4
In cell A17, edit the contents to read Inventory.
4
5
Center align and wrap the text in the following cell ranges: B4:L4, B10:L10, B17:D17, and
B25:D25.
6
6
In cell A25, using the ALT and ENTER keys, insert a hard return between Miscellaneous
Items. Be sure to remove the space.
6
7
Insert a column to the left of column E.
Insert a column to the left of column J.
Change the width of columns E and J to 5.
6
8
Copy the contents of cell D18 down through D23.
Copy the contents of cell D26 down through D28.
8
9
Move the information in the cell range A25:D28 to F17:I20.
2
10
Merge and center the contents in cell A1 through the range A1:N1.
6
11
Delete row 3.
Change the color of the Inventory worksheet tab to Red.
4
12
Change to the width of the worksheet columns as follows:
Columns A, F, and K to 17
Columns B, C, D, G, H, I, L, M, N to 8
8
13
On the BackOrders worksheet tab, apply Center Across Selection to range A1:D2.
5
14
In cell C6, enter Date Ordered as 12/15/18.
In cell D6, enter the Date to be Received as 12/29/18.
Use the AutoFill handle to copy cell range C6:D6 through C8:D8.
8
15
Delete Sheet3.
5
Created On: 07/05/2019
1
YO16_XL_CH01_GRADER_PS2_AS – Athletics 1.4
Grader – Instructions
Step
Excel 2016 Project
Points
Possible
Instructions
16
On the Inventory worksheet, insert a page header into the middle section.
Type All Sports Athletics.
Insert the file name code into the left footer of all worksheets in the workbook.
Return all worksheets to Normal view.
5
17
On the Documentation worksheet, in cell A8, type today’s date.
In B8, type your name in Firstname Lastname format.
In cell C8, type Formatted Inventory worksheet
In cell C9, type Updated the BackOrders worksheet
3
18
For the Inventory and Documentation worksheets, set Orientation to Landscape, and set the
scaling to Fit All Columns on One Page.
19
Save the workbook, exit Excel, and then submit your files as directed by your instructor.
Total Points
Created On: 07/05/2019
2
10
0
100
YO16_XL_CH01_GRADER_PS2_AS – Athletics 1.4
All Sports Athletics
Men’s Clothing Price per Unit
Quantity in Stock
Total Cost of Inventory
Price per Unit
Quantity in Stock
Total Cost of Inventory
T-shirts (s)
15.99
26 $ 415.74 Athletic shorts (s)
16.99
27 $ 458.73
T-shirts (m)
15.99
20 $ 319.80 Athletic shorts (m)
16.99
22 $ 373.78
T-shirts (l)
15.99
25 $ 399.75 Athletic shorts (l)
16.99
19 $ 322.81
T-shirts (xl)
15.99
12 $ 191.88 Athletic shorts (xl)
16.99
24 $ 407.76
Women’s Clothing
Price per Unit
Quantity in Stock
Total Cost of Inventory
Price per Unit
Quantity in Stock
Total Cost of Inventory
T-shirts (xs)
14.99
18 $ 269.82 Athletic shorts (xs)
16.99
16 $ 271.84
T-shirts (s)
14.99
20 $ 299.80 Athletic shorts (s)
16.99
22 $ 373.78
T-shirts (m)
14.99
25 $ 374.75 Athletic shorts (m)
16.99
25 $ 424.75
T-shirts (l)
14.99
10 $ 149.90 Athletic shorts (l)
16.99
20 $ 339.80
T-shirts (xl)
14.99
25 $ 374.75 Athletic shorts (xl)
16.99
27 $ 458.73
Other Items
Basketballs
Soccer balls
Volleyballs
Tennis balls
Footballs
Racquetballs
Price per Unit
Quantity in Stock
Total Cost of Inventory
25.99
10 $ 259.90
22.99
14
17.99
17
13.99
15
19.99
18
12.99
12
Miscellaneous Items
Price per Unit
Quantity in Stock
Total Cost of Inventory
Water bottles
4.5
55 $ 247.50
Headbands
4.5
38
Gym bags
19
32
Total Cost of Inventory
Price per Unit
Quantity in Stock
Total Cost of Inventory
Calf-high socks
8.99
25 $ 224.75
Ankle socks
8.99
24 $ 215.76
Compression socks
15.99
10 $ 159.90
Total Cost of Inventory
Price per Unit
Quantity in Stock
Total Cost of Inventory
Calf-high socks
8.99
29 $ 260.71
Ankle socks
8.99
18 $ 161.82
Compression socks
15.99
5 $ 79.95
All Sports Athletics
Back Order Tracking
Inventory Item Back-ordered
Baseball bats
Mouth guards
Soccer nets
Quantity Ordered
15
25
15
Date Ordered
Date to be Received
All Sports Athletics
Create Date
By Whom
12/18/2018 Darin Learn
Mod. Date
By Whom
Description
Inventory workbook
Mod. Description
Create Date
Sheet Name
12/18/2018 Sheet1
12/18/2018 Sheet2
Creator
Darin Learn
Darin Learn
Workbook Name
20190917042059santos_e01ch01_grader_a1_athletics.xlsx
Last Version Backup Name
Purpose
List and prices of inventory items
Items on back order; date of expected delivery
Purchase answer to see full
attachment