By examining the screenshot below, select the option that best indicates how to work out the average. Once you have worked out the average, also indicate whether the student achieved a distinction (75%) or not.

Question

By examining the screenshot below, select the option that best indicates how to work out the average. Once you have worked out the average, also indicate whether the student achieved a distinction (>75%) or not.

=MEAN(B2:B6); the student did not get a distinction.

=SUM(B2:B6/5); the student did get a distinction.

=AVERAGE(B2-B6); the student did pass and get a distinction.

=AVERAGE(B2:B6); the student did not get a distinction.

GPT-4o mini · Answer

The correct formula to calculate the average is =AVERAGE(B2:B6). Therefore, the best option is:

=AVERAGE(B2:B6); the student did not get a distinction.

In this case, you would need to check the actual values in the cells B2 to B6 to determine if the average is greater than 75% to confirm whether the student received a distinction or not.