Which one of the following is true for Conditional Formatting technique in Excel?

Which one of the following is true for Conditional Formatting technique in Excel?

Question 1: Which one of the following is true for Conditional Formatting technique in Excel?

a) Conditional Formatting is a quick tool to visualize data when certain conditions are met.

b) We can apply multiple Conditional Formatting to a single column.

c) “Data bars” and “Cell Rules” are two techniques used in Conditional Formatting.

d) Order of rules for Conditional Formatting is important.

e) All of the above

Question 2: The following picture shows sales data for 4 companies. They produce two products, coffee and cocoa. Determine for each part how we can obtain the highlighted results using Conditional Formatting.

For the column “Product” we used conditional formatting to highlight coffee from two products.

i) Which “rule type” is used to create the result?

For the column “Amount” we used conditional formatting to highlight some values from others.

ii) If we used “Format values where this formula is true”, which one the following formulas can produce the highlighted results?

i) Rule type:

a) Format only unique or duplicate values

b) Format only values that are above or below average

c) Format only cells that contain

d) Format cells based on their values

ii) Formula for formatting rule:

a) =$2D2<>300

b) =$D2<900

The post Which one of the following is true for Conditional Formatting technique in Excel? appeared first on superioressaypapers.