Register
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
22.6k views
4 votes
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 help the counselors determine the number of eligible students?
SUMIF
ROUND
COUNTIF
AVERAGEIF

User Myz
by
4.7k points

1 Answer

1 vote
it’s been a while since i’ve done excel but i believe it is COUNTIF
the reason is it will only count a cell if it has certain qualifications
SUMIF adds every cell called
ROUND i believe just rounds everything up if called
AVERAGEIF will average out the cells if they have certain qualifications
User Micho
by
5.2k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

5.6m questions

7.3m answers

Other Questions

_____ reminds customers and clients that they made a good choice in selecting a company with which to do business, or it reminds them of the good qualities of their purchase.​
On august 1 the darius co. purchased a photocopy machine for $8,000. the estimated annual depreciation on the machine is $1,680. if the company prepares annual financial statements on december 31, the
When president obama was elected, the u.s. economy was in trouble, and has slid into a recession. consumer spending was low and getting worse. in an effort to stop the decline, president obama proposed
Ensuring that an individual is who they claim to be is the function of _____. select one: a. confidentiality b. authorization c. availability d. authentication e. nonrepudiation
The current market price for good y is above the equilibrium price, and then the price of a subsitute good, x, increases. the demand curve for good y shifts as a result. what is the likely outcome of the
Link Copied!