Worksheetsquiz G7-Q3-W7
Total questions: 10
Worksheet time: 27mins
What is the primary purpose of data validation in Excel?
To encrypt data
To ensure data accuracy and consistency
To delete data
To format data
Which of the following is NOT a common use case for data validation in Excel?
Restricting data input to a specific range
Validating email addresses
Ensuring data uniqueness
Formatting cell borders
What is a drop-down list created through data validation called in Excel?
Data sheet
Validation menu
Data validation list
Drop-down menu
When a user enters invalid data, what can Excel do to provide guidance?
Display a warning message
Automatically correct the data
Delete the invalid data
Freeze the spreadsheet
What happens when a user tries to enter data that doesn't meet the data validation criteria?
The data is automatically corrected
A warning message appears
The data is deleted
Excel crashes
A table can have blank columns and rows in it, if they are selected when the table is created.
TRUE
FALSE
Which conditional formatting feature can be used to identify duplicate values on a worksheet?
Data Bars
Highlight Cell Rules
Top / Bottom Rules
Color Scales
What is this icon?
Sum
AutoSum
Insert Function
Object
The best data type to choose for date of birth would be
Number
Date/Time
Text
Currency
