Which of the following actions can you perform using data validation rules?
A) recalculate all formulas
B) place restrictions on values
C) provide a message to the user
D) display an error message when a restricted, or invalid, value is entered

Question

Quizplus · Accepted Answer

Data validation rules allow you to place restrictions on the type of data or values that can be entered into a cell, such as setting a range of valid values or limiting the length of the input. You can also provide a message to the user to guide them on valid inputs, and display an error message when an invalid value is entered. Recalculating all formulas is not a function of data validation rules.

Which of the Following Actions Can You Perform Using Data