HS 02h2lobFairAttendance - Excel SIMS X 0.30 Points: XL Step 2.2.2: Use th AVERAGE Function File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do... Share . Calibri - 11 -AA === 25 General X LO 3 - Conditional Formatting - Insert Farmat as Table. S Delete- Cell Styles - Furmal- 6 EM. Paste | | | | | |-- a. A. $ . % 8 22 Sort & Find & Filter Select- Chiboard Font Alignment Numer Styles Calls Editing In cell B20, enter a function to calculate the average attendance for all of the locations for the year 2022. A3 A B D E F G L M N 2 Location Altamonte Springs 8 Central Orlando 7 Caselberry 8 Kissimmee 9 Lake Mary 10 Mount Dora 11 St. Cloud 12 Total Attendance: 13 14 2022 Admission Fee: 15 16 Total Attendees (2018-2022): 2018 1,580 7,873 4.580 2,520 1,938 3,647 4,687 26,825 2019 2.109 8,145 4,879 2.641 2.325 3.879 4,873 28,851 2020 1.988 9.683 5.105 2.598 2542 3,764 4.998 30,678 2021 2.247 10,204 4,952 1,850 2.900 3,320 5.311 30,784 2022 2.307 10.657 4,000 2.000 4 501 3,548 5,687 32,700 2022 Increase 60 453 (952) 150 1,601 228 376 H H 1 J 2022 Percent of 2022 Total 2022 Total Total Admission Fees Profit 7% $ 36,796.65 $ 47,301.28 33% $ 169,979.15 $203,715.36 12% S 63,800.00 $ 76,925.48 6% $ 31,900.00 $ 41,583.12 14% $ 71,790.95 $ 88,174.02 11% $ 56,590.60 $ 69,893.57 17% $ 90,707.65 $ 106,215.52 $ 521,565.00 $633,808.35 2022 % of Profit from Admission 78% 83% 83% 77% 81% 81% 85% 5 of 10 Attempts Remaining: 5 $15.95 E View All C Reset 149,838