Question

To calculate the average SAT score that meets two conditions: scores in the range I11:I67 are greater than or equal to 3500 and final decisions in the range J11:J67 are early admissions (cell E3), using mixed references appropriately, you can use the following AVERAGEIFS function in cell I5:

a) =AVERAGEIFS(I11:I67, J11:J67, "Early Admissions", I11:I67, ">=3500")
b) =AVERAGEIFS(J11:J67, E3, "Early Admissions", I11:I67, ">=3500")
c) =AVERAGEIFS(I11:I67, J11:J67, ">=3500", E3, "Early Admissions")
d) =AVERAGEIFS(I11:I67, E3, "Early Admissions", J11:J67, ">=3500")

Answer 1

The correct AVERAGEIFS function to calculate the average SAT score for scores greater than or equal to 3500 and early admissions is option a) =AVERAGEIFS(I11:I67, J11:J67, "Early Admissions", I11:I67, ">=3500"). It averages scores that meet both conditions specified.

Step-by-step explanation:

To calculate the average SAT score for students who have scores greater than or equal to 3500 and were admitted through early admissions, the correct AVERAGEIFS function to use in cell I5 is:

a) =AVERAGEIFS(I11:I67, J11:J67, "Early Admissions", I11:I67, ">=3500")

This function will calculate the average of the scores in the range I11:I67, with the conditions that the scores are greater than or equal to 3500 (I11:I67, ">=3500") and that the final decisions corresponding to those scores in the range J11:J67 are 'Early Admissions' (which is assumed to be the content of cell E3).

It's important to note that the provided function assumes that 'Early Admissions' is the criteria directly in the function. If the actual criterion for early admissions is stored in cell E3, it would be referenced as E3 without the quotation marks.