Excel Practice

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