You would use ________ to monitor data input and display an appropriate message if a user enters erroneous data.
A)a data filter
B)conditional formatting
C)data validation
D)error checking

Question

Quizplus · Accepted Answer

Data validation allows you to set rules for what type of data is allowed in a cell or range of cells. If a user enters data that does not meet the validation rule, a message will be displayed. This is useful for monitoring data input and ensuring data accuracy.

You Would Use ________ to Monitor Data Input and Display