Hands on Exercise 3 Simulation Exam Yuqiang re httpssim5 peg

Hands on Exercise 3 Simulation Exam Yuqiang re https//sim5, pegasus pears oncmg.com/SIM5 e02h3JobFairAttendance Excel Page Layout 9 Tell me what you want to do. Rh Conditional Formatting E-insert Cell styles fe -F5 20.11 1 Orlando Area Job Fair Compiled on 7/17/2015 Annual Attendance by Location 2018 Percent of 2018 Total 2018 Total Profit from 2015 2016 2017 2018 Increase Total Admission Fees profit Admission 2019 5 Altamonte Springs 580 2109 988 2247 2307 7% 36,796.65 47,301.28 Central Orlando 7873 8145 9683 10204 10657 33% 169,979.15 $203,715.36 4952 4000 (952) 4879 5105 12% 63,800.00 76,925.48 4452 8 Kissimmee 2520 2641 2598 850 2000 50 6% 31.900.00 41,583.12 2100 14% 71,790.95 88,174.02 9 Lake Mary 1938 2325 2542 2900 450 1.601 8156 4726 5010 11% 56,590.60 69,893.57 Mount Dora 3647 3879 3764 3320 3548 228 81% 4687 4873 4998 5311 90,707.65 $106,215.52 5687 376 85% 1 St. Cloud Total Attendance: 26,825 28,8 30,678 30,784 32,700 521,565.00 $633,808.35 34.35 36e195 8s1 City Name: Kissimmee 14 2018 Admission Fee: 16 Total Attendees (2014-2018 149,838 17 Total Locations: 2018 Statistics 19 4,671 20 Average Attendance 4,000 Median Attendance: Attendance O Ask me anything Windows ALIEN w ARE 11:24 PM 2/1/2017 .00 Point XL Step 231: Use In cell H15, enter a VLOOKUP function to determine the 2018 percentage of total attendance for the city listed in cell H14 Use the range A5:H11 as the table array. of 3 E View All C Reset

Solution

The value that should be put in the cell H15 is 6% to determine the percentage of total attendance for city listed in cell H14.

The formula for determining this is VLOOKUP(H14,A5:H11,8,FALSE) because the Kissimmee is the value that is matching the H column.