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 nameDept.Mid

Term 1 111111111111

Mid

Term 2

2

FinalAssign

1

Assign.

2

Quiz 1Quiz 2ProjectAttend.
XBBA90753615971110Perfect
YBBA8579391249149Ok
ZECO89683811106119Bad
AENG63743915108148Ok
BENV9772321469179Ok
Full marks10080401510102010Bonus
weight15%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

Disclaimer:

The information contains in this web-site is prepared for educational purpose. This site may be used by the students, faculties, independent learners and the learned advocates of all over the world. Researchers all over the world have the access to upload their writes up in this site. In consideration of the people’s participation in the Web Page, the individual, group, organization, business, spectator, or other, does hereby release and forever discharge the Lawyers & Jurists, and its officers, board, and employees, jointly and severally from any and all actions, causes of actions, claims and demands for, upon or by reason of any damage, loss or injury, which hereafter may be sustained by participating their work in the Web Page. This release extends and applies to, and also covers and includes, all unknown, unforeseen, unanticipated and unsuspected injuries, damages, loss and liability and the consequences thereof, as well as those now disclosed and known to exist.  The provisions of any state’s law providing substance that releases shall not extend to claims, demands, injuries, or damages which are known or unsuspected to exist at this time, to the person executing such release, are hereby expressly waived. However the Lawyers & Jurists makes no warranty expressed or implied or assumes any legal liability or responsibility for the accuracy, completeness or usefulness of any information, apparatus, product or process disclosed or represents that its use would not infringe privately owned rights. Reference herein to any specific commercial product process or service by trade name, trade mark, manufacturer or otherwise, does not necessarily constitute or imply its endorsement, recommendation or favouring by the Lawyers & Jurists. The views and opinions of the authors expressed in the Web site do not necessarily state or reflect those of the Lawyers & Jurists. Above all, if there is any complaint drop by any independent user to the admin for any contents of this site, the Lawyers & Jurists would remove this immediately from its site.