Lesson 17 Flashcards Preview

Micro Excel Lesson 16-20 > Lesson 17 > Flashcards

Flashcards in Lesson 17 Deck (6)
Loading flashcards...
0

Variable formatting that changes the formatting applied based on the contents of the cells in the formatting range.

Conditional formatting

1

A type of conditional formatting that creates filled background bars reflecting the relative value stored in each of the format cells

Data bars

2

A method of applying conditional formatting based on how cell contents compare with a specified criterion, such as a less than comparison

Highlight cell rules

3

A type of conditional formatting that includes one of a set of icons reflecting the relative value stored in each of the formatted cells

Icon sets

4

A tool that provides formatting for data analysis

Quick analysis lens

5

Conditional formatting rules that format the highest or lowest values in the formatted range, or those that are above or below average

Top/bottom rule