FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

USING THE UPPER AND LOWER FUNCTIONS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The easiest method to find all conditional formatting rules on a worksheet is to u se the “Show Formatting Rules for This Worksheet” option in the Conditional Formatting Rules Manager.
A
True
B
False
C
X
D
X
Explanation: 

Detailed explanation-1: -On the HOME tab, in the Styles group, click the arrow next to Conditional Formatting, and then click Manage Rules. The list of conditional formatting rules are displayed for the current selection including the rule type, the format, the range of cells the rule applies to, and the Stop If True setting.

Detailed explanation-2: -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-3: -Select the control that has the conditional formatting you want to copy. On the Home tab, in the Clipboard group, double-clickFormat Painter. Click the all the controls to which you want to copy the formatting. Click Format Painter again to end the format-painting process.

There is 1 question to complete.
Previous
Next