Matching
Identify the letter of the choice that best matches the phrase or definition.
Premises:
Incorrect data type used in the function or formula.
Cell is not wide enough to display formula results.
A value in the formula is not available in the worksheet.
Formula or function uses a cell reference that is no longer valid.
Formula contains incorrect text.
Responses:
#VALUE!
#####
#REF!
#NAME?
#NA
Correct Answer:
Premises:
Responses:
Incorrect data type used in the function or formula.
Cell is not wide enough to display formula results.
A value in the formula is not available in the worksheet.
Formula or function uses a cell reference that is no longer valid.
Formula contains incorrect text.
Premises:
Incorrect data type used in the function or formula.
Cell is not wide enough to display formula results.
A value in the formula is not available in the worksheet.
Formula or function uses a cell reference that is no longer valid.
Formula contains incorrect text.
Responses:
Related Questions
Q35: To quickly switch between displaying values and
Q36: In the function =SUM(B8:B11), which is the
Q37: When you click the Sum button arrow,
Q38: Case EX 3-2 Bernadette has created a
Q39: A cell with an error displays a
Q40: When you click the Error Checking button,
Q41: An Excel formula must begin with the
Q42: When a cell is active, you can
Q44: You can enter a formula by pressing
Q45: FIGURE EX 3-1 <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9076/.jpg" alt="FIGURE EX