Excel Module 1 Test

Ranges can be entered in a function by typing the beginning and ending cell references separated by a

• colon
• comma
• semi-colon

To notify Excel you are entering a formula, type this before the formula.

• -
• ~
• =

Pressing this shortcut selects cell A1.

• CTRL+END
• CTRL+HOME
• HOME

The keyboard shortcut for selecting the entire worksheet is

• CTRL+S
• CTRL+A
• CTRL+N

When you begin typing in a cell, Excel displays two additional boxes in the formula bar:

• Cell and Tab boxes
• Cancel and Enter boxes
• Next and Previous boxes

Excel automatically positions the numeric data entries

• right-aligned
• left-aligned
• center-aligned

Which of the following keys moves the insertion point to the beginning data in a cell?

• Insert
• Home
• Enter

An Excel _____ allows data to be easily summed and charted.

• Worksheet
• Format
• Display

Cells can be selected by typing the cell reference in the Name Box.

• True
• False

Excel automatically positions text

• right-aligned
• left-aligned
• center-aligned