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
   212   213   214   215   216   217   218   219   220   221   222