Excel 1
Homework Problems for Excel Chapter 5 Conditional Functions
In column D display the following based upon the condition:
If all values are a six, display “BUNKO!!”
If 2 values are the same, display “DO OVER”
If no values are the same, display “Pass the Dice”.
b. Create an EXCEL worksheet that invokes the following grading rules:
|
Overall Score |
Grade |
|
90 and above |
A |
|
80 t0 89.9 |
B |
|
70 to 79.9 |
C |
|
60 to 69.9 |
D |
|
Below 60 |
F |
Have the user input a grade between 0 and 100. If user enters an invalid grade, the IF statement should display “INCORRECT GRADE”.
c. Modify problem b. to include plusses and minuses. Consider using the MOD function to determine whether to append a ‘+’ or a ‘-‘.
|
OVERALL SCORE |
Grade |
|
97-100 |
A+ |
|
93 – 96.9 |
A |
|
90 – 92.9 |
A- |
|
87 – 89.9 |
B+ |
|
83 -86.9 |
B |
|
80 – 82.9 |
B- |
etc, etc, etc.