NEW
Font size
WorksheetsAdvanced Functions and Formulas
Total questions: 15
Worksheet time: 8mins
What would be a correct formula for SUM in excel?
=SUM(B3-B9)
=SUMB3+B9
=SUM(B3:B9)
=SUM[B3:B9]
Which symbol must all formulas begin with?
+
=
/
-
What text formula joins the text from two or more cells?
conjoin
concoct
concentrate
concatenate
Which formula will calculate the average of data in a given range?
AVEDATA
AVERAGE
AVERAGEIF
AVERAGING
Which response best completes the following statement: A formula is used to ____________________.
add data
find averages
make presentations
perform calculations
Excel follows the ____________________ and first adds the values inside the parentheses.
Order of Formulas
Formula Guidelines
Order of Operations
Operation Guidelines
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
C3-A1
=A1-C3
=C3-A1
What is the function of the caret (^) symbol?
expiration
extradition
expedition
exponentiation
These are used to combine ranges of cells for calculations.
Text Operators
Arithmetic Operators
Reference Operators
Comparison Operators
These are used to execute basic mathematical operations, to combine numbers, and to produce numeric results.
Text Operators
Arithmetic Operators
Reference Operators
Comparison Operators
What is this symbol?
less than
greater than
less than or equal to
greater than or equal to
Which formula will calculate the square root of the value in a given cell?
=SQRT(A1)
=SQTR(A1)
=SQRT[A1]
=SQTR[A1]
What is the function of this symbol?
division
addition
subtraction
multiplication
What is the symbol for Range Operator?
What is the function of this symbol?
division
addition
subtraction
multiplication
