C Secure 5Services/SIM5Frame.aspxTresLinkiD-20000017 82048d5f-d5a0-434b-b1ab-14b
ID: 3888170 • Letter: C
Question
C Secure 5Services/SIM5Frame.aspxTresLinkiD-20000017 82048d5f-d5a0-434b-b1ab-14b6b HOME INSERT PAGE LAYOUT FORMULAS DATA REVEW VIE Formatting- Table- Styes B21 MN 1 Orlando Area Job Fair 2 Annual Attendance by Location 2015%of 201S Percent of 2015 Total 2015 Total Profit from 2012 2013 2014 2015 Increase Total Admission Fees Profit Admission 2011 5 Altamonte Springs 6 Central Orlando 7 Caselbery 8 Kissimmee 9 Lake Mary 10 Mount Dora l St. Cloud 1.580 2.109 1.988 2.247 , 2.307 60 +7%$ 36,79655 $47.301.28 ,873 8,145 9.683 10 204 10,657 453 4.580 4,879 5,105 4952 4,00052 2,520 2,641 2,598 1,850 2.000 150 1938 2325 2.542 2,900 4,5011,601 647 3.879 3,764 3,320 3,548228 4.687-4,873 . 4.998- 5,311-5.687.-378__ 17%.--90,70755 - 0.21552. 33% $ 169,57.15 $201,ns36 12% $ 63,000.00 $76,925.48 6% $ 31x0.00 $41,583.12 14% $ 71,790.95 $8631402 11% $ 30,5 0.50 $ 6989157 81% 5 521,565.00 $633,808.35 Total Attendance:26,825 28,85 30,678 30,784 1,700 Keyboard Access 1.00 Point: X1. Sep 2.24: Use the MIN, MAX and COUNT Fundtions eanige ol 2 nr Qn Rest 8 of 16 Questions A In cell B22, enter a function to calculate the minimum attendance for the year 2015 o locations the Job Fair was cExplanation / Answer
* To calculate the minimum attendance for year 2015, use the below function
=MIN(B5:B11)
* To calculate the maximum attendance for year 2015, use the below function
=MAX(B5:B11)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.