Excel: Module 1Test Review

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

• worksheet

• database

• document

• presentation

Clicking the ____ box completes an entry.

• Cancel

• Formula

• Enter

• Tab

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

• scroll box

• sheet tab

• insertion point

• split bar

By default, text is ____ in a cell.

• left-aligned

• centered

• justified

• right-aligned

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

• semi-colon (;)

• colon (:)

• period (.)

• none of the above

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

• selection handle

• sizing handle

• fill handle

• copy handle

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

• quotation mark (")

• colon (:)

• plus (+)

• equal sign (=)

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

• save

• print

• format

• clear

Combining two or more selected cells into one cell is called ____ cells.

• merging

• mixing

• combining

• spanning

Which of the following is the Ribbon path to the Cell Styles button?

• HOME tab, STYLES group

• STYLES tab, HOME group

• HOME tab, FORMAT group

• FORMAT tab, STYLES group