Spreadsheet and Toppings Worksheet

Inventory summary Project Description In this Mastery take in, you give 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 smell Instructions Points Possible 1 Start Excel. disseminate the downloaded Excel workbook named GO_e02_Grader_EOC. xlsx. 0 2 Rename the Sheet1 worksheet check mark to Condiments and then screening the Toppings worksheet. 4 3 On the Toppings worksheet, in mobile phone B4, chime in a region that testament total the Quantity in melodic phrase data (A15A29). 5 4 On the Toppings worksheet, in booth B5, insert a function that go away compute the average retail wrong of the open pinchpings (D15D29). 5 5On the Toppings worksheet, in cell B6, insert a function that will calculate the median retail price of the available toppings (D15D29). 5 6 On the Toppings worksheet, in cell B7, insert a function that will cal culate the terminal retail price of the available toppings (D15D29). 5 7 On the Toppings worksheet, in cell B8, insert a function that will calculate the highest retail price of the available toppings (D15D29). 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 grade if the value in the Quantity in wrinkle column is less than 50. Otherwise, the function will display the text OK. Copy the function in cell G15 to the range G16G29. 8 10 On the Toppings worksheet, grant conditional formatting to the range G15G29 so that cells containing the text Order are formatted as Bold Italic, with a font color of Aqua, Accent 1 (under root Colors). 8 11 On the Toppings worksheet, display orangeness data bars with a gradient conform to in all cells in the range A15A29. 8 12 On the Toppings worksheet, create an Excel shelve using the range A14G29, which includes headers. Format the table as Table Style Light 9. Sort the particular column from smallest to largest. 4 13 Filter the kinfolk column so that only salsa products are displayed.Insert a total row, and then sum the Quantity in Stock column to display the number of salsa products in stock. Record the result in cell B11. 4 14 Clear the filter from the Category column. suppress the total row from the table. 12 15 variegate the Toppings worksheet so that row 14 prints at the top of each page. 4 16 Group together the Condiments and Toppings worksheets. Center the worksheets horizontally on the page, and then change the scaling of the worksheets so that the width of the contents fits on one page. 4 17On the epitome worksheet, in cell C9, insert a linking locution that will refer to the value from cell B8 on the Toppings worksheet. 5 18 On the Summary worksheet, in cell D9, insert Column sparklines using the value B9C9. 6 19 On the Summary wor ksheet, in cell D9, apply Style Accent 5, Darker 50% to the sparklines. 3 20 Ensure that the worksheets are justly named and placed in the following order in the workbook Summary, Condiments, Toppings. Save the workbook. Close the workbook and then exit Excel. train the workbook as directed. 0 Total Points 100