Concept of Cell Address

The column range is the number of cells spread across the column. The cell address is represented by single column letter and multiple row number in a sequence. In this example the column letter C is constant with rows varying from 2 to 7. The range of cells starts in C2 and ends in C7. This range of cells consists of the cells, namely C2, C3, C4, C5, C6, and C7. The range of cells starts in C2 and ends in C7 and it is represented by C2:C7

The row range is the number of cells spread across the row. The cell address is represented by single row number with columns varying from B to D columns. The range of cells starts in B3 and ends in D3. This range of cells consists of the cells, namely B3, C3, D3, and it is represented by B3:D3

The row and column range is the number of cells spread across the row and columns. This range is a matrix with number of rows and number of columns. In this example, the range starts in cell B2 and ends in cell C7. This range of cells consists of the cells from B2 to B7 and cells from C2 to C7. The range it is represented by B2:C7 as shown in Figure 4.7. Note: The control key is used to select more than one ‘range of cells’ in a worksheet. The control key is marked as ‘Ctrl’ on the keyboard.

Qus. 1 : In a LibreOffice Calc, absolute cell reference can be represented as :

A3
$A$3
A$3
$A3

Qus. 2 : How many rows and columns are there in LibreOffice Calc?

1024 rows and 1048576 columns
10000 rows and 32000 columns
1,048,576 rows and 16,384 columns
None of above

Qus. 3 : In Libre Spreadsheet, Rows are labelled as ____?

A,B,C,….
1,2,3….
A1, B1, C1…
1A, 1B, 1C…

Qus. 4 : The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is?

C1:10H
C1:H10
C1:H-10
C1:H:10

Qus. 5 : Match the following cell referencing types with their descriptions.<table class="table table-bordered"><tbody><tr><td>Referencing Type</td><td>Description</td></tr><tr><td>A. Relative Reference</td><td>1. Does not change when the formula is copied ($A$1)</td></tr><tr><td>B. Absolute Reference</td><td>2. Changes automatically when the formula is copied to another cell</td></tr><tr><td>C. Mixed Reference</td><td>3. Refers to cells in a different spreadsheet or workbook</td></tr><tr><td>D. External Reference</td><td>4. Partially absolute and partially relative (e.g., $A1 or A$1)</td></tr></tbody></table>