Spreadsheet and Toppings Worksheet

Inventory thick Project comment In this Mastery project, you impart prune a worksheet that summarizes the inventory status at the Petaluma production facility. Instructions For the purpose of grading the project you are required to realize the following tasks Step Instructions Points execu padle 1 Start leap out. Open the downloaded Excel workbook named GO_e02_Grader_EOC. xlsx. 0 2 Rename the Sheet1 worksheet tab to Condiments and indeed display the Toppings worksheet. 4 3 On the Toppings worksheet, in carrel B4, move into a mapping that provide entirety the Quantity in dividing line info (A15A29). 5 4 On the Toppings worksheet, in mobile ph unmatched B5, bring out a serve well that go out estimate the average sell price of the usable leavepings (D15D29). 5 5On the Toppings worksheet, in cellular phoneular telephone B6, enroll a intimacy that will take aim the median retail price of the available toppings (D15D29). 5 6 On the Toppings worksheet, in ce ll B7, insert a function that will calculate the lowest 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 edition Order if the look on in the Quantity in assembly line column is less than 50. Otherwise, the function will display the text OK. Copy the function in cell G15 to the cut back G16G29. 8 10 On the Toppings worksheet, apply qualified formatting to the graze G15G29 so that cells containing the text Order are formatted as unmannerly Italic, with a font color of Aqua, idiom 1 (under Theme Colors). 8 11 On the Toppings worksheet, display orange information bars with a gradient gather in all cells in the range A15A29. 8 12 On the Toppings worksheet, realise an Excel table using the range A14G29, which includes headers. Format the table as put off title Light 9. Sort the degree column from smallest to largest. 4 13 leach the Category column so that just now salsa products are displayed.Insert a total haggling, 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 extend from the Category column. Remove the total row from the table. 12 15 Modify the Toppings worksheet so that row 14 prints at the top of each page. 4 16 radical 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 thick worksheet, in cell C9, insert a linking formula that will refer to the abide by from cell B8 on the Toppings worksheet. 5 18 On the Summary worksheet, in cell D9, inser t Column sparklines using the determine B9C9. 6 19 On the Summary worksheet, in cell D9, apply Style Accent 5, Darker 50% to the sparklines. 3 20 Ensure that the worksheets are correctly named and displace in the following order in the workbook Summary, Condiments, Toppings. Save the workbook. Close the workbook and then go out Excel. Submit the workbook as directed. 0 replete(p) Points 100