Scribd
Upload
3 views2 pages

Class Task Excel

The document outlines the steps to create a Student Result Sheet in Excel, including table creation, formatting, and formula application for grades and status. It also details the use of conditional formatting, absolute references for tax calculations, and the creation of a summary sheet with total students and average marks. Finally, it specifies the file naming convention for submission.

Uploaded by

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

Class Task Excel

The document outlines the steps to create a Student Result Sheet in Excel, including table creation, formatting, and formula application for grades and status. It also details the use of conditional formatting, absolute references for tax calculations, and the creation of a summary sheet with total students and average marks. Finally, it specifies the file naming convention for submission.

Uploaded by

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

Task: Create a Student Result Sheet

Step 1: Create Table (4 Marks)

Open Excel and create the following table:

ID Name Subject Marks Grade Status


101 Ali Math 78
102 Sara English 92
103 Ahmed Science 45
104 Ayesha Math 66
105 Bilal English 55

Step 2: Formatting (3 Marks)

Do the following:

 Make header row Bold


 Apply any fill color to header
 Change font color to white
 Apply All Borders
 Adjust column width using AutoFit

Step 3: Apply Formulas

1. Grade Column

Write formula to assign grade:

 A → Marks ≥ 80
 B → Marks ≥ 60
 C → Marks < 60

Use Nested IF

2. Status Column

 Pass → Marks ≥ 50
 Fail → Marks < 50

Use IF function

3. Calculate Below the Table

 Total Marks → SUM


 Average Marks → AVERAGE
 Highest Marks → MAX
 Lowest Marks → MIN

Step 4: Conditional Formatting


 Marks > 80 → Highlight Green
 Marks < 50 → Highlight Red

Step 5: Absolute Reference


 Write Tax Rate = 5% in one cell
 Create new column: Final Marks
 Formula:
Final Marks = Marks + (Marks × Tax Rate)
 Use $ (absolute reference)

Step 6: New Sheet


 Create new sheet named Summary
 Write:

o Total Students
o Average Marks

Submission:

Save file as:


👉 Assignment3_YourName.xlsx on LMS

You might also like