Write the syntax of direct insert method SUM function?

1.	Write the syntax of direct insert method SUM function?
Answer» SUM is the most frequently used function to add a set of values. The syntax of the SUM ( ) is = SUM (range 1; range 2; range 3 ……….. range n) If you want to know the sum of the values on A1, A2, A3, A4, A4 in A5, Place your cell pointer in A5 and directly type the formulae as follows. = SUM (A1 : A4)

Answer»

SUM is the most frequently used function to add a set of values.

The syntax of the SUM ( ) is

= SUM (range 1; range 2; range 3 ……….. range n) If you want to know the sum of the values on A1, A2, A3, A4, A4 in A5, Place your cell pointer in A5 and directly type the formulae as follows. = SUM (A1 : A4)

Discussion

No Comment Found

Related InterviewSolutions

The process of copy and paste can be replaced by a click and drag it is called as: (a) autofill (b) copy the cell (c) move the cell (d) delete the cell
Relational operators are also known as: (a) Comparative operator (b) Arithmetic operator (c) Logical operator (d) Boolean operator
What is a Cell pointer?
A continuous group of cell is called as: (a) range (b) reference (c) relational (d) text
Write about the text operator in OpenOffice Calc?
What is called range? Give its types?
Which is the reference concatenation operator used in calc? (a) , (b) ; (c) ~ (d) :
What is a Range reference operator?
Which is the range reference operator using worksheet? (a) , (b) ; (c) : (d) –
Which menu contains the commands which are used to modify the environment of Calc? (a) View (b) Insert (c) Tools (d) Help

Write the syntax of direct insert method SUM function?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment