This Quiz is protected.
Click on the "Subscribe Button" below to unlock.
Note: If you have Already Subscribed and you are seeing this message, it means you are logged out. Please Log In using the Login form Below to Carry on Studying!
(a) Type your surname and first name in the first row and fill in the scores for first, second, and third terms. (Note: Use the numbers between 0 and 100 to fill the scores).
(b) Type additional records for the remaining five (5) students showing their surname, first name and scores for each term.
(c) What is the total score of students in the first term?
Answer: 456
(d) What is the total score for students in the third term?
Answer: 358
(e) What is the formula for calculating the sum of scores for the second term?
Answer: =SUM(E3:E8)
(f) Create a new column titled “Average Score” after “Third Term” and calculate the average score for each student.
Solution:
Formula for calculating average for each student:
Folake Adesanya ⇒ =AVERAGE(D3:F3)
Etim Bukola ⇒ =AVERAGE(D4:F4)
Olajuyi Olamide ⇒ =AVERAGE(D5:F5)
Agba Joy ⇒ =AVERAGE(D6:F6)
Dike Gold ⇒ =AVERAGE(D7:F7)
Trent Arnold ⇒ =AVERAGE(D8:F8)
Note the formula, =SUM(D3:F3)/3 can also be used for Folake Adesanya
Please confirm you want to block this member.
You will no longer be able to:
Please note: This action will also remove this member from your connections and send a report to the site admin. Please allow a few minutes for this process to complete.
