Question

Q1. Write the functions or formulas for the following:
IT TEST SCORE CARD
ROLL NO. NAME PRACTICAL THEORY TOTAL TOTAL
% GRADE
1 VEENA 8 6
2 AASHISH 6 8
3 SURBHI 7 9
4 HARRY 9 8
5 SHUBH 8 9
MAX
MARKS
PRACTICAL 10
THEORY 10
a. Find the total of each student.
b. Calculate the total percentage of each student.
c. Find the grade of each student by keeping simple rule in view i.e., students scored below 85%
must get B+ while those above this baseline must be given as A+.
d. Also find the maximum marks and calculate the average marks of both practical and theory.
e. Count the number of students.

Answer 1

Answer:

face D-day. gun. Xavier. Chen. grace cdeza DC big