Exam 1: Creating a Worksheet and a Chart

When you tap or click the Enter box to complete an entry in a cell,the active cell moves down to the next cell in the same column.

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

Press ____ to select the entire worksheet.

-A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells,as shown in the accompanying figure.

You can press the RIGHT ARROW or LEFT ARROW keys to position the insertion point during in-cell editing.

A given range contains the data that determines the size of slices in a corresponding pie chart; these entries are called the category names.

Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.

A single point is about 1 / 32 of one inch in height.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Selects cell A1.

Excel remembers the last ____ actions you have completed.

When entering dollar values in cells,you also must type the dollar sign ($),commas,and any trailing zeros.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

The person or persons requesting the worksheet should supply their requirements in a ____ document.

If you have multiple Excel workbooks open,to close all open workbooks and exit Excel,____.

Which of the following keys toggles between Insert mode and Overtype mode?

The AutoCorrect feature can automatically capitalize the first letter in the names of days.

How many chart types does Excel offer?

By default,text is ____ in a cell.

While typing in a cell,you can press the ____________________ key to erase all the characters back to and including the incorrect character you just typed.

A requirements document includes a needs statement,source of data,summary of calculations,and any other special requirements for a worksheet.