Page 250 - CA_165_V2.0_C9_Flipbook
P. 250
26. Study spreadsheet given below and write the solution for the specifications that follow: [4]
Specification 1: The Total Marks column should contain the total marks obtained by each student.
Write the formula to calculate the total marks for each student.
Specification 2: Write the formula to calculate the percentage of each student.
Specification 3: Identify the student who secured the first rank in the class based on the given data.
Specification 4: Write the formula to calculate the average marks of each student across all subjects.
248 Touchpad Computer Applications (Ver. 2.0)-IX

