Excel 2 Flashcards
0
Q
Arithmetic operations are performed according to
A
The order of precedence
1
Q
What is a complex formula
A
An equation that uses more than one type of arithmetic operator
2
Q
What is the order of precedence in Excel formulas
A
- Parentheses
- Exponents
- Multiplication/division
- Addition/subtraction
3
Q
What is a function
A
A predefined worksheet formula that makes it easy to perform a complex calculation
4
Q
What does the clipboard do
A
Temporarily stores information that you copy/cut
5
Q
What do you use when you want to preserve the relationship to the formula location
A
Relative cell reference
6
Q
What do you use when you want to preserve the exact cell address in a formula
A
Absolute cell reference
7
Q
What is a mixed reference
A
A combination of both relative and absolute referencing; F4 key
