Font size
WorksheetsFormulas & Functions in Excel (Post)
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
TEXTJOIN
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
TEXTSPLIT
___________ is Case Sensitive.
TextBefore
TextAfter
Find
Search
______ is a function that you have enter yourself and Excel doesn't show the function arguments option, yet it is still usable.
datedif
columns
difdate
vstack
What is the maximum number of layers that you can nest within a function?
46
66
127
64
