Page 21 - Touchpad_Plus_V3.2_Class 7
P. 21
Envision your favourite tech personality as a Gizmo Gadget. How would you paint their
portrait in Calc?
You can also use cell addresses to perform calculation in the following way:
Using cell addresses in formula
Notice that when the cell C1 is selected, the Formula bar shows
the formula you just typed.
What appears in the cell is the result.
✶ What appears in the formula bar is the value, which is a
formula in this case.
The elements of a formula are: Using cell addresses in formula
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
corner of the cell until the white cross ( ) appears.
Step 2 Drag the fill handle over the cell or cells to which
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 from the Edit menu,
click on Copy option.
Step 2 Select the cell or cells that you want to copy it to.
(a) To copy the formula and any formatting, from the Edit menu, click Paste.
(b) To copy the formula only, from the Edit menu,
hover the mouse pointer over Paste Special option
and click on Paste Only Formula option from the
sub-menu.
Formulas, Functions and Charts in Calc 19

