Use Google Sheets and create a spreadsheet containing the marks of 10 students under the headings – student name, phone, and marks out of 100 in 5 different subjects. Find the students' grades in each subject using the formula below. Also, compute the Cumulative Grade Point Average for each student.
Cumulative Grade Point Average = Average of Grade Points of all the subjects.
Grade Points: A-5; B-4; C-3; D-4; E-1.
The Grades are computed as:
If marks >= 75 Grade = A;
If marks <75 and marks >= 60 Grade = B;
If marks <60 and marks >= 50 Grade = C;
If marks <50 and marks >= 40 Grade = D;
If marks <40 Grade = E;

To create a Google Sheets spreadsheet containing student marks, calculate grades, and compute the Cumulative Grade Point Average (CGPA) for each student, follow these steps:

1. Create the Spreadsheet

1. Open Google Sheets:

   • Go to Google Sheets and create a new blank spreadsheet.

2. Set Up Column Headings:

   • In row 1, enter the following headings in columns A to G:
     • A1: Student Name
     • B1: Phone
     • C1: Subject 1
     • D1: Subject 2
     • E1: Subject 3
     • F1: Subject 4
     • G1: Subject 5
     • H1: Grade Subject 1
     • I1: Grade Subject 2
     • J1: Grade _________ ___ __________ _______ _______.
       ___ ________ _______ ____ ____ ___ ___.
       ____ ____ ________ ___ ______ __________ __________.
       _______ _________ _________ __________ ____ _____ ________ ________ ________ _________ ______.
       ___ ______ _____ _______ ___ _________ _____ _______ ___ _____ ___ _____.
       ______ __________ ____ ________ ___ __________ __________.
       _______ _______ ____ ________ ____ ____ _______ _______ ____ ____.
       ____ ________ __________ _________ __________ _____ _____ ___ ________ _________.
       ________ ___ ______ ________ ____ ________ _________ ________ _______ ___ ___.
       _____ _______ _______ _____ _______.
       ________ _______ ____ ___ ______ ________ _______ __________ ______.
       _______ _____ ________ _______ _________.
       __________ ____ ___ _______ _____.
       ________ ____ _____ ________ _____ __________.
       _____ ____ ________ ________ ___.
       _____ ____ __________ __________ ____ ________ _________ _____ ____ ____ _________ __________.
       _______ ____ ________ ____ _________.
       _________ ___ ______ __________ _________ _____ ___.
       _____ _____ _____ ________ _____ _________ _______.
       _________ ____ ___ _______ _______ ______ _____ _____ ___ ____ ________.
       ______ ________ _____ ___ _________.
       _________ __________ ______ _____ _________ ___ ________ ______ ___ _______ _________.
       _______ _________ _______ ____ ________ _____ ____ _______ ______ _________ _____.
       _______ _______ _______ _______ __________.
       _________ ___ _________ _____ _________.
       _________ ________ ___ ______ _______ ________ _________ ________ __________ _________ ___.
       ________ _________ __________ _____ ____ __________ _________ ________ __________ ____ ________ ____.
       _______ ________ __________ _______ ______ _____ _______ ________ ___ _____.
       ___ ___ _____ _______ ___ ______ ____.
       _________ _____ _________ _____ ___ ____ _______ _______ ______ ________ ________ __________.
       ______ ____ _________ _______ ____ __________ __________ _____ ___ ___ _________.
       ________ _________ ________ __________ _________ ________ _________ __________ _______ ____ ________ ___.
       ______ _______ ____ ___ ______ ________.
       _______ _____ ___ _________ _______ ___ _______ ___ _____ _____ ____.
       ____ _________ __________ _____ ____ ________ _____ ___ __________ ____ __________ ___.
       ________ ___ ______ __________ ____ ________ __________ __________ _________ ____ ______ __________.
       ___ _____ ________ ____ _______ ______ _________.
       _______ ________ __________ ______ ____ ____ _____ ________ _______ ____ __________.
       ____ _____ ___ ________ ________ ____ _________ _____.
       ______ _____ ______ __________ _________ ______.
       __________ ______ ____ ______ ___ __________ ______ ____ _____ __________.
       _________ ____ _________ ________ ______ _______ __________ ____ ______ ______ _________ __________.
       ________ ____ ___ _______ ________ _______ __________ _____ _______ __________ ___ ___.
       _______ _______ ______ __________ _________ ______ _____ ______.
       _________ _____ ____ ________ _______.
       _________ ____ _________ ___ _____ ____ _______.
       _________ _____ ______ ____ ______ ______ _____ _____.
       ________ _______ ________ ___ ______ __________.
       _____ ___ _______ ___ ______ _________ _________.
       _______ ________ ______ _________ ________ ______ ______ ________ ________ ________ ____ ________.
       ________ __________ _________ _______ __________ __________ _____.
       _____ ___ __________ ______ ______ _____ ___ ____ ________ ______ _________ _________.
       ______ ______ _____ _____ __________ ____ ________ ________.
       _____ ______ __________ ______ ________ _______ ____ __________ ______.
       _________ _______ ________ _________ _________ _________ _________.
       ____ ___ ______ ____ ______ __________ ________ _________ ___ ____ _____ ____.
       _________ ____ ___ _______ _______ ____ __________ ______ ______ ______ ______.
       Get Full Answer on WhatsApp