Enter data for 10 persons.
Align the data item in the center of a Cell.
Use the formula ‘Total Pay = Basic Pay + HRA + TA + DA’ to calculate the Total Pay.
Use the formula ‘Net Pay = Total Pay – Tax’ to calculate the Net Pay.
Heading ABC Corporation should be Bold, Center of a Cell and must be underlined.
Using the Name and Basic Pay draw a Line, Bar, Pie and Column Chart.
Add filter to the above data and view selected rows based on different criteria.