In cell:A1, type Valley View Inventory Summary. Merge \& Center the fitle across the range A1:D1, and then apply the Title cell style. In cell A2, type As of June- 30 and then Merge \& Center the text across the range A2:D2. Apply the Heading 1 cell style. I On the Condiments sheet, copy the range A4:A8. Display the Summary sheet and Raste the selection to cell A5. Apply the Heading 4 cell slyle to the selection, : In the Summary sheet, in cell B4, type Condiments. In cell C4, type Toppings. In cell D4, type Condiments/Toppings. Center the column titles, and then apply the Heading 3 cell style a In cell B5, enter a formula that references cell B4 in the Condiments sheet so that the Condiments Total Items in Stock displays in B5. Create similar formulas to enter the Average Price, Median Price, Lowest Price, and Highest:Price from the Condiments sheet into the Summary sheet in the range B:B9, a 19n Enter formulas in the range C5:C9 that reference the Total items in Stock and the Average Price, Median Price, Lowest Price, and Highest Price cells in the Toppings warksheet . In the range D5:D9 of the Summary sheet, insert Column sparklines using the values in the Condiments and Toppings columns (insert in each cell individually). Fomat the sparklines using the first five styles in the first row in their given order. To apply the Sparkline style, on the Design tab, in the Style group, click More, and apply the first five styles in the first row. To the range B5:C5, apply Comma Stylo with zero decimal places, and confirm that the Accounting Number Format is applied to the range B6: C9. Center the Summary worksheet. Horizontally and change the Orientation to Landicape. Insert a custom footer in the leff: section with the fille name. in