Excel Lesson 2 Expert

Arrange in a line or bring into alignment.

• Align

• Orientation

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed.

• criteria formatting

• conditional formatting

• conditonal formula

• template

Two or more cells combined into a single cell.

• merged cells

• centered cells

• active cell

A tool that enables you to set the order of multiple rules, fine-tune rule settings, and more.

• rules manager

• criterion manager

• condition manager

To display the two numbers 1,540,257.14 and 2,250,444.18 as 1.54 M and 2.25 M, respectively. Which number format must be applied to the first two numbers?

• #,##0.00,,"M"

• #,##0.00,,"N"

• #,#0.00,,"M"

• #,##0.00,,"B"

Number format is used to display the month as a single text character

• mmmmm

• mmmm

• mmmmmm

• month

Number format is used to format a list of credit card numbers

• 0000 0000 0000 0000

• 000 00 0000

• 0000 0000 0000

• 0000 0000 0000 00000

The tab in the Data Validation dialog box is used to specify the validation criteria

• Settings

• Options

Option on the Conditional Formatting menu is used to display colored bars that represent the values in cells

• Data Bars

• Bar Chart

• Bar Graph

Method used to display the Series dialog box that is used to fill data in a range.

• Editing group, select Fill , click Series

• Insert group, select Fill , click Series

• Editing group, select Series , click Fill