Question

Write the formulas to calculate the following for each cell:-
a. -HRA is calculated as 10 % of Basic salary ---2m
b. -DA is calculated as 5 % of Basic Salary ---2m
c.- Bonus is 15% of Basic salary----2 m
d. -Total salary in 2020 is - Basic + HRA+DA-Loan installment+ Bonus----2 m
e. -Find the percentage increase in salary as compared to last year---2m
f.-Write the steps to format the table with proper border and shading----2m
g.-Write the steps to Insert a row below ---2m
h.-write the function to find the Maximum salary below the total salary column----2m
i.-Insert a row below and find the Minimum salary using functions ---2m

Answer 1

Answer:

a han is quality as 10% of biggest salary to metres be day is political as 5% of biggest salary to metre seaborn as is 15 February 2 metres the total salary in 220 is biggest + H R A Plus D a loan internal medicine + bonus to metres if find the percent in query in the salary components to last year to metres write the write the cement from the teva with proper border in selling to ji write the steps to insert a royal blue 2 metres at write the option to find the missing salary will O the total salary common to metres I insert ero below and find the minimum salary using sum to metre

Answer 2

Explanation:

Write the formulas to calculate the following for each cell:-

a. -HRA is calculated as 10 % of Basic salary ---2m

b. -DA is calculated as 5 % of Basic Salary ---2m

c.- Bonus is 15% of Basic salary----2 m

d. -Total salary in 2020 is - Basic + HRA+DA-Loan installment+ Bonus----2 m

e. -Find the percentage increase in salary as compared to last year---2m

f.-Write the steps to format the table with proper border and shading----2m

g.-Write the steps to Insert a row below ---2m

h.-write the function to find the Maximum salary below the total salary column----2m

i.-Insert a row below and find the Minimum salary using functions ---2m