Excel Module 2 Review

When you run the Spell Checker in a workbook, Excel automatically checks the spelling in all worksheets at once.

• True

• False

Currency is an example of a number format.

• True

• False

Which of the following is true about adding cell borders?

• A cell border changes the background color of the cell.

• A cell border underlines the cell content.

• You can add a border to the left, top, right, or bottom edge of a cell.

• Borders are always single black lines.

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

• Alignment

• Fonts

• Color

• Styles

To format a range so that all values greater than $500 appear in red, which of the following can you use?

• conditional formatting

• cell formatting

• cell styles

• Quick Access toolbar

You receive a worksheet in which the row numbers are 1, 2, 3, 5, 6. This means that row 4 is  __

• deleted

• hidden

• cut

• conditionally formatted

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

• left

• center

• bold

• underline

When you wrap and center a range, you combine the cells into one cell. True/False? If true, type future, if false, type the correct answer. (EX. false/one)

When you double-click the right border of a column heading, which of the following occurs ?

• The column is deleted.

• AutoFit resizes the column to 8.43 characters wide.

• A column is added to the right of the current column.

• AutoFit resizes the column to the widest cell entry.

The _____ number format adds dollar signs and two decimal places to numeric data.

• Data

• Accounting

• Percentage

• General