In a high school with 3000 students, counselors are putting together a math tutoring program for the neighboring middle school. they plan to invite high school students with high average test scores to tutor middle school students, and they would like to offer gift cards to the student tutors. the counselors have a spreadsheet showing each student’s average test scores, and in order to find out how many gift cards they should purchase, the counselors need to count how many students would qualify to become tutors. which type of function would best the counselors determine the number of eligible students? sumif round countif averageif

The correct answer option is COUNTIF.

Explanation:

We are given that gift cards will be offered to students from high school who have high average test scores and we are to find out the number of eligible students who would qualify for it.

To find this, we will use the COUNTIF function since it is the one which calculates up the data in the cells if they meet the specified criteria mentioned in the formula.

COUNTIF

Countif is a function that will calculate the number of cells that meet a certain criteria. In this case, it will count the number of students that qualify based on their scores to become tutors.

ROUND will round numbers, SUMIF is similar to countif but for numbers (in this case we are counting names of students not scores/other numbers) and AVERAGEIF averages numbers that meet critera.

answermarginal cost;