MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays prompts and error messages when users select a cell or enter invalid data.
A)formula auditing
B)data validation
C)constraint
D)Scenario Manager
E)precedent
F)dependent
G)Watch Window
H)circular reference
I)Goal Seek
J)Solver

Question

Quizplus · Accepted Answer

Data validation is the process of ensuring that the data entered into a spreadsheet is valid and meets certain criteria. It can display prompts and error messages when users select a cell or enter invalid data.

Answer: C
 A constraint is a restriction or limit on the values that can be entered into a cell or range of cells in a spreadsheet. It can be used to ensure that users enter only valid data and to prevent errors.

(Note: While B also fits this description, C specifically mentions "restrictions or limits," which is a more direct match with the given phrase.)

Possible alternative answer: G
 The Watch Window allows users to monitor the values of specific cells in a separate window while they work on other parts of the spreadsheet. While it doesn't directly display prompts or error messages, it could be used to keep an eye on cells that are prone to errors or inputs that require validation.

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase