Roger Harding, the manager of Thunder City Bookstore, wants to improve the appearance of the workbook created to review the store inventory. Roger has a workbook started with the inventory, backorder, and documentation sheets already created. This project will require you to use your Excel skills to improve Roger’s workbook. Some of the actions needed include copying the promotions worksheet from the marketing director’s workbook and pasting it into Roger’s workbook, enhancing the appearance of the worksheets by applying a theme, using built-in cell styles, rotating labels, changing a worksheet theme, formatting a section of a worksheet as a table, and using and printing functions and formulas.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points Possible
1
Open the Excel file, e01ch02_grader_a1_TCBInventory.xlsx. Save your file as e01ch02_grader_a1_TCBInventory_LastFirst, using your last and first name.
0
2
Change the workbook theme to Mesh.
4
3
Open e01ch02_grader_a1_TCBPromos, and copy the Promotions worksheet to the e01ch02_grader_a1_TCBInventory_LastFirst workbook. Place the Promotions worksheet before Documentation worksheet. Close the e01ch02_grader_a1_TCBPromos file.
4
4
On the Inventory worksheet:
In cell D4, enter the label Inventory Cost
In cell E4, enter the label Subtotal
Apply Align Right to cell range C4:D4.
8
5
In cell D6, enter a formula to calculate the total cost of inventory for gym shorts depending on price per unit and quantity in stock.
Format the resulting figure as Currency with two decimal places.
Copy the formula entered in D6 to the range D7:D39.
Delete the contents of cells D10, D15, D20, D25, D26, D33, and D34.
8
6
In cell E10, enter a function to calculate the total cost of all gym shorts in inventory.
In cell E15, enter the function to calculate the total cost of all sweatpants in inventory.
In cell E20, enter the function to calculate the total cost of all t-shirts in inventory.
In cell E25, enter the function to calculate the total cost of all sweatshirts in inventory.