Solved

Identify the Letter of the Choice That Best Matches the Phrase

Question 24

Matching

Identify the letter of the choice that best matches the phrase or definition.

Premises:

Responses:

Formats the upper and lower values in a range based on criteria you provide.

Data Bars

Visually compares data using two or three shades that represent higher or lower values.

Color Scales

Compares values in cells relative to other cells where length represents the value in the cells.

Icon Sets

Classifies data into three to five categories where a symbol represents a range of values.

Top/Bottom Rules

Formats cells containing text, numbers, or date/time values based on criteria that you specify.

Highlight Cell Rules

Premises:

Formats the upper and lower values in a range based on criteria you provide.

Visually compares data using two or three shades that represent higher or lower values.

Compares values in cells relative to other cells where length represents the value in the cells.

Classifies data into three to five categories where a symbol represents a range of values.

Formats cells containing text, numbers, or date/time values based on criteria that you specify.

Responses:

Data Bars

Color Scales

Icon Sets

Top/Bottom Rules

Highlight Cell Rules

Correct Answer:

Premises:

Responses:

Formats the upper and lower values in a range based on criteria you provide.

Visually compares data using two or three shades that represent higher or lower values.

Compares values in cells relative to other cells where length represents the value in the cells.

Classifies data into three to five categories where a symbol represents a range of values.

Formats cells containing text, numbers, or date/time values based on criteria that you specify.