Question

Name the Excel function that will be used for the following Jobs.
1. To enter today's date in the cell. .......
li.To find out the square root of a number. ......
ili. To find out the highest number in a series of numbers.
iv.To find out the average of cell range.​

Answer 1

1. =NOW()
2. AUTO SUM - SQUARE ROOT OPTION
3. AUTO SUM - MAX OPTION
4. SELECT THE CELL RANGE - AUTO SUM - AVERAGE OPTION

Answer 2

i. JUST DATE =DAY(NOW))

ii. SQUARE ROOT =SQRT(25)

iii. MAXIMUM =MAX(H3:M3)

iv. AVERAGE =AVERAGE(C3:C14)