Font size
WorksheetsExcel Formulas and Functions
Total questions: 20
Worksheet time: 11mins
What excel function calculates the sum of values?
(a)
Calculates the mean of a group of values
SUM
AVERAGE
ROUND
COUNT
True or False:
The IF function tests for a true or false condition and then returns one value or another.
True
False
Calculates a sum from a group of values, but just of values
that are included because a condition is met.
COUNTIF
SUMIF
AVERAGEIF
Counts the number of cells in a range that match a
criteria
COUNTIF
SUMIF
AVERAGEIF
Extracts one or more characters from the left side of a text
string
LEFT
RIGHT
MID
CONCATENATE
Extracts one or more characters from the right side of a text string
LEFT
RIGHT
MID
CONCATENATE
Assembles two or more text strings into one
CONCATENATE
REPLACE
PROPER
Choose the correct example:
The column is absolute; the row is relative
=A1
=$A1
=A$1
=$A$1
Choose the correct example:
The column is relative; the row is absolute
=A1
=$A1
=A$1
=$A$1
Check ALL that APPLY:
An example of a relative reference is ________.
=A1
=M10
=$L$12
=P3
What is the meaning of this error in Excel?
Text in the formula is not recognized
Trying to divide by 0
A space was used in formulas that reference multiple ranges; a comma separates range references
What is the meaning of this error in Excel?
A reference is invalid
A formula has invalid numeric data for the type of
operation
The wrong type of operand or function argument is used
What text formula joins the text from two or more cells?
concatenate
proper
left
e=mc2
