EXCEL

Question 1

excel function that gives the total of the selected range of cell values. It performs the mathematical operation which is addition.

Answer 1

SUM()

Question 2

Excel function that focuses on calculating the average of the selected range of cell values.

Answer 2

AVERAGE()

Question 3

counts the total number of cells in a range that contains a number. It does not include the cell, which is blank, and the ones that hold data in any other format apart from numeric.

Answer 3

COUNT()