DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
You can add more than one condition to check
|
|
|
You can set condition to look for Bold and apply Italics on them
|
|
|
You can apply Font, border and pattern formats that meets the specified conditions
|
|
|
You can delete any condition from conditional Formatting dialog box if it is not required
|
Detailed explanation-1: -In Conditional Formatting we cannot set condition to look for Bold and apply Italics on them.
Detailed explanation-2: -You can set the condition to look for Bold and apply Italics to them it is not true. Because this statement is true You can add more than one condition to check. we can apply Font, border, and pattern formats that meet the specified conditions.
Detailed explanation-3: -For example, you cannot change the Font or Font Size with Conditional Formatting.
Detailed explanation-4: -Expert-Verified Answer The statements are true for conditional formatting to Add more than one condition and Apply background formats that satisfy specific conditions.
Detailed explanation-5: -1) The correct answer is d. Conditional formatting allows you to set rules that automatically apply formatting, such as highlighting or font changes, to selected cell ranges when the conditions that were set in the rule, are met.