Midterm Exam Flashcards
1
Q
What are the different text formulas and what do they do?
A
- The ‘&’ operator joins text together.
2
Q
What is the operator for the Not Equal To operation?
A
<>
3
Q
What is the operator for the Intersect operation?
A
function(range [space] range)
4
Q
What does the Intersect operation do?
A
5
Q
What are the 8 orders of operation listed from first to last?
A
- Items in Parentheses
- Embedded Function
- Functions
- Unitary Minus
- Exponents
- Multiply and Divide
- Addition and Subtraction
- Conditions
