If you want to apply a conditional format that would format different cells with different colors, where one color is assigned to the lowest group of values, another color is assigned to the highest group of values, and gradient colors are assigned to other values, you would use ________

A) Icon Sets B) Top/Bottom Rules C) Color Scales D) Data Bars

C

Computer Science & Information Technology

You might also like to view...

The size and position of both data labels and text boxes can be adjusted after their insertion in a chart

Indicate whether the statement is true or false

Computer Science & Information Technology

A totals query calculates ________

A) subtotals across groups of records B) subtotals across a range of fields C) subtotals that meet specific criteria D) dynamic data in a field

Computer Science & Information Technology