1. What is the purpose of conditional formatting in Excel?
- A) To apply formatting based on specific conditions or criteria
- B) To automatically sort data in a worksheet
- C) To create charts and graphs
- D) To protect cells from being edited
Answer: A) To apply formatting based on specific conditions or criteria
2. How can you apply conditional formatting to highlight cells that are greater than a specific value?
- A) Use the “Highlight Cell Rules” option in the Conditional Formatting menu
- B) Apply a cell style manually
- C) Use the “Data Bars” option
- D) Use the “Color Scales” option
Answer: A) Use the “Highlight Cell Rules” option in the Conditional Formatting menu
3. Which of the following options allows you to apply a color scale to a range of cells?
- A) Color Scales in Conditional Formatting
- B) Icon Sets in Conditional Formatting
- C) Data Bars in Conditional Formatting
- D) Highlight Cell Rules in Conditional Formatting
Answer: A) Color Scales in Conditional Formatting
4. How can you use conditional formatting to highlight duplicate values in a range?
- A) Use the “Duplicate Values” option in the Conditional Formatting menu
- B) Use the “Top/Bottom Rules” option
- C) Apply a custom formula
- D) Use the “Data Bars” option
Answer: A) Use the “Duplicate Values” option in the Conditional Formatting menu
5. Which of the following conditional formatting features allows you to apply different icons based on cell values?
- A) Icon Sets
- B) Color Scales
- C) Data Bars
- D) Highlight Cell Rules
Answer: A) Icon Sets
6. To create a custom conditional formatting rule based on a formula, you should:
- A) Use the “Use a formula to determine which cells to format” option in Conditional Formatting
- B) Apply a built-in rule from the Conditional Formatting menu
- C) Use the “Manage Rules” option
- D) Use the “Clear Rules” option
Answer: A) Use the “Use a formula to determine which cells to format” option in Conditional Formatting
7. How can you remove conditional formatting from a range of cells?
- A) Use the “Clear Rules” option in the Conditional Formatting menu
- B) Use the “Delete” option in the Conditional Formatting menu
- C) Press Ctrl + Z
- D) Change the cell format manually
Answer: A) Use the “Clear Rules” option in the Conditional Formatting menu
8. Which conditional formatting feature would you use to apply formatting to the top 10 values in a range?
- A) Top/Bottom Rules
- B) Color Scales
- C) Data Bars
- D) Icon Sets
Answer: A) Top/Bottom Rules
9. How can you manage multiple conditional formatting rules applied to the same range?
- A) Use the “Manage Rules” option in the Conditional Formatting menu
- B) Apply rules one by one in the Conditional Formatting menu
- C) Use the “Clear Rules” option to start over
- D) Edit each rule directly in the cell
Answer: A) Use the “Manage Rules” option in the Conditional Formatting menu
10. What does the “Data Bars” option in Conditional Formatting do?
- A) Adds bars to cells to represent the relative size of values
- B) Colors cells based on their values
- C) Adds icons to cells based on their values
- D) Highlights cells with duplicate values
Answer: A) Adds bars to cells to represent the relative size of values