Q5. Write the syntax of the function which find the average of thenumb

1.	Q5. Write the syntax of the function which find the average of thenumbers in a selected cell range in excel.
Answer» Answer: Average Cells with Numbers -- AVERAGE ENTER the SAMPLE data on your worksheet. In cell A7, enter an AVERAGE formula, to average the numbers in column A: =AVERAGE(A1:A5) Press the Enter key, to complete the formula. The RESULT will be 21.83, the average of the cells that contain numbers.

Q5. Write the syntax of the function which find the average of thenumbers in a selected cell range in excel.

Answer»

Answer:

Average Cells with Numbers -- AVERAGE

ENTER the SAMPLE data on your worksheet.

In cell A7, enter an AVERAGE formula, to average the numbers in column A: =AVERAGE(A1:A5)

Press the Enter key, to complete the formula.

The RESULT will be 21.83, the average of the cells that contain numbers.