What is a Range reference operator?

1.	What is a Range reference operator?
Answer» Colon (:) is the range reference operator. It is used to group a range of cells. An expression using a range operator has the following syntax: reference left : reference right. Where reference left is the starting cell address of a linear group of cells or upper left comer address of a rectangular group of cells. Reference right may be a last cell address of a linear group or lower right comer address of a rectangular group of cells.

Answer»

Colon (:) is the range reference operator. It is used to group a range of cells. An expression using a range operator has the following syntax: reference left : reference right.

Where reference left is the starting cell address of a linear group of cells or upper left comer address of a rectangular group of cells. Reference right may be a last cell address of a linear group or lower right comer address of a rectangular group of cells.

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

What is a Range reference operator?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment