Fall Exam Review Questions Part 1

Worksheet titles and subtitles should be as wordy as possible.

• True

• False

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

• True

• False

Excel can display characters in only three font colors: black, red, and blue.

• True

• False

You can turn off the Bold formatting for selected text by clicking the Roman button (Home tab | Font group).

• True

• False

To add a pie chart, first select the data to be charted and then tap or click the Insert Pie or Doughnut Chart button (INSERT tab | Charts group).

• True

• False

You should press the SPACEBAR to clear a cell.

• True

• False

The arithmetic operator, ^, directs Excel to perform the division operation.

• True

• False

The range automatically selected by Excel is always correct.

• True

• False

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

• True

• False

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

• True

• False