What formula auditing tool can be used to control the data input from the user?
A)IFERROR
B)Data validation
C)Watch Window
D)Trace dependents

Question

Quizplus · Accepted Answer

Data validation allows for setting specific rules and criteria for data input by the user, ensuring that only valid and appropriate data can be entered. The other options, IFERROR, Watch Window, and Trace Dependents, are formula auditing tools that are used to analyze formulas and track data dependencies within a worksheet, but they do not impact data input from the user.

What Formula Auditing Tool Can Be Used to Control the Data