Page 42 - Trackpad_V4.0_c6_Flpbook
P. 42
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 Hintbot
Step 1: Select the cell that contains the formula, then position the
mouse pointer over the lower-right corner of the cell until To calculate the sum
the black cross (+) appears. of adjacent cells: press
Step 2: Drag the fill handle over the cell or cells in which you want to the Alt + = keys together
copy the formula, then release the mouse button. after selecting the cells.
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.
Topic Flashback 21 st Century #Technology Literacy
Skills #Flexibility
Write T for True and F for False.
a. Excel makes calculations easier.
b. We can apply all types of mathematical operations like addition, subtraction,
multiplication and division in Excel.
c. The input of =25+B2 will give an error message.
ORDER OF OPERATION
When performing calculations using a formula, Excel follows certain rules of precedence:
Excel calculates expressions within parentheses (.... , ....) first.
Excel calculates multiplication and division before addition and subtraction.
Excel calculates consecutive operators with the same level of precedence from left to right.
For example, the formula = 10 + 10 * 2 gives a result of 30 as Excel multiplies 10 by 2 and then adds 10.
However, the formula =(10 + 10)*2 produces a result of 40. This is because Excel calculates the expression
(10 + 10) within the parentheses first. It then multiplies by 2.
If you are unsure of the order in which Excel calculates, use parentheses, even if the parentheses aren’t
necessary. Parentheses also make your formulas easier to read.
Envision your favourite tech personality as a Gizmo Gadget. How would you paint their
UNDERSTANDING CELL RANGE
portrait in Excel?
40 Premium Edition-VI

