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
   245   246   247   248   249   250