|
Fundamentals of
Computers(3400)
MS Excel Lab Tasks # 3:
|
1 |
Make an excel spreadsheet according to instructions given below: |
|
|
a) |
Use the following logic to develop a double IF function: |
|
|
b) |
If Marks are less than 50, then it will be a grade C, If it is greater
than or equal to 50 but less than 70, then it will be grade B and if it is
great than or equal to 70, then it will be grade A. |
|
|
c) |
Use another IF function to enter remarks Good, Fair and Poor. |
|
|
d) |
The remarks should be highlighted using conditional formatting as shown in
the lecture. |
|
|
 |
|
If you find any advertisement showing some indecent material please report its web address (URL) on contact page.
It will help us to block such websites to show their ads in future. Sorry for inconvenience. |