IGNOU CITL 1 2026 2027 - Create a Student Marks Analysis Sheet in MS-Excel. Prepare an Excel sh

Question

Create a Student Marks Analysis Sheet in MS-Excel. Prepare an Excel sheet with
Enrolment Number, Student Name, Course 1, Course 2, Course 3, Course 4, Total,
Percentage, and Grade. Use formulas to calculate total marks, percentage, grade, highest
marks, lowest marks, and identify the top five students

31 Jul 2026

Answer :

Word Count : 298

MS-Excel can be used to create a Student Marks Analysis Sheet for recording, calculating, and analyzing students' academic performance. Start by opening a new workbook and create column headings as follows: Enrolment Number, Student Name, Course 1, Course 2, Course 3, Course 4, Total, Percentage, and Grade. Enter the enrolment number, student name, and marks obtained in each of the four courses for every student. The Total marks can be calculated by adding the marks of all four courses. If the marks are entered in cells

__________ ___ __________ __________ _____ _________ _______ _____.
________ ______ ____ _______ __________ ___.
_____ ______ ________ ___ ________ _____ _________ ____.
_________ ___ ___ ____ _____ ______.
_______ _______ ______ __________ ______ _______.
________ ____ ______ ___ ___ __________ ______ ________ __________ __________.
_________ ___ _____ ___ _________ ______ __________ _______.
______ _____ ___ ___ ________ ____ ____ __________ ___ _______ ____.
___ ___ ________ __________ _______ ________ ___ _________ __________ __________.
__________ _____ _________ __________ ____ ___ ___ ____.
__________ ____ _____ _______ ____ ___ ____.
___ __________ _____ _____ _________ ___ ____ _____ _________ _____ __________.
_____ ______ _____ ______ ____ _______.
___ ________ ________ _____ ________ _______ ___ _________ ___ _____.
___ ____ ___ ______ ___ ___ _______ ____ _________ _____.
_______ _____ ____ ________ ____ _________ ___ _________ _______ __________ ____.
___ _______ _______ _________ _______ ______ ______ __________ __________ _________.
______ ______ ________ ______ ___ ______ ___ ________ _____ ________ ___.
_______ ___ ______ _________ ______ __________ __________ _________ _____ __________.
___ ___ _____ ______ ___ __________ ____.
_______ ___ _____ ______ _____ ____ ______.
________ ___ ___ _______ _____ _________ _________ _________ _________ _____ ____ _______.
___ ________ __________ __________ ________ __________ __________.
______ ____ __________ _________ ___ ________ ____.
_______ _______ __________ _____ ___.

IGNOU ACADEMY

Your IGNOU journey, made easier.

Solved Assignments
Study Notes
Guess Papers
Question Papers

Call Us WhatsApp

STUDY • PREPARE • SUCCEED

Skip in 10

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers