QUESTION NO.6
Ms. Sajeev intends to apply for Civil Service examination this year . But the upper age
limit is 32 as on 01/08/2016. Determine whether he is eligible to apply or not. Based
on the cut off age . His date of birth is 06/09/1982 using appropriate Spreadsheet
function
Procedure and Answers
Step 1 Open Libre Office Calc
Step 2 Enter the date in the spread sheet B101/
08/2016, B206/
09/1982
Step 3 Compute the date value of such date in B3 and B4 by the formula
B3=DATEVALUE(“01/08/2016”)
B4=DATEVALUE(“06/09/1982”)
Step 4 Calculate difference between these date values in the cell B5 by the formula
=B3B4
Step 5 Calculate the age of the person in the cell B6 by the formula
=Round(B5/365.25)
Step 6 Determine the Eligibility with the formula in cell E2
=IF(D2>=32,”Eligible”,”Not Eligible”)
ANSWER:AGE:
34
Not Eligible.