FUNDAMENTALS OF COMPUTER

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: -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-3: -Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

Detailed explanation-4: -On the Home tab, click Conditional Formatting > New Rule. In the New Formatting Rule dialog box, choose Format only top or bottom ranked values. In the drop-down list, select Top or Bottom, and type how many values to highlight in the box next to it.