Formulas Flashcards
1
Q
To type first when creating a formula
A
=
2
Q
Reference to the data in its relative position when executing a formula (ex. multiply the data two cells on the left to 1 cell to the left)
A
Relative cell reference
3
Q
Where to extend or work on a formula?
A
Formula bar
4
Q
What symbol is used for Absolute cell reference? Where to place it? This forces Excel to refer to that cell whenever the formula is copied or used.
A
$, in front of the column letter and/or in front of the row number (ex. $H$1)
5
Q
True or False. Cell references can be partially relative and partially absolute.
A
True.
6
Q
Where to change or see the name of a cell or range?
A
Name box > Drop down
7
Q
True or False. You can use the name of the range to extend your formula.
A
True.
