FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Three (3) signs in an option for the ____ conditional formatting rule.
A
Color scales
B
Icon sets
C
Highlight between
D
Data bars
E
None
Explanation: 

Detailed explanation-1: -On the Home tab, in the Styles group, click Conditional Formatting. 3. Click Icon Sets and click a subtype. Explanation: by default, for 3 icons, Excel calculates the 67th percent and 33th percent.

Detailed explanation-2: -Go to Edit Rule tab and under Rule Type, choose Format all cells based on their values. Choose Icon Sets for Format Style and choose the down, straight and up arrow for the Icon Style.

Detailed explanation-3: -Conditional Formatting With Multiple Conditions To highlight cells according to multiple conditions being met, you can use the IF and AND Functions within a conditional formatting rule. Select the range you want to apply formatting to. In the Ribbon, select Home > Conditional Formatting > New Rule.

Detailed explanation-4: -What are icon sets in Excel? An icon set in Excel is a form of conditional formatting in which each value has an icon to show its value or range of values.

There is 1 question to complete.
Previous
Next