Question

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information into column E. In column F, which function can be cut and pasted into different cells to tell the teacher if each student exceeded the satisfactory average?
=IF(E3>E8, “Exceeded”)
=IF(E3>$E$8, "Exceeded")
=IF(AVERAGE(E3:E6)>E8, “Exceeded”)
=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)

Answer 1

Answer:

=IF(E3>$E$8, "Exceeded")

or

=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)

Explanation:

Seeing the spreadsheet would have helped understand some curiosity about the row numbers present in the answers, and definitely zoom in the right answer.   For example we don't know for sure what's present in cell E8, and how it's calculated.

But without seeing the spreadsheet, I can only come to 2 answers, depending on the layout of the spreadsheet.

We know the formula wll be copied into many cells to see if a certain value is greater than the one in E8.  Since the formula will be copied, we want to keep the same reference point for each student.  When you copy a formula, Excel will adapt the cell addresses to the new context, UNLESS you block them... by using the $ sign.  So, the answer definitely has to have $E$8.

We don't know for sure if the teacher enters only one score per student or a group of them.

If the teacher enters only one score per student, then =IF(E3>$E$8, "Exceeded") would be the answer.

If the teacher enters 2 to 4 scores for each student, then =IF(AVERAGE(E3:E6)>$E$8, “Exceeded”) would be the answer.

Answer 2

B: =IF(E3>$E$8, "Exceeded")

i just took the test on Edg.