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

