1 of 42
Definition Term
It is important to remember that D
Excel calculates these
operations before any others
are performed:
a. Exponents
b. Items in parentheses
c. Mathematical expressions
d. Fixed cell references
e. Mixed cell references
Give this one a try later!
True False
Correct definition
B
, 2 of 42
Definition Term
A Miniature chart that is A
displayed in a cell or cell range
next to your data to illustrate a
pattern or trend is called a/an:
a. Sparkline
b. Forecast point
c. Predictor
d. MiniChart
e. Conditional chart
Give this one a try later!
True False
3 of 42
Definition Term
When a formula contains a
B
typographical error,
unnecessary or missing
punctuation, incorrect order of
arguments, or an incorrect cell
reference, it returns:
a. An error message that begins
with an exclamation point (!)
b. A blank cell
c. An error message that begins
with a number sign (#)
, d. A green alert
e. A red alert
Give this one a try later!
True False
Correct definition
C
4 of 42
Definition Term
When you want to delete B
characters in a cell to the left of
the insertion point press:
a. Delete
b. Enter
c. Edit
d. Backspace
e. End
Give this one a try later!
True False
Correct definition
D
Definition Term
It is important to remember that D
Excel calculates these
operations before any others
are performed:
a. Exponents
b. Items in parentheses
c. Mathematical expressions
d. Fixed cell references
e. Mixed cell references
Give this one a try later!
True False
Correct definition
B
, 2 of 42
Definition Term
A Miniature chart that is A
displayed in a cell or cell range
next to your data to illustrate a
pattern or trend is called a/an:
a. Sparkline
b. Forecast point
c. Predictor
d. MiniChart
e. Conditional chart
Give this one a try later!
True False
3 of 42
Definition Term
When a formula contains a
B
typographical error,
unnecessary or missing
punctuation, incorrect order of
arguments, or an incorrect cell
reference, it returns:
a. An error message that begins
with an exclamation point (!)
b. A blank cell
c. An error message that begins
with a number sign (#)
, d. A green alert
e. A red alert
Give this one a try later!
True False
Correct definition
C
4 of 42
Definition Term
When you want to delete B
characters in a cell to the left of
the insertion point press:
a. Delete
b. Enter
c. Edit
d. Backspace
e. End
Give this one a try later!
True False
Correct definition
D
