Question

etcRXEAcPMbcOqJA1FBJmmqaRB4fgAgzOddr32eV 10.00 Points: XL Step 2.2.4: Use the 2 ShareMIN, MAX, and COUNT Functions MS In cell B22, enter a function to calculate the minimum attendance for the year 2018. In cell B23, enter a function to calculate the maximum ˇ attendance for the year 2018. In cell B17, enter a function that will count the number of locations the Job Fair was held in 2018.

Answer 1

Basically, for calculating the minimum attendance for the year 2018, you need to first identify the cells containing attendance of the year 2018 then you need to apply min function like MIN() and pass the cells as arguments, and write the function in B22.

Then for calculating the maximum attendance for the year 2018, you need to first identify the cells containing attendance of the year 2018 then you need to apply max function like MAX() and pass the cells as arguments, and write the function in B23.

Then for counting the number of locations where the job fair was held in 2018, you need to first identify the cells containing the data and then you need to apply count function like COUNTA() and pass the cells as arguments and write the function in B17

Demo Screenshots:

Apply any function like and press enter:

Conditional Format as Cel Formatting Table\"" Styles B 1 u-1?. e?-A-1 insert Delete Format Sort & Find & Filter Select & Center Clear Cells Editing Job Fair Locations 2018 Austrailia 1 Attendance 2018 England 10 19 21 -MIN(A2:A11 MIN(number1, [number2],.) Sheet1! ? Edit ???- \r\n??. Book1 - Excel Ashish Shrivastav 0 ? Insert Page Layout Formulas Data Review View Help Team Tell me what you want to do Cut E Copy ? AutoSum . A Insert Delete Format ? 1 u . ii.,.?.?. ?Merge & Certer ,, % , ?48 Conditional Format as Cel Sort & Find & Filter Select\"" ??? . Format PainterBI u Clear Formatting . Table\"" Styles . Editing B18 1 Attendance 2018 Job Fair Locations 2018 Austrailia England 10 18 21 Sheet1! ? Ready ?? + 100% 983 78 80 90 81 90 70 77 93 90 75 "",""error"":null,""modified"":1555280236,""source"":""automated""}"

Results will look like in respective cells: