Question

Write any five formula and explain their functions

Answer 1

Explanation:

Common functions

S/N FUNCTION DESCRIPTION

04 AVERAGE Calculates the average value in a range of cells

05 COUNT Counts the number of cells in a range of cells

06 LEN Returns the number of characters in a string text

07 SUMIF Adds all the values in a range of cells that meet a specified criteria. =SUMIF(range,criteria,[sum_range]

Answer 2

Answer:

Common functions

S/N FUNCTION DESCRIPTION

04 AVERAGE Calculates the average value in a range of cells

05 COUNT Counts the number of cells in a range of cells

06 LEN Returns the number of characters in a string text

07 SUMIF Adds all the values in a range of cells that meet a specified criteria. =SUMIF(range,criteria,[sum_range])