1. Update the All Locations worksheet as follows:
   1. In cell B7, enter a formula using the SUM function, 3-D references, and grouped worksheets to total the values in cell B7 on the Highland Hotel:Pinehill Lodge worksheets.
      1. Copy the formula you created in cell B7 to the range B7:M11 without copying any cell formatting. (Hint: Use the Paste Gallery.)

B7 x Fix J K L M N G H I Adela Mountain Resort All Locations 12/11/2019 2019 Monthly Rentals June July Room January February March April May August September October November December Total 71 82 93 10 4 11 5 oooo 2019 Monthly Revenue June July Room March April May August September October November December Total 13 14 15 | 162 173 January - February $ $ - $ - $ - $ $ $ - - - -. - - Total $ - $ - $ - $ - $ - $ - $ $ - $ - $ - $ - $ - $ . 22 23 Documentation Inn Mortgage Highland Hotel Adela Condos Pinehill Lodge New Inn All Locations Cabin ... Enter B7 x Fix J K L M N G H I Adela Mountain Resort All Locations 12/11/2019 2019 Monthly Rentals June July Room January February March April May August September October November December Total 71 82 93 10 4 11 5 oooo 2019 Monthly Revenue June July Room March April May August September October November December Total 13 14 15 | 162 173 January - February $ $ - $ - $ - $ $ $ - - - -. - - Total $ - $ - $ - $ - $ - $ - $ $ - $ - $ - $ - $ - $ . 22 23 Documentation Inn Mortgage Highland Hotel Adela Condos Pinehill Lodge New Inn All Locations Cabin ... Enter