Page 71 - iPro_trackGPT_V5_Class7
P. 71
What if you could use Excel to track the books you’ve read and the books you
want to read? How would you rate them and what genres would you include?
AUTO FILL
The Auto Fill feature in Excel allows you to quickly fill cells with repetitive or sequential data
by dragging the fill handle, a small square at the bottom-right of a cell. It can extend patterns,
series, and custom lists, or copy formatting as needed. To use the Auto Fill feature, follow the
given steps:
1 Enter the first two numbers and
select both the cells containing the
numbers you have entered.
2 Position the mouse pointer
over the bottom right corner of
the last selected cell.
3 Drag the mouse pointer over
the cells you want to include in
the series.
USING FORMULAS TO PERFORM CALCULATION
In Excel, formulas start with an equal sign (=). When a cell content begins with this sign, Excel
recognises it as a formula. If you omit the equal sign, Excel will treat the entry as text and the
calculation will not work.
Using formulas in Excel to perform calculations involves entering expressions that perform
mathematical operations on cell values.
To show how formulas work, we'll begin with a simple exercise by selecting blank cell A1.
Then type = 5 + 5, and press the Enter key. After you press the Enter key, Excel performs the
calculation and display the result as 10 in cell A1.
Enter some more formulas in other cells and see what results are shown by Excel.
1. =8 – 5 2. =8 * 5 3. =8/5 4. =8 ^ 5
The results will be 3, 40, 1.6, and 32768, respectively.
Some formulas based on the BEDMAS rule can be entered as:
1. =(8 + 5) – (2 + 3) ^ 2 2. =(9/3) * (4 ^ 2) – 5
More on Spreadsheets 69

