1
AssignmentMultiple Choice

Automating Workbook Functionality

Question 1 • Computer Applications - Office 2019 - S1

Which section of the Data Validation dialog box allows a user to establish criteria?

Answer
A
Input Message
B
Settings
C
Data Validation
D
Error Alert

Explanation

The Settings section is where you choose the type of data allowed and define the validation criteria, such as a number range or a list of permitted entries. Input Message displays guidance when a cell is selected, while Error Alert responds when invalid data is entered. Therefore, the correct choice is Settings.

AI-written and checked against the verified answer.

Next