Excel Functions Practice - Student Marks

Objectives: Excel Functions Practice - Student Marks

Excel Functions Practice - Student Marks

Excel Function Exercise

Student Marks Table

Student Name Computer (C) English (D) Biology (E) Physics (F) Math (G) Total (H) Average (I) Status (J)
Anna 78 85 74 88 91
Brian 45 59 62 53 47
Catherine 90 93 85 88 94
David 69 71 65 70
i. Write the function to calculate the total marks of all subjects.
Answer: =SUM(C2:G2)
ii. Write the function to calculate the average marks of all subjects.
Answer: =AVERAGE(C2:G2)
iii. Write the function to find the highest mark in Computer (column C).
Answer: =MAX(C2:C5)
iv. Write the function to find the lowest mark in Math (column G).
Answer: =MIN(G2:G5)
v. Write the function to count the number of students who have marks recorded in Physics.
Answer: =COUNTA(F2:F5)
vi. Write the function to count the number of students who scored 80 and above.
Answer: =COUNTIF(H2:H5,">=80") (after total or average is calculated)
vii. Write an IF function in column J (Status) to display: PASS if a student’s average (column I) is 50 or above, and FAIL if below 50.
Answer: =IF(I2>=50,"PASS","FAIL")

Reference Book: N/A

Author name: SIR H.A.Mwala Work email: biasharaboraofficials@gmail.com
#MWALA_LEARN Powered by MwalaJS #https://mwalajs.biasharabora.com
#https://educenter.biasharabora.com

:: 1::

⬅ ➡