IC3 Key Applications - Excel

All Excel formulas begin with the equal sign (=).

• True
• False

Status bar command used to obtain a total, average, or other information about numbers in a range

• AutoCorrect feature
• AutoCorrect featurecategory axis
• destination area
• autocalculate area

Used to make it stand out from the rest

• bold
• fill handle
• excel help
• insert tab

Small black square located in the lower right corner of active cell

• folder
• fill handle
• font size
• document properties

Identifies each bar in a chart

• legend
• line chart
• insert mode
• overtype modeinsert mode

Creating a single cell by combining two or more cells

• metadata
• number
• merging cells
• page down

A collection of cell styles and other styles that have common characteristics

• standard properties
• source area
• right-aligned
• theme

To make a cell active

• to select a cell
• text
• surface chart
• theme

With the dollar sign to the left, inserts a comma every three positions

• blank cell
• accounting number format
• AVERAGE function
• condition

Applied formatting only when value meets specified condition

• cooler colors
• auto fill options
• conditional formatting
• Division