Spreadsheet and Toppings Worksheet
Inventory Summary
Project Description:
In this Mastery project, you will edit a worksheet that summarizes the inventory status at the Petaluma production facility.
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 downloaded Excel workbook named GO_e02_Grader_EOC.xlsx. | 0 | 2 | Rename the Sheet1 worksheet tab to Condiments and then display the Toppings worksheet. | 4 | 3 | On the Toppings worksheet, in cell B4, insert a function that will total the Quantity in Stock data (A15:A29). | 5 | 4 | On the Toppings worksheet, in cell B5, insert a function that will calculate the average retail price of the available toppings (D15:D29). | 5 | 5 | On the Toppings worksheet, in cell B6, insert a function that will calculate the median retail price of the available toppings (D15:D29). | 5 | 6 | On the Toppings worksheet, in cell B7, insert a function that will calculate the lowest retail price of the available toppings (D15:D29). | 5 | 7 | On the Toppings worksheet, in cell B8, insert a function that will calculate the highest retail price of the available toppings (D15:D29). | 5 | 8 | On the Toppings worksheet, in cell B10, insert a function that will count the total number of salsa products available. | 5 | 9 | On the Toppings worksheet, in cell G15, insert a function that will display the text Order if the value in the Quantity in Stock column is less than 50. Otherwise, the function will display the text OK. Copy the function in cell G15 to the range G16:G29. | 8 | 10 | On the Toppings worksheet, apply conditional formatting to the range G15:G29 so that cells containing the text Order are formatted as Bold Italic, with a font color of Aqua, Accent 1 (under Theme Colors). | 8 | 11 | On the Toppings worksheet, display orange data bars with a gradient fill in all cells in the range A15:A29. | 8 | 12 | On the Toppings
Project Description:
In this Mastery project, you will edit a worksheet that summarizes the inventory status at the Petaluma production facility.
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 downloaded Excel workbook named GO_e02_Grader_EOC.xlsx. | 0 | 2 | Rename the Sheet1 worksheet tab to Condiments and then display the Toppings worksheet. | 4 | 3 | On the Toppings worksheet, in cell B4, insert a function that will total the Quantity in Stock data (A15:A29). | 5 | 4 | On the Toppings worksheet, in cell B5, insert a function that will calculate the average retail price of the available toppings (D15:D29). | 5 | 5 | On the Toppings worksheet, in cell B6, insert a function that will calculate the median retail price of the available toppings (D15:D29). | 5 | 6 | On the Toppings worksheet, in cell B7, insert a function that will calculate the lowest retail price of the available toppings (D15:D29). | 5 | 7 | On the Toppings worksheet, in cell B8, insert a function that will calculate the highest retail price of the available toppings (D15:D29). | 5 | 8 | On the Toppings worksheet, in cell B10, insert a function that will count the total number of salsa products available. | 5 | 9 | On the Toppings worksheet, in cell G15, insert a function that will display the text Order if the value in the Quantity in Stock column is less than 50. Otherwise, the function will display the text OK. Copy the function in cell G15 to the range G16:G29. | 8 | 10 | On the Toppings worksheet, apply conditional formatting to the range G15:G29 so that cells containing the text Order are formatted as Bold Italic, with a font color of Aqua, Accent 1 (under Theme Colors). | 8 | 11 | On the Toppings worksheet, display orange data bars with a gradient fill in all cells in the range A15:A29. | 8 | 12 | On the Toppings