Have an account?
Skip to Content
Build your own quiz
Suggestions for you
15 questions
Show Answers
See Preview
- 1. Multiple Choice
What would be a correct formula for SUM in excel?
=SUM(B3-B9)
=SUMB3+B9
=SUM(B3:B9)
=SUM[B3:B9]
- 2. Multiple Choice
Which symbol must all formulas begin with?
+
=
/
-
- 3. Multiple Choice
What text formula joins the text from two or more cells?
conjoin
concoct
concentrate
concatenate
- 4. Multiple Choice
Which formula will calculate the average of data in a given range?
AVEDATA
AVERAGE
AVERAGEIF
AVERAGING
- 5. Multiple Choice
Which response best completes the following statement: A formula is used to ____________________.
add data
find averages
make presentations
perform calculations
- 6. Multiple Choice
Excel follows the ____________________ and first adds the values inside the parentheses.
Order of Formulas
Formula Guidelines
Order of Operations
Operation Guidelines
- 7. Multiple Choice
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
C3-A1
=A1-C3
=C3-A1
- 8. Multiple Choice
What is the function of the caret (^) symbol?
expiration
extradition
expedition
exponentiation
- 9. Multiple Choice
These are used to combine ranges of cells for calculations.
Text Operators
Arithmetic Operators
Reference Operators
Comparison Operators
- 10. Multiple Choice
These are used to execute basic mathematical operations, to combine numbers, and to produce numeric results.
Text Operators
Arithmetic Operators
Reference Operators
Comparison Operators
- 11. Multiple Choice
What is this symbol?
less than
greater than
less than or equal to
greater than or equal to
- 12. Multiple Choice
Which formula will calculate the square root of the value in a given cell?
=SQRT(A1)
=SQTR(A1)
=SQRT[A1]
=SQTR[A1]
- 13. Multiple Choice
What is the function of this symbol?
division
addition
subtraction
multiplication
- 14. Multiple Choice
What is the symbol for Range Operator?
- 15. Multiple Choice
What is the function of this symbol?
division
addition
subtraction
multiplication
- Answer choicesTagsAnswer choicesTags