Q:

Project Description:

Darin Learn recently opened 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 to enhance the appearance of the worksheets, edit content, insert comments, and improve overall formatting, making the information easier to review and analyze.

1 Start Excel Download and open the file named Excel Ch01_PS1 Athletics xlsx Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 21 Worksheet names should be descriptive. Rename Sheet1 as Inventory Rename Sheet2 as BackOrders 3 To document the workbook, on the Inventory worksheet, in cell A23, add a cell Note. Delete the Note username and then enter 4-pack In cell A17, edit the contents to Inventory 5 To improve the readability of the worksheet, wrap the text in the following cell ranges: B4:L4, B10:L10, B17:D17, and B25:D25. 6 In cell A25, insert a hard return between the words Miscellaneous Items. Be sure to remove the space between the two words before inserting a hard return. 7 To add white space to the worksheet, perform the following: 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 8 Copy the formula in cell D18 through cell D23. Copy the formula in cell D26 through cell D28. 9 Move the information in the cell range A25:D28 to cell range F17:120. 10 To center the title over the worksheet data, merge and center the contents in cell A1 through cell range A1:N1. 11 Delete row 3. Change the color of the Inventory worksheet tab to Red 12 Change to the width of the worksheet columns as follows: Columns A, F, and K to 17 Columns B, C, G, H, L, M to 8 Columns D, I, N to 10 13 On the Backsters, worksheet tab, apply Center Across Selection to range A1:D2. Step Instructions 14 In cell C6, enter Date Ordered as 12/15/22 In cell D6, enter the Date to be Received as 12/29/22 Use the fill handle to copy cell range C6:06 through C8.D8. Use the Auto Fill Options button to copy cells, not fill series. 15 To ensure there are no blank worksheets in the workbook, delete Sheet3. 16 Insert the File Name code into the left footer of all worksheets in the workbook. Return all worksheets to Normal view. 17 Documentation is an important component of a well-structured workbook. A well-documented workbook is much easier to use and maintain, particularly for a user who did not develop the workbook. Therefore, on the Documentation worksheet, complete the following: In cell A8, type today's date In cell B8, type your name in Firstname Lastname, format. In cell CB, type Formatted Inventory worksheet In cell C9, type Updated the Backorders, worksheet 18 On the Inventory and Documentation worksheets, set the orientation to Landscape, and set the scaling to Fit All Columns on One Page 19 Save and close the Excel_Ch01_PS1_Athletics workbook Exit Excel. Submit the file as directed Total Points 0 8 6 4 6 6 6 8 N 6 2 8 5 Points Possible 8 5 5 3 10 0 100