|
Fundamentals of
Computers(3400)
MS Excel Lab Tasks # 2:
|
1 |
Make an excel spreadsheet according as shown
below: |
|
|
a) |
Include dates in front of the names by using
date drop down menu. |
|
|
b) |
Find Defaulter status by using IF function. |
|
|
c) |
Find number of defaulters and non-defaulters
using COUNTIF function |
|
|
d) |
Set Row height : 20 and Column width : 15 |
|
|
 |
|
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. |