Page 43 - Plus_V2.2_C6_Flipbook
P. 43
For example, to enter a reference to cell B8 in Sheet1 into cell B8 in Sheet2, do this:
Step 1: Select cell B8 in Sheet2, and type an equal (=) sign.
Step 2: Click the Sheet1 tab.
Step 3: Click cell B8, and then press Enter key. When you press Enter key, Sheet2 is now active.
Step 4: Select cell B8, and you will see that it contains the formula =Sheet1!B8.
The exclamation point separates the worksheet portion of the reference from the cell portion.
References to Other Worksheets
Tech Hint
To switch between making the column, the row, or nothing ‘Absolute’: press the F4 key
repeatedly over a reference (cell).
Let’s PraCtiCe
If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then what will be the output of
the following formulas:
1. (A1 - A2) * A3 _________________________________________
2. A3 + (A1 * A2) _________________________________________
3. A1 * (A2 + A3) – 10 _________________________________________
FUNCTIONS
Functions are predefined formulas in Excel to perform both simple and complex calculations.
They accept arguments and return values. Arguments are input to the functions. These
arguments can be numbers or text. The values should be given in between opening and closing ( )
parenthesis.
Formulas and Functions in Excel 2016 41

