Comp Apps Review - MS Excel

A cell address lists the _____ second.

A boolean value evaluates to either _____ or _____.

To see all conditional formatting rules, use the _____.

A range always lists which cell first?

Absolute references _____ when auto-filled.

Rows in Excel are identifed by _____.

Formulas begin with an _____.

Data in a spreadsheet is presented in what form?

Formulas begin with this symbol.

A table is a grid of rows and columns that intersect to form _____.

The symbol for divison is....

The And() function returns true when _____.

To write "not equal to" in Excel, you'd use _____.

Excel is what kind of application?

The grey triangle in the top left of this picture does what?

Pivot Tables are created by placing fields into _____, columns, values, and filters.

The symbol for addition is....

Each cell is uniquely identified by a combination of its column/row, called the _____.

Relative references _____ when auto-filled.

The symbol for subtraction is....

Absolute references have one or two of these in their name.

The correct formula to multiply cell H5 by J4 is:

Ranges have a _____ between the two cell references.

The two types of cell references are _____ and _____.

A cell with a comment has a _____ in the corner.

The shortcut key for making an absolute reference is _____.

Labels are usually _____ in nature.

The Or() function returns true when _____.

Which of these does not go INSIDE a cell?

Columns in Excel are identifed by _____.

A cell address lists the _____ first.

The cursor is currently over what in the red circle?

Conditional formatting applies _____ to cells.

Values are usually _____ data.

The symbol for multiplication is....

Excel spreadsheets have one or more ____ (tabs) across the bottom of the screen.