Question

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

Answer 1

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.