• • In cell B20 , enter a function to calculate the average attendance for all the locations for the year 2022 ?
  •   
  • 
    
  • 
    
  
  

 

E File Home Insert Page Layout Formulas Data Review e02h2JobFairAttendance-Excel View Tell me what you want so do x SIMS S Calibe 11AA Gel Conditional Formatting Insert Paste . S.A. $% Format as Table- Delete WE 584 Cell Styles Cleerd Seit & Find & Filter Select For N Alig 9 Nunber Caly 84 x 2014 A B C D E F G H T 2018 2018 Percent of Location 2014 2015 2016 2017 2018 Increase Total 2018 Total Admission Fees Altamonte Springs 1,580 2.109 1.988 2,247 2.307 60 6 Central Orlando 7.873 8,145 9.683 10,204 10,667 453 7% $ 33% S 2018 Total Profit 16,796.65 $ 47,301.28 K 2018 % of Profit from 9 Admission 70% 169.979.15 $201,715.36 81% 7 Caselberry 4.580 4.879 5,105 4.952 4,000 (952) 12% $ 63,800.00 $ 76.525.48 13% Kissimmee 2.520 2.641 2.598 1.850 2,000 150 0% 5 9 Lake Mary 1,938 2.325 2.542 2.900 4.501 1.601 14% $ 31,900.00 $41.583.12 71,790.95 $ 8,174.02 77% Attendance Rewly Ask me anything 2.00 Points XL Step 2.2.2 Use the AVERAGE Function In cell B20, enter a function to calculate the average attendance for the year 2018. 804 100% 3:21 AM 9/1/2019 Accessibly < > Attempts Redning View All Save 40 of 58 2 C Reset Submit