Question

f) Write the syntax of Count and Average function.​

Answer 1

Answer:

Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. ... For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.

Description. Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

Explanation: