Inventory Summary Contrivance Description: In this Mastery contrivance, you conciliate edit a worksheet that summarizes the schedule foothold at the Petaluma product ease. Instructions: For the resolve of grading the contrivance you are required to enact the forthcoming tasks: Step| Instructions| Points Possible| 1| Start Excel. Open the downloaded Excel workbook determined GO_e02_Grader_EOC. xlsx. | 0| 2| Rename the Sheet1 worksheet tab to Condiments and then show the Toppings worksheet. 4| 3| On the Toppings worksheet, in cell B4, infuse a part that conciliate whole the Quantity in Supply facts (A15:A29). | 5| 4| On the Toppings worksheet, in cell B5, infuse a part that conciliate rate the middle hawk worth of the adapted toppings (D15:D29). | 5| 5|
On the Toppings worksheet, in cell B6, infuse a part that conciliate rate the median hawk worth of the adapted toppings (D15:D29). | 5| 6| On the Toppings worksheet, in cell B7, infuse a part that conciliate rate the smallest hawk worth of the adapted toppings (D15:D29). 5| 7| On the Toppings worksheet, in cell B8, infuse a part that conciliate rate the prominent hawk worth of the adapted toppings (D15:D29). | 5| 8| On the Toppings worksheet, in cell B10, infuse a part that conciliate compute the whole estimate of salsa products adapted. | 5| 9| On the Toppings worksheet, in cell G15, infuse a part that conciliate show the extract Manage if the estimate in the Quantity in Supply support is hither than 50. Otherwise, the part conciliate show the extract OK. Copy the part in cell G15 to the class G16:G29. 8| 10| On the Toppings worksheet, direct amenable formatting to the class G15:G29 so that cells containing the extract Manage are formatted as Bold Italic, delay a font tinge of Aqua, Accent 1 (lower Theme Colors). | 8| 11| On the Toppings worksheet, show oclass facts bars delay a gradient gorge in all cells in the class A15:A29. | 8| 12| On the Toppings worksheet, invent an Excel consultation using the class A14:G29, which includes headers. Format the consultation as Consultation Style Light 9. Sort the Item # support from smallest to largest. | 4| 13| Ooze the Category support so that simply salsa products are showed.
Insert a whole row, and then sum the Quantity in Supply support to show the estimate of salsa products in supply. Record the outcome in cell B11. | 4| 14| Clear the ooze from the Category support. Remove the whole row from the consultation. | 12| 15| Modify the Toppings worksheet so that row 14 prints at the top of each page. | 4| 16| Group contemporaneously the Condiments and Toppings worksheets. Center the worksheets horizontally on the page, and then alter the scaling of the worksheets so that the width of the contents fits on one page. 4| 17|
On the Summary worksheet, in cell C9, infuse a connection formula that conciliate associate to the estimate from cell B8 on the Toppings worksheet. | 5| 18| On the Summary worksheet, in cell D9, infuse Support sparklines using the estimates B9:C9. | 6| 19| On the Summary worksheet, in cell D9, direct Style Accent 5, Darker 50% to the sparklines. | 3| 20| Ensure that the worksheets are unexceptionably determined and placed in the forthcoming manage in the workbook: Summary, Condiments, Toppings. Save the workbook. Close the workbook and then debouchure Excel. Submit the workbook as directed. | 0| | Whole Points| 100|