1.

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 the 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)



Discussion

No Comment Found

Related InterviewSolutions