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.

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

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

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

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

1 points

GPT 3.5 · Answer

The option that best indicates how to work out the average is "=AVERAGE(B2:B6)". After calculating the average using this formula, the student did not receive a distinction.