Question

use the excel screenshot to answer the following
(a) the formula in cell h6 is \= countif(scores,\ < 26\) what is it computing?
(b) how many students got between a 26 and 30, 26, 30)?
(c) what formula is entered into cell j7?
click the icon to view the excel screenshot

(a) what is the formula computing?
a. the number of scores below 26 and above 22.
b. the number of scores below 45
c. the number of scores below 26
d. the number of scores around 26

Explanation:

The formula =COUNTIF(scores,"< 26") in Excel's COUNTIF function counts the number of cells in the "scores" range that meet the criteria of being less than 26. Option A introduces an upper limit (above 22) which isn't in the formula. Option B has a criterion (below 45) not matching the formula. Option D's "around 26" is not what the "< 26" criterion represents. Only Option C correctly describes the formula's purpose.

Answer:

C. The number of scores below 26