12. Switch to the Consolidated worksheet. Consolidate the revenue data from each of the offices as follows: a. 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. b. 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. c. Copy the formula from cell B4 to the range B5:B7 without copying the formatting. d. Copy the formulas and the formatting from the range B4:B7 to the range C4:F7.

NP EX16 CS5-8a_DallasThompson_1 - Excel AutoSave Sign in O Tell me what you want to do File Page Lavout Formulas Review View Developer Help Share Comments Home Insert Draw Data AutoSum. 7 X Cut AY 11 b Wrap Text A A General Tw Cen MT Fill LCopy Paste Conditional Format as Cell Sort&Find & Filter Select Insert Delete Format BIU A Merge & Center $-% E Clear Format Painter Formatting Table Styles Styles Cells Editing Clipboard Font Alignment Number AVERAGE + L P - A P C E G H lo M N O Wild Planet Conservation 2019 Total Revenue 1 2 March Feb May Total Jan Apr 5 6 7 8 Total - - - 9 No No No No 10 Goal met? No 11 12 13 14 15 16 17 18 19 Documentation Local Offices Consolidated California Washington Spring ..+ Oregon E 110 Enter 3:12 PM a O Type here to search w w 2/25/2019 NP EX16 CS5-8a_DallasThompson_1 - Excel AutoSave Sign in O Tell me what you want to do File Page Lavout Formulas Review View Developer Help Share Comments Home Insert Draw Data AutoSum. 7 X Cut AY 11 b Wrap Text A A General Tw Cen MT Fill LCopy Paste Conditional Format as Cell Sort&Find & Filter Select Insert Delete Format BIU A Merge & Center $-% E Clear Format Painter Formatting Table Styles Styles Cells Editing Clipboard Font Alignment Number AVERAGE + L P - A P C E G H lo M N O Wild Planet Conservation 2019 Total Revenue 1 2 March Feb May Total Jan Apr 5 6 7 8 Total - - - 9 No No No No 10 Goal met? No 11 12 13 14 15 16 17 18 19 Documentation Local Offices Consolidated California Washington Spring ..+ Oregon E 110 Enter 3:12 PM a O Type here to search w w 2/25/2019