Page 217 - IT_Play_V1.0 Class9
P. 217
Vertical/Column Range
Column range is the number of selected cells spread across the column.
Here, the selected vertical/column range is C1:C6. The range of cell starts
at C1 and ends at C6.
Horizontal/Row Range
Row range is the number of selected cells spread across the row.
Here, the selected horizontal/row range is A4:D4. The range of cells
starts at A4 and ends at D4. This range of cells consists of cell, namely
A2, B2 ,C2 and D2.
Row and Column/Mixed Range
Mixed range is the number of selected cells spread across the row
and column. Here, the selected mixed range is C3:E9. The range of
cell starts at C3 and ends at E9.
Selecting Cell Range
To select a range of cells, follow the given steps:
Step 1: Click, hold, and drag the mouse until all of the adjoining cells are highlighted.
Step 2: Release the mouse to select the desired cell range. The cells will remain selected until another cell in
the sheet is clicked.
Selecting More than One Range of Cells
To select more than one range of cells, follow the given steps:
Step 1: While the Ctrl key is pressed, click, hold, and drag the mouse
to select the range of cells.
Step 2: Release the Ctrl key and mouse button after completing the
selection of range of cells.
CREATING A SPREADSHEET
To work in LibreOffice Calc, the user needs to know how to work with Spreadsheet. LibreOffice Calc opens
with a new Spreadsheet named Untitled1 as the default spreadsheet where the user can begin to work or
create a new sheet. To do so:
Step 1: Click on the File menu from Menu bar. 1
2
Step 2: Select the New option. A drop-down menu 3
appears.
Step 3: Click on Spreadsheet. Or Click on the New
button from the Standard Toolbar. A new
spreadsheet named Untitled 1 appears on the
screen.
A new spreadsheet displaying the active Sheet1
appears on the screen with cell A1 as the active cell.
The shortcut to open a new Calc document with a default blank spreadsheet is Ctrl + N.
Create a Spreadsheet 215

