Page 44 - modular4.0
P. 44
Chapter Profile
5 Chapter Profile Using Formulas to Perform Calculation
Order of Operation
Different Ways to Enter Formulas
Understanding Cell Range
Formulas and Cell Referencing in Formulas
and its Types
Functions
Functions
As you know, formulas are used to perform calculations in mathematics. In the same way, Excel
2019 also allows you to perform calculations by using formulas. In this chapter, we will learn about
formulas and different ways to add a formula in a worksheet. We will also learn about different
types of built-in functions in Excel.
USING FORMULAS TO PERFORM CALCULATION
Formulas in Excel 2019 begin with an equal to (=) sign. When the contents of a cell begin with equal
to sign, Excel 2019 understands that user has given a formula here. If you don’t enter the equal to
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
Clickipedia
Excel 2019 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.
You can also use cell addresses to perform calculation in the following way:
Notice that when the cell C1 is selected in the Formula bar shows the formula you just typed. You
can also calculate the sum of adjacent cells by pressing the Alt+= keys together after selecting the
cells.
42 Modular (Ver. 4.0)-VII

