1. Conditional Formatting in Excel is used to:
(A) Change the content of cells automatically
(B) Format cells based on specific conditions or criteria
(C) Insert formulas in a worksheet
(D) Protect cells from editing
2. Which tab in Excel contains the Conditional Formatting option?
(A) Home
(B) Insert
(C) Data
(D) Review
3. Conditional Formatting can be applied to:
(A) Text only
(B) Numbers only
(C) Both text and numbers
(D) Charts only
4. Which of the following is NOT a type of Conditional Formatting in Excel?
(A) Highlight Cell Rules
(B) Data Bars
(C) Icon Sets
(D) AutoCorrect
5. Data Validation in Excel is used to:
(A) Prevent duplicate values
(B) Restrict the type of data entered into a cell
(C) Protect a worksheet with a password
(D) Count the number of entries in a column
6. Which tab in Excel contains the Data Validation option?
(A) Review
(B) View
(C) Data
(D) Home
7. Which type of list can be created using Data Validation?
(A) Drop-down list
(B) Hyperlink list
(C) Style list
(D) Formula list
8. If you want a cell to allow only whole numbers between 1 and 100, you should use:
(A) Conditional Formatting
(B) Data Validation → Whole Number → Between 1 and 100
(C) Protect Sheet option
(D) COUNTIF formula
9. Which of the following is NOT an option in Data Validation criteria?
(A) Whole Number
(B) Decimal
(C) Time
(D) Watermark
10. Which feature displays a message to guide users before they enter data in a cell?
(A) Input Message
(B) Error Alert
(C) Data Tip
(D) ScreenTip