2000 6 With the four sheets grouped insert a function to calculate the highest

2000 6 with the four sheets grouped insert a function

This preview shows page 1 - 2 out of 3 pages.

2.0006With the four sheets grouped, insert a function to calculate the highest sale for each quarter in the range B15:E15. In the range B16:E16, insert a function to calculate the average sale for each quarter. Ungroup the worksheets.8.0007Insert a new worksheet. Rename the worksheet tab Summaryand then change the color of the worksheet tab to Light Turquoise, Background 2. Move the Summary sheet to the left of the Central worksheet tab.4.0008On the Central worksheet, copy the range A1:F3. Paste the copied range to the Summary worksheet in the range A1:F3, keeping source column widths. 5.0009On the Summary sheet, in cell A2, replace the existing text with Quarterly Sales; in cell A3, replace the existing text with Location; in cell A4, type Central; in cell A5, type Eastside; in cell A6, type Downtown; in cell A7, type South; and in cell A8 type Total Sales.4.00010On the Summary sheet, in cell B4, create a formula that will display the total from cell B13 on the Central worksheet. In cell B5, create a formula that will display the value from cell B13 on the Eastside worksheet. In cell B6, create a formula that willdisplay the value from cell B13 on the Downtown worksheet. In cell B7, create a formula that will display the value from cell B13 on the South worksheet. AutoFill the range B4:B7 to the right through column F. Save the file.
Background image
Image of page 2

You've reached the end of your free preview.

Want to read all 3 pages?

  • Fall '16
  • Matty
  • Instructions, Summary sheet, Excel capstone

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture