MS Excel Functions and Formulas

According to the figure left write the necessary

formulas to calculate the average salary of all employees in the cell C10

According to the figure left write the necessary

formulas to find the maximum salary in cell C11

According to the figure left write the necessary

formulas to find minimum salary in cell C12

According to the figure left write the necessary

formulas to find the total salary in cell c13

Write a function in B14, so that, it will take the Sum of the Amounts (B2:B11), if the date in column B is less than the Due Date (B13).

In the left Figure, write a formula in A3 to calculate the multiplication of the numbers in range A1:F1

In the left Figure, write a formula in B6 to calculate the absolute value of the given number in A6.

In the left Figure, write a formula in D6 to calculate the square-root of the given number in C6.

In the following Figure, write a formula in F7 to calculate x^y

In the left Figure write a formula in cell B3 to convert degree in radian