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.

=AVERAGE(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.

GPT 3.5 · Answer

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

To work out the average, you would add up all the scores in cells B2 to B6 and then divide by the total number of scores, in this case, 5. The student did not achieve a distinction (>75%) as the average score is below 75.