FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

WORKBOOK THEMES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If you create a conditional formatting rule you can modify it using the Conditional Formatting ____
A
Rules Options dialog box
B
Rules Wizard
C
Rules template
D
Rules Manager
Explanation: 

Detailed explanation-1: -Change a conditional formatting rule On the Home tab, click Conditional Formatting. Click Manage Rules. Select the rule, and then click Edit Rule. Make the changes that you want, click OK, and then click OK again.

Detailed explanation-2: -Quick formatting On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.

Detailed explanation-3: -To create the first rule: On the Home tab, click Conditional Formatting > New Rule. In the Style box, click Classic. Under the Classic box, click to select Format only top or bottom ranked values, and change it to Use a formula to determine which cells to format.

Detailed explanation-4: -Use advanced conditional formatting. You can use custom formulas to apply formatting to one or more cells based on the contents of other cells.

There is 1 question to complete.
Previous
Next