How do you create conditional formatting rules based on a formula in Excel?
A) Home -> Styles -> Conditional Formatting -> Formula Rules
B) View -> Conditional Formatting -> New Rule using Formula
C) Home -> Conditional Formatting -> Use Formula Rule
D) Home -> Styles -> Conditional Formatting -> New Rule -> Use a formula to determine...
In a formula-based conditional formatting scenario where cells in column C are formatted if they contain "USA", what formula is used?
A) =$C1="USA"
B) =$C1=="USA"
C) =IF($C1="USA")
D) =MATCH($C1, "USA")How do you access the conditional formatting options in Excel?
A) View -> Styles -> Conditional Formatting
B) Home -> Styles -> Conditional Formatting
C) Insert -> Conditional Formatting -> Format Rules
D) Page Layout -> Conditional Styles -> Edit Rules
What step follows after selecting the rule type (Greater Than, Less Than, Between, etc.) for conditional formatting?
A) Apply the rule and close the dialog box
B) Click OK after specifying the numeric values and desired color
C) Edit the rule using the Rules Manager
D) Save the rule for future use
Rules Manager in Conditional Formatting:
What purpose does the Rules Manager serve in Excel's conditional formatting?
A) It generates new conditional rules
B) It manages conflicts between conditional rules
C) It rearranges cell data based on rules
D) It highlights all cells meeting a specific criterion
How can you adjust the priority/order of conditional rules using the Rules Manager?
A) Drag and drop rules to rearrange them
B) Use the arrow keys on the keyboard
C) Edit each rule's priority number
D) Right-click to change the rule order
Which option allows you to modify the visualization of conditional formatting rules using the Rules Manager?
A) Show Visualization checkbox
B) Format Visualization button
C) Edit Rules command
D) Adjust Visuals toggle
What action is taken to display only the visual representation (e.g., Data Bar) of conditional formatting in Excel?
A) Duplicate the data set to another column
B) Use the "Show Visualization Only" checkbox
C) Create a new rule with a specific formula
D) Apply conditional formatting on a separate worksheet
Using Formulas for Conditional Formatting:
How do you create conditional formatting rules based on a formula in Excel?
A) Home -> Styles -> Conditional Formatting -> Formula Rules
B) View -> Conditional Formatting -> New Rule using Formula
C) Home -> Conditional Formatting -> Use Formula Rule
D) Home -> Styles -> Conditional Formatting -> New Rule -> Use a formula to determine...
In a formula-based conditional formatting scenario where cells in column C are formatted if they contain "USA", what formula is used?
A) =$C1="USA"
B) =$C1=="USA"
C) =IF($C1="USA")
D) =MATCH($C1, "USA")
