Excel Mod 2 Review

Indicate whether the statement is true or false. When you select a cell range, the cells must be adjacent to each other.

• True

• False

Indicate whether the statement is true or false. The Comma Style format adds a comma and a dollar sign to a cell value.

• True

• False

Indicate whether the statement is true or false. To remove conditional formatting from a selected range, you can select the rule in the Conditional Formatting Rules Manager dialog box, then click the Delete Rule button.

• True

• False

Indicate whether the statement is true or false. You can apply date formats to cells by using the Date category in the Format Cells dialog box.

• True

• False

Indicate whether the statement is true or false. To move a worksheet, you can drag its sheet tab to the left or right.

• True

• False

Indicate whether the statement is true or false. Currency is an example of a number format.

• True

• False

Indicate whether the statement is true or false. When you change cell contents to italics, you are changing the cell's alignment.

• True

• False

Indicate whether the statement is true or false. When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

• True

• False

Indicate the answer choice that best completes the statement or answers the question. A worksheet named Income (2) is most likely which of the following?

• a deleted worksheet

• a worksheet with no calculations

• a repositioned worksheet

• a copy of another worksheet named Income

The spell checker flags your company's name as a misspelling. Which of the following will stop the spell checker from flagging later occurrences in the document?

• Change All

• Change

• Ignore Once

• Ignore All