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 Instructions Points Possible 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. Rename Sheet1 as Inventory. Rename Sheet2 as BackOrders. On the Inventory worksheet, in cell A27, insert the comment Unisex. In cell A17, edit the contents to read Inventory. Center align and wrap the text in the following cell ranges: B4:L4, B10:L10, B17:D17, and B25:D25. In cell A25, using the ALT and ENTER keys, insert a hard return between Miscellaneous Items. Be sure to remove the space. 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. Copy the contents of cell D18 down through D23. Copy the contents of cell D26 down through D28. Move the information in the cell range A25:D28 to F17:120. Merge and center the contents in cell A1 through the range A1:N1. Delete row 3. Change the color of the Inventory worksheet tab to Red. 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 On the BackOrders worksheet tab, apply Center Across Selection to range A1:D2. 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:06 through C8:D8. 15 Delete Sheet3. Step Instructions Points Possible 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. 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 18 For the Inventory and Documentation worksheets, set Orientation to Landscape, and set the scaling to Fit All Columns on One Page. 10 Save the workbook, exit Excel, and then submit your files as directed by your instructor. Total Points 100 Steps to Perform: Step Instructions Points Possible 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. Rename Sheet1 as Inventory. Rename Sheet2 as BackOrders. On the Inventory worksheet, in cell A27, insert the comment Unisex. In cell A17, edit the contents to read Inventory. Center align and wrap the text in the following cell ranges: B4:L4, B10:L10, B17:D17, and B25:D25. In cell A25, using the ALT and ENTER keys, insert a hard return between Miscellaneous Items. Be sure to remove the space. 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. Copy the contents of cell D18 down through D23. Copy the contents of cell D26 down through D28. Move the information in the cell range A25:D28 to F17:120. Merge and center the contents in cell A1 through the range A1:N1. Delete row 3. Change the color of the Inventory worksheet tab to Red. 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 On the BackOrders worksheet tab, apply Center Across Selection to range A1:D2. 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:06 through C8:D8. 15 Delete Sheet3. Step Instructions Points Possible 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. 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 18 For the Inventory and Documentation worksheets, set Orientation to Landscape, and set the scaling to Fit All Columns on One Page. 10 Save the workbook, exit Excel, and then submit your files as directed by your instructor. Total Points 100