Page 31 - Plus_V2.2_C6_Flipbook
P. 31
Step 4: Drag the mouse pointer over the cells you want to include in the series. The cells display the
number series automatically.
Series after using AutoFill
Let’s PraCtiCe Subject Enrichment
Create an Excel worksheet having a list of months and expenditure in each month. Use the
Autofill to fill the names of months.
USING FORMULAS TO PERFORM CALCULATION
Formulas in Excel begin with an equal (=) sign. When the contents of a cell begin with equal to sign,
Excel understands that user has given a formula here. If you don’t enter the equal sign, Excel will treat
your entry as text and the calculation will fail.
To show how formulas work, we'll begin with a simple exercise by selecting blank cell A1.
Then type = 5 + 5, and press Enter key. As you press the Enter key, Excel performs the calculation and
produces the result as 10 in cell A1.
Enter some more formula 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 BEDMAS rule can be entered as:
1. =(8 + 5) - (2 + 3)^ 2 2. =(9/3) * (4 ^ 2) - 5
Tech Fact
Excel follows 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.
More on Excel 2016 29

