Hello I need to know how to input this in excel, please explain in layman's terms.

8. Kavanna now wishes to consolidate the data from each of the locations. Switch to the Consolidated Revenue worksheet. In cell A5, enter a formula without using a function that references cell A5 in the Boston worksheet. Copy the formula from cell A5 to the range A6:A10 without copying the formatting. 9. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the Boston:Chicago worksheets. Copy the formula from cell B5 to the range B6:B10 without copying the formatting. Then copy the formulas and the formatting from the range B5:B10 to the range C5:E10. 10. Kavanna wants to compare the revenue from the 2019-2020 season to the 2018-2019 season and needs to include the missing data. Open the support file Support_NP_EX16_6b_1819_Revenue.xlsx. Switch back to the NP_EX16_6b_FirstLastName_2.xlsx workbook and go to the Consolidated Revenue worksheet. Create external references in the Consolidated Revenue worksheet to the revenue information found in the Support_NP_EX16_6b_1819_Revenue.xlsx workbook as described below: a. Using external cell references, link cell G5 in the Consolidated Revenue worksheet to cell F5 in the Revenue worksheet in the Support_NP_EX16_6b_1819_Revenue.xlsx workbook. b. Using external cell references, link cell G6 in the Consolidated Revenue worksheet to cell F6 in the Revenue worksheet in the Support_NP_EX16_6b_1819_Revenue.xlsx workbook. c. Using external cell references, link cell G7 in the Consolidated Revenue worksheet to cell F7 in the Revenue worksheet in the Support_NP_EX16_6b_1819_Revenue.xlsx workbook. d. Using external cell references, link cell G8 in the Consolidated Revenue worksheet to cell F8 in the Revenue worksheet in the Support_NP_EX16_6b_1819_Revenue.xlsx workbook. e. Using external cell references, link cell G9 in the Consolidated Revenue worksheet to cell F9 in the Revenue worksheet in the Support_NP_EX16_6b_1819_Revenue.xlsx workbook. f. Using external cell references, link cell G10 in the Consolidated Revenue worksheet to cell F10 in the Revenue worksheet in the Support_NP_EX16_6b_1819_Revenue.xlsx workbook. g. Do not break the links. Close the Support_NP_EX16_6b_1819_Revenue.xlsx workbook. Your workbook should look like the Final Figures on the following pages. Save your changes, close the document, and then exit Excel. Follow the directions on the SAM website to submit your completed project.

A B D E F 1 Gentle Movers 2 3 4 5 Office Manager Boston Karen Janes NY Janice Perrochi DC Keith Shultz Chicago Marcus Gentile Assistant Manager Contact Jon Kennsington X512 Lori Forestorm X510 Abier Hale X577 Huiwei Young x546 6 7 8 9 2020 Rental Prices Gentle Movers Management 10 11 12 Documentation Branch Information Boston NYC DC Chicago Consolidated B D E F G 1 Gentle Movers Boston 2 3 4 Total $ 5 6 7 1st Quarter 35,750 $ 14,775 21,195 15,983 39,970 27,160 154,833 $ Pickup Truck Van 10' Truck 12 15' 17' Total 2nd Quarter 20,960 $ 22,490 77,014 51,809 19,448 32,032 223,753 $ 3rd Quarter 26,045 $ 30,740 29,447 71,180 32,156 27,460 217,028 $ 4th Quarter 50,435 $ 27,620 31,922 14,778 16,172 32,032 172,959 $ 00 09 133,190 95,625 159,578 153,750 107,746 118,684 768,573 11 $ 12 13 Documentation Branch Information Boston NYC DC Chicago Consolidated Rever . B D E F G 1 Gentle Movers NYC 2 3 4 Total $ 5 6 Pickup Truck Van 10' Truck 12' 7 1st Quarter 37,750 $ 24,775 31,195 25,983 29,970 37,160 186,833 $ 2nd Quarter 30,960 $ 12,490 77,014 41,809 29,448 12,032 203,753 $ 3rd Quarter 36,045 $ 20,740 29,447 71,180 32,156 37,460 227,028 $ 4th Quarter 30,435 $ 57,620 31,922 14,778 26,172 32,032 192,959 $ 00 0 135,190 115,625 169,578 153,750 117,746 118,684 810,573 15' 10 17' 11 Total 12 13 Documentation Branch Information Boston NYC DC Chicago Consolidated Rever + B D F G m 1 Gentle Movers DC 2 3 4 5 $ 6 7 1st Quarter 33,450 $ 13,375 25,495 17,813 32,270 29,660 152,063 $ Pickup Truck Van 10' Truck 12 15' 17' Total 2nd Quarter 21,860 $ 28,990 77,014 57,709 11,348 35,532 232,453 $ 3rd Quarter 24,545 $ 39,740 29,447 71,180 52,156 27,460 244,528 $ 4th Quarter 51,235 $ 22,220 31,922 14,778 16,172 32,032 168,359 $ Total 131,090 104,325 163,878 161,480 111,946 124,684 797,403 8 9 10 11 $ 12 13 Documentation Branch Information Boston NYC DC Chicago Consolidated Rever II. + B D F G m 1 Gentle Movers Chicago 2 3 4 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total 5 $ 6 7 8 Pickup Truck Van 10' Truck 12' 15' 17' Total 9 10 - 11 $ $ $ $ $ 12 13 Documentation Branch Information Boston NYC | DC Chicago Consolidated Revel ... (+ . B D F G . 1 E Gentle Movers 2018-2020 Consolidated Revenue 2 3 4 5 $ 6 7 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 106,950 $ 73,780 $ 86,635 $ 132,105 $ 52,925 63,970 91,220 107,460 77,885 231,042 88,341 95,766 59,778 151,327 213,540 44,334 102.210 60,244 116,468 58,516 93,980 79,596 92,380 96,096 493,728 $ 659,959 $ 688,584 $ 534,277 $ Pickup Truck Van 10' Truck 12' 15' 17' Total Total 2018-2019 Totals 399,470 $ 684 226 315,575 529,018 493,034 597,077 468,979 559,608 337,438 594 255 362,052 648,340 2,376,548 $ 3,612,524 8 9 10 11 $ 12 13 Branch Information Boston NYC II. DC Chicago Consolidated Revenue + A B D E F 1 Gentle Movers 2 3 4 5 Office Manager Boston Karen Janes NY Janice Perrochi DC Keith Shultz Chicago Marcus Gentile Assistant Manager Contact Jon Kennsington X512 Lori Forestorm X510 Abier Hale X577 Huiwei Young x546 6 7 8 9 2020 Rental Prices Gentle Movers Management 10 11 12 Documentation Branch Information Boston NYC DC Chicago Consolidated B D E F G 1 Gentle Movers Boston 2 3 4 Total $ 5 6 7 1st Quarter 35,750 $ 14,775 21,195 15,983 39,970 27,160 154,833 $ Pickup Truck Van 10' Truck 12 15' 17' Total 2nd Quarter 20,960 $ 22,490 77,014 51,809 19,448 32,032 223,753 $ 3rd Quarter 26,045 $ 30,740 29,447 71,180 32,156 27,460 217,028 $ 4th Quarter 50,435 $ 27,620 31,922 14,778 16,172 32,032 172,959 $ 00 09 133,190 95,625 159,578 153,750 107,746 118,684 768,573 11 $ 12 13 Documentation Branch Information Boston NYC DC Chicago Consolidated Rever . B D E F G 1 Gentle Movers NYC 2 3 4 Total $ 5 6 Pickup Truck Van 10' Truck 12' 7 1st Quarter 37,750 $ 24,775 31,195 25,983 29,970 37,160 186,833 $ 2nd Quarter 30,960 $ 12,490 77,014 41,809 29,448 12,032 203,753 $ 3rd Quarter 36,045 $ 20,740 29,447 71,180 32,156 37,460 227,028 $ 4th Quarter 30,435 $ 57,620 31,922 14,778 26,172 32,032 192,959 $ 00 0 135,190 115,625 169,578 153,750 117,746 118,684 810,573 15' 10 17' 11 Total 12 13 Documentation Branch Information Boston NYC DC Chicago Consolidated Rever + B D F G m 1 Gentle Movers DC 2 3 4 5 $ 6 7 1st Quarter 33,450 $ 13,375 25,495 17,813 32,270 29,660 152,063 $ Pickup Truck Van 10' Truck 12 15' 17' Total 2nd Quarter 21,860 $ 28,990 77,014 57,709 11,348 35,532 232,453 $ 3rd Quarter 24,545 $ 39,740 29,447 71,180 52,156 27,460 244,528 $ 4th Quarter 51,235 $ 22,220 31,922 14,778 16,172 32,032 168,359 $ Total 131,090 104,325 163,878 161,480 111,946 124,684 797,403 8 9 10 11 $ 12 13 Documentation Branch Information Boston NYC DC Chicago Consolidated Rever II. + B D F G m 1 Gentle Movers Chicago 2 3 4 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total 5 $ 6 7 8 Pickup Truck Van 10' Truck 12' 15' 17' Total 9 10 - 11 $ $ $ $ $ 12 13 Documentation Branch Information Boston NYC | DC Chicago Consolidated Revel ... (+ . B D F G . 1 E Gentle Movers 2018-2020 Consolidated Revenue 2 3 4 5 $ 6 7 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 106,950 $ 73,780 $ 86,635 $ 132,105 $ 52,925 63,970 91,220 107,460 77,885 231,042 88,341 95,766 59,778 151,327 213,540 44,334 102.210 60,244 116,468 58,516 93,980 79,596 92,380 96,096 493,728 $ 659,959 $ 688,584 $ 534,277 $ Pickup Truck Van 10' Truck 12' 15' 17' Total Total 2018-2019 Totals 399,470 $ 684 226 315,575 529,018 493,034 597,077 468,979 559,608 337,438 594 255 362,052 648,340 2,376,548 $ 3,612,524 8 9 10 11 $ 12 13 Branch Information Boston NYC II. DC Chicago Consolidated Revenue +