need done in 8 hrs

Creating 3D Cell References and Using Worksheet Grouping Lab 5, Step 2 Make sure that the Lab 5 Summary file is open in Excel. A. Fill in the first formula required using 3D cell reference to refer to data on multiple

worksheets. Select Cell B3 on the Summary worksheet and type =SUM(

Click the Westside tab to begin the 3D cell referencing. Hold down the Shift key and select the last worksheet, for example, Downtown. Click in Cell B3. Press the Enter key to add an ending parenthesis and complete the formula. You will see the results of the formula in Cell B3.

Click on Cell B3 to review the formula Excel has created:

Note that this cell reference tells Excel to total the contents in Cell B3 for all worksheets from Westside through Downtown. B. You can copy this formula across and then down to see the sales by quarter for each

of the dining categories:

C. Use Grouping to add Totals to all worksheets: Select all worksheets by clicking on the first and last worksheet tabs while holding down the Shift key. The tabs will become white:

The filename will also show that the worksheets are Grouped:

Select Cell B6 and create the formula to total results of Cells B3 through B5:

Hit the Enter key. Notice that this formula has been applied to all sheets in the workbook:

Make sure the Worksheets are grouped. Drag the formula across the row:

Create the formula for the Grand Total while the sheets are grouped and then drag this formula to copy it in the Grand Total row:

Ungroup the worksheets. Verify that the formula has been copied to all worksheets.