BOS CTE Final Review With The Paper

To assign a floating dollar sign rather than a fixed dollar sign to a number in a cell, choose the Accounting format in the Number text box.

• True

• False

If a reference in a formula in Excel  gets deleted, Excel will not adjust the cell references; the formula will need to be rewritten.

• True

• False

In Excel, using the Delete key will clear data from cells, but the cells remain in the worksheet.

• True

• False

What is the term used to describe a setting in software that is predetermined? For example, when you open a Word document, 1-inch margins are predetermined.

• System

• Factory Determined

• Default

• Fixed

What is the feature in Word that converts text to a graphic?

• Insert Picture

• WordArt

• WordGraphic

• Conversion

In Excel, what is the name of the feature that allows the user to copy formulas as well as create a series of numbers, dates, or month names in a range of cells? It is the black square in the bottom right-hand corner of the active cell.

• Series handle

• Fill handle

• Formula handle

• Copy handle

What is the term used to describe an adjacent group of cells in a worksheet? For example: H4:H10.

• Active

• Function

• Group

• Range

In Excel, what are the horizontal group of cells called that are labeled by number down the left side of the sheet?

• Row

• Active

• Range

• Column

In Excel, what are the horizontal group of cells called that are labeled by number down the left side of the sheet?

• Row

• Active

• Range

• Column

In Excel, which feature below would be best to use if you wanted to view opposite Columns in a worksheet?

• Freeze Panes

• Split Panes