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!
The table below shows the scores of students in some subjects. Copy the table and use Microsoft Excel to answer the question below.
a. What is the average score of each student?
Answer:
ALI YUSUF ⇒ =Average(B2:D2)
UNCE LILIAN ⇒ =Average(B3:D3)
AJAYI FEMI ⇒ =Average(B4:D4)
BAKO JAMES ⇒ =Average(B5:D5)
DAVIS JOY ⇒ =Average(B6:D6)
AMINAT ZAINAB ⇒ =Average(B7:D7)
b. What is the total score of the students in both English and Computer Studies?
Answer:
Working: Highlight the column containing English, then click on Autosum (∑)
Do the same for Computer studies.
Or you can use the SUM formula.
Click on cell B8 and add this formula for the English score total ⇒ =SUM(B2:B7)
For Computer Studies click on cell D8 and add the formula ⇒ =SUM(D2:D7)
c. Write the formula for finding the maximum score for Ajayi Femi.
Answer:
Formula = MAX(B4:D4)
d. Who scores the highest mark?
Answer:
Formula = MAX(B2:D7)
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.
