Page 53 - 2611_SmartGPT Pro V(5.0) C-5

PURE
Excel follows BEDMAS rule for doing mathematical calculations. FACT

Some formulas based on BEDMAS rule can be entered as:

1. =(8 + 5) – (2 + 3) ^ 2 2. =(9/3) * (4 ^ 2) – 5
The elements of a formula are:

References: A cell or a range of cells that you want to use in your calculation.

Operators: Symbols (+, -, *, /, ^, $, %, etc.) that specify the calculations to be performed.

Constants: Numbers or text values that do not change.

COPYING A FORMULA
There are two methods to copy a formula:

Using the Fill Handle

Step 1: Select the cell that contains the formula, then
position the mouse pointer over the lower-right To calculate the sum of
adjacent cells:
corner of the cell until the black cross (+) appears. Short key

Step 2: Drag the fill handle over the cell or cells in which Alt + =
you want to copy the formula, then release the
mouse button.

Using Copy and Paste

Step 1: Select the cell that contains the formula, and click on the Copy command.

Step 2: Select the cell or cells that you want to copy.

a. To copy the formula and any formatting, click on the Paste command.

b. To copy the formula only, on the Home tab, click on the drop-down arrow of the
Paste command and select Paste Special, and then select Formulas and click
on the OK button.

Tick ( ) if you know this.

▶ Excel makes calculations easier.
▶ We can apply all types of mathematical operations like addition, subtraction,
multiplication and division in Excel.

Charts, Formulas & Functions in Excel 51