Excel Practice
Problem 1
There are five students in a particular class. Their scores in different exams are given below. All you need to do is to prepare an automatic grade sheet which will automatically calculate the grade of different students.
Grading Criteria:
A>= 90
B>= 87
C>= 84
D>= 81
Else F
Student name | Dept. | Mid
Term 1 111111111111 |
Mid
Term 2 2 |
Final | Assign
1 |
Assign.
2 |
Quiz 1 | Quiz 2 | Project | Attend. |
X | BBA | 90 | 75 | 36 | 15 | 9 | 7 | 11 | 10 | Perfect |
Y | BBA | 85 | 79 | 39 | 12 | 4 | 9 | 14 | 9 | Ok |
Z | ECO | 89 | 68 | 38 | 11 | 10 | 6 | 11 | 9 | Bad |
A | ENG | 63 | 74 | 39 | 15 | 10 | 8 | 14 | 8 | Ok |
B | ENV | 97 | 72 | 32 | 14 | 6 | 9 | 17 | 9 | Ok |
Full marks | 100 | 80 | 40 | 15 | 10 | 10 | 20 | 10 | Bonus | |
weight | 15% | 15% | 30% | 10% | 10% | 20% | – |
If the attendance is perfect then 5 points will be added to final score, if attendance is ok then 2 will be added. If attendance is bad then 2 will be subtracted from the final score.
2. Design a pivot table showing the department wise distribution of grade.
Problem 2
You want to purchase a car. The car needs 25% down payment. As a student you can’t afford to make a down payment more than 7890. In that case what will be the maximum price of the car you can avail?
Problem 3
A student got the following numbers in different exams of his Fin 670 course.
Exam Number Weight
Mid term 1 90 20%
Mid term 2 96 20%
Final ? 30%
Quiz 92 15%
Assignment 95 15%
To get an A he must obtain a comprehensive total of 93. What will be his final exam score to get an A?
Problem 4
Get acquainted with different types of graphs
Scenario Manager, Advanced Filter, database function, Naming range.
_best of luck-J