Chapter 4 Excel

Front

All formulas begin with which operator?

Back

=

Front

When a cell is referenced in an equation which of the following DOES NOT happen? The text in the equation appears in a different color. The cell that is referenced is highlighted with a bold border in the spreadsheet. The cell that is referenced changes in value. The cell that is referenced changes if you use the fill handle to fill adjacent cells.

Back

The cell that is referenced changes in value.

Front

What does an absolute cell reference do?

Back

Indicates to Excel not to move cells when calculating formulas in adjacent cells

Front

The cell reference $B3 does what?

Back

Holds the column consistent but allows the row to change.

Front

The cell reference B$3 does what?

Back

Holds the row consistent but allows the column to change.

Front

The cell reference $B$3 does what?

Back

Holds the cell B3 consistent.

Front

If the formula bar in Excel reads =([GradePointAverage.xlsx]Freshman!J10) what does GradePointAverage.xlsx refer to?

Back

a workbook

Front

If the formula bar in Excel reads =([GradePointAverage.xlsx]Freshman!J10) what does Freshman! refer to?

Back

a worksheet

Front

If the formula bar in Excel reads =([GradePointAverage.xlsx]Freshman!J10) what does J10 refer to?

Back

a cell

Front

When you enter a formula into a cell, the formula is always displayed in the cell itself.

Back

False