1. Switch to the Consolidated worksheet. Consolidate the revenue data from each of the offices as follows:
   1. In cell A4, enter a formula without using a function that references cell A4 in the Washington worksheet. Copy the formula from cell A4 to the range A5:A7.
   2. In cell B4, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B4 in the California:Washington worksheets.
   3. Copy the formula from cell B4 to the range B5:B7 without copying the formatting.
   4. Copy the formulas and the formatting from the range B4:B7 to the range C4:F7.

NP EX16_CS5-8a DallasThompson 1 Excel Sign in File Home Insert Draw Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share Comments Cut AutoSum . A Tw Cen MT General 48 | Conditional Format as Cell Formatting Table Styles | i nsert Delete Format Merge & Center | $ . % , Sort & Find & Filter, Select - Format Painter Clear Clipboard Number Cells Editing AVERAGE Wild Planet Conservation Total Revenue-201 9 March Apr May Total 8 Total 10 Goal met? No No No No No 12 13 14 15 16 17 18 Documentation Local Offices California Oregon Washington Consolidated Sprng O Type here to search 3-12 PM 2/25/2019 NP EX16_CS5-8a DallasThompson 1 Excel Sign in File Home Insert Draw Page Layout Formulas Data Review View Developer Help Tell me what you want to do Share Comments Cut AutoSum . A Tw Cen MT General 48 | Conditional Format as Cell Formatting Table Styles | i nsert Delete Format Merge & Center | $ . % , Sort & Find & Filter, Select - Format Painter Clear Clipboard Number Cells Editing AVERAGE Wild Planet Conservation Total Revenue-201 9 March Apr May Total 8 Total 10 Goal met? No No No No No 12 13 14 15 16 17 18 Documentation Local Offices California Oregon Washington Consolidated Sprng O Type here to search 3-12 PM 2/25/2019