Information Tools For Business

YO16XLCH01GRADERPS2AS_-_Athletics_14_Instructions x
Office 2016 – myitlab:grader – Instructions Excel 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.

Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
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.000
2 Rename Sheet1 as Inventory.
Rename Sheet2 as BackOrders. 8.000
3 On the Inventory worksheet, in cell A27, insert the comment Unisex. 6.000
4 In cell A17, edit the contents to read Inventory. 4.000
5 Center align and wrap the text in the following cell ranges: B4:L4, B10:L10, B17:D17, and B25:D25. 6.000
6 In cell A25, using the ALT and ENTER keys, insert a hard return between Miscellaneous Items. Be sure to remove the space. 6.000
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.000
8 Copy the contents of cell D18 down through D23.
Copy the contents of cell D26 down through D28. 8.000
9 Move the information in the cell range A25:D28 to F17:I20. 2.000
10 Merge and center the contents in cell A1 through the range A1:N1. 6.000
11 Delete row 3.
Change the color of the Inventory worksheet tab to Red. 4.000
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.000
13 On the BackOrders worksheet tab, apply Center Across Selection to range A1:D2. 5.000
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.000
15 Delete Sheet3. 5.000
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.000
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.000
18 For the Inventory and Documentation worksheets, set Orientation to Landscape, and set the scaling to Fit All Columns on One Page. 10.000
19 Save the workbook, exit Excel, and then submit your files as directed by your instructor. 0.000
Total Points 100.000

Updated: 04/27/2017 1 Current_Instruction x

Nyarko_e01ch01_grader_a1_Athletics.xlsx

Sheet1

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

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
Calf-high socks
8.99
25
$ 224.75

T-shirts (m)
15.99
20
$ 319.80
Athletic shorts (m)
16.99
22
$ 373.78
Ankle socks
8.99
24
$ 215.76

T-shirts (l)
15.99
25
$ 399.75
Athletic shorts (l)
16.99
19
$ 322.81
Compression socks
15.99
10
$ 159.90

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

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
Calf-high socks
8.99
29
$ 260.71

T-shirts (s)
14.99
20
$ 299.80
Athletic shorts (s)
16.99
22
$ 373.78
Ankle socks
8.99
18
$ 161.82

T-shirts (m)
14.99
25
$ 374.75
Athletic shorts (m)
16.99
25
$ 424.75
Compression socks
15.99
5
$ 79.95

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
Price per Unit
Quantity in Stock
Total Cost of Inventory

Basketballs
25.99
10
$ 259.90

Soccer balls
22.99
14

Volleyballs
17.99
17

Tennis balls
13.99
15

Footballs
19.99
18

Racquetballs
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

Sheet2

All Sports Athletics

Back Order Tracking

Inventory Item Back-ordered
Quantity Ordered
Date Ordered
Date to be Received

Baseball bats
15

Mouth guards
25

Soccer nets
15

Documentation

All Sports Athletics

Create Date
By Whom
Description
Workbook Name

12/18/18
Darin Learn
Inventory workbook
e01ch01Athletics_solution.xlsx

Mod. Date
By Whom
Mod. Description
Last Version Backup Name

: VERSION BACKUP NAME :
Before modifying any worksheet, save the original workbook with the following name format:
Original name_yyyymmdd

Create Date
Sheet Name
Creator
Purpose

12/18/18
Sheet1
Darin Learn
List and prices of inventory items

12/18/18
Sheet2
Darin Learn
Items on back order; date of expected delivery

Sheet3