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
=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
Answers
GPT 3.5
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.