Zahoor Ahmad

 

Home

AIOU

MIU

IMCB H9

Contact

 

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.