Page 75 - Trackpad_ipro 4.1_Class7
P. 75
AUTOFILL
AutoFill feature automatically fills a series of data in your worksheet. It saves your time by
completing the text or number series for you. To use the Autofill feature, follow the given steps:
1 Enter the first two numbers and
select both the cells containing the
2 Position the mouse pointer numbers you have entered.
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
Formulas in Excel begin with an equal to (=) sign. When the contents of a cell begin with an equal
to (=) sign, Excel understands that the user has given a formula. If you don’t enter the equal sign,
Excel will treat your entry as text and fail the calculation.
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
Clickipedia
Excel follows the BEDMAS rule for doing mathematical calculations, where B stands for Brackets, E
for Exponentiation, D for Division, M for Multiplication, A for Addition, and S for Subtraction.
You can also use cell addresses to perform calculations in the following way:
More on Spreadsheets 73

