What do you understand by ‘Function’ in Excel? Also, explain SUM and COUNT functions.

**Answer**

The built-in formulas are called functions. The users have to provide cell references or addresses only. These are called arguments of the functions that are given between a pace of parentheses ( ).

-SUM() function – Adds all the numbers in a range of cells

The Syntax is

=SUM(number1,number2,……)

**Ex.** =SUM (A1:A4) finds the sum of cells A1 through A4

COUNT() function – returns the number of cells that contain numbers.

The Syntax is

=COUNT(value1,value2,…….)

**Ex.** =COUNT(A1:A10)