excel study guide

Clicking the _____ box completes an entry.

• cancel

• formula

• enter

• tab

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

• insert

• enter

• tab

• alt

In Excel, a number can contain the characters _____.

• 0 1 2 3 4 5 6 7 8 9

• + - () , /

• . $ % E e

• all of the above

Excel remembers the last _____ actions you have completed.

• 25

• 50

• 75

• 100

The first step in creating an effective worksheet is to make sure you _____.

• apply font formatting

• understand what is required

• insert a chart

• enter the data

To cancel an entire entry before entering it into the cell, press the _____ key.

• ALT

• ESC

• CTRL

• TAB

You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

• save

• print

• format

• clear

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

• worksheet

• workbook

• document

• presentation

The _____ is a blinking vertical line that indicates where the next typed character will appear.

• scroll box

• sheet tab

• insertion point

• split bar

_____ is/are used to add worksheet, column, and row titles on a worksheet.

• color

• text

• links

• tabs