Q1.
- Take a new workbook.
- Create a mark sheet and calculate total, percentage, number of students, maximum percentage, minimum percentage.
- Format it appropriately.
- In marksheet evaluate result as “Pass” or “Fail”.
Show grade and rank using appropriate formula.
Q2.
Create a salary slip and calculate DA, TA, MA, FA, HRA, PF, GROSS-SALARY.
Q3.
Make a table to check whether a person is eligible for voting or not.
Q4.
Make a table to calculate person’s age as a year in fractions, months, days, years.
Q5.
Apply conditional formatting to mark sheet.
