Scribd
Upload
5 views4 pages

Student Marks and Grading Analysis

The document contains a table of subjects with total and obtained marks for a student, along with tasks for calculating grades and using Excel functions. It outlines tasks such as finding grades based on marks, implementing sum formulas, counting grades, and using VLOOKUP for subject marks. The grading criteria specify that marks above 85 receive an 'A' grade, while others receive a 'B'.

Uploaded by

veersami617
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
5 views4 pages

Student Marks and Grading Analysis

The document contains a table of subjects with total and obtained marks for a student, along with tasks for calculating grades and using Excel functions. It outlines tasks such as finding grades based on marks, implementing sum formulas, counting grades, and using VLOOKUP for subject marks. The grading criteria specify that marks above 85 receive an 'A' grade, while others receive a 'B'.

Uploaded by

veersami617
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Sheet1

Sr. No Subject Name Total Marks Obtained Marks


Urdu 100 86
Islamyat 100 75
Pak. Studies 100 95
Physics 100 88
Computer 100 90
Mathematics 100 70
Total Marks 0 2

Subject Name Obtained Marks


Computer 90

Page 1
Sheet1
Grade

Task 01
Using If find Grade if marks are

Task 02
Implement the sum formula to

Task 03
After finding the grade use coun

Task 04
Use VLOOKUP so that if you wr
Shows its obtained marks.
A
B

Page 2
Sheet1

find Grade if marks are above 85 it should A else B

ent the sum formula to calculate total marks

ding the grade use countif to count number of As and Bs

OOKUP so that if you write the name of subject it should


s obtained marks.

Page 3
Sheet1

Page 4

You might also like