Page 316 - TP_IT_V1.0_C9_flipbpookl
P. 316

Tick ( ) if you know this.

                        Data in a cell without the formatting appears to be dull and non-interesting.
                        Numbers are not preceded by ‘0’.

                        A function is an already created formula in a spreadsheet that has a name followed by circular brackets.




                      SPEEDING UP THE DATA ENTRY

              LibreOffice Calc strongly supports the entering of text or other data. To speed up the process of data entry, there are a
              lot of important features in this program. We can drag and drop the cell content from one place to another by simply
              using a mouse click. Besides this, we can also use the Autofill feature, and cut/copy and paste the data to another place
              within the same or another sheet.
              Let us now see how Autofill and copy/paste work in a spreadsheet.

              Autofill Using Fill Handle for Generating Series

              The Autofill feature helps you fill a predictable series automatically in a range of cells using the fill handle. This series
              could be a sequence of digits, months, days, time, etc. The fill handle (i.e., the plus sign (+)) appears when the mouse
              pointer moves over the bottom right corner of an active cell. The small black square in the bottom-right corner of the
              selected cell or range is called a fill handle.

              Drag this handle down to the point till the series needs to be generated. It
              is important to write at least the first two members of the series as it would
              indicate the next elements in the sequence to be generated further.
              Let us understand this by taking an example of generating a series of multiples
              of 5.
              Step 1:  Type in the cells the first two numbers of the series, i.e., 5 and 10.
              Step 2:  Select the two cells you just typed in.
              Step 3:   Move the cursor to the bottom right corner of the selection, you will see that the cursor changes to a thin plus
                      sign (+). This thin plus sign is called a fill handle.
              Step 4:   Click and hold the left mouse button and drag the fill handle over the cells you want to fill. Here, drag the fill
                      handle to the right (or down) to fill in the series.
              The series is filled.
























                314   Trackpad Information Technology (Ver. 1.0)-IX
   311   312   313   314   315   316   317   318   319   320   321