Define the following(i) Text Operator(ii) Rows and Columns of spreadsh

1.	Define the following(i) Text Operator(ii) Rows and Columns of spreadsheet.
Answer» (i) Text Operator: In Calc, “&” is a text operator which is used to combine two or more texts as a single text. Joining two different texts is also known as “Text Concatenation”. An expression using the text operator has the following syntax: (ii) Rows and Columns of spreadsheet: the formula bar contains the worksheet of work area which consist of grid cells The worksheet has number of rows and columns, where each column is labelled as A, B, C, D … AA, AB, AC … and the rows are numbered from 1,2,3 … OpenOffice Calc version 4.1.5 contains 1024 columns and 10,48,576 rows. Column heading starts from A and end with AMJ. In the case of Microsoft Excel 2016, there are 16,384 columns (A to XF(d) and 10,48,576 rows available.

Define the following(i) Text Operator(ii) Rows and Columns of spreadsheet.

Answer»

(i) Text Operator:

In Calc, “&” is a text operator which is used to combine two or more texts as a single text. Joining two different texts is also known as “Text Concatenation”. An expression using the text operator has the following syntax:

(ii) Rows and Columns of spreadsheet:

the formula bar contains the worksheet of work area which consist of grid cells The worksheet has number of rows and columns, where each column is labelled as A, B, C, D … AA, AB, AC … and the rows are numbered from 1,2,3 … OpenOffice Calc version 4.1.5 contains 1024 columns and 10,48,576 rows. Column heading starts from A and end with AMJ. In the case of Microsoft Excel 2016, there are 16,384 columns (A to XF(d) and 10,48,576 rows available.

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