MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A limitation on the possible values that a cell can contain.
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

A constraint is a limitation on the possible values that a cell can contain, such as a range of allowed values or a specific formula.

Answer: B
 Data validation is a feature in Excel that allows you to set up controls on the data that users can enter into a cell, including restrictions on the type, value, or length of data that can be entered.

Answer: H
 A circular reference occurs when a formula refers to the same cell or range of cells that it is located in, which can result in an endless loop of calculations.

(Note: None of the other options match the given phrase.)

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