Advertisement Upgrade to remove ads

worksheet

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

requirements

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

understand what is required

The first step in creating an effective worksheet is the make sure you ________.

cell

To enter data in a cell, you must first select or activate the ________.

Text

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

ESC

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

enter

Clicking the _______ box completes an entry.

insertion point

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

AutoCorrect

The ________ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

RIGHT ARROW

Pressing the ________ key to complete an entry activates the adjacent cell to the right.

left-aligned

By default, text is ________ in a cell.

0 1 2 3 4 5 6 7 8 9 . $ % E e + - ( ) , /

In Excel, a number can contain the characters ________.

6E15

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 you can type ________.

range

A ________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.

colon

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

apostrophe

To enter a number as a text, precede it with a(n) ________.

destination area (or paste area)

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the ________.

relative

A ________ reference is an adjusted cell reference in a copied and pasted formula.

fill handle

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

Auto Fill Options

The ________ allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

format

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

two

In general, use no more than ________ font types in a worksheet.

CTRL+B

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

merging

Combining two or more selected cells is called ________ cells.

(Home tab | Styles group)

What is the Ribbon path to the Cell Styles button?

Displays cell contents with two decimal places that align vertically.

What effect does the Accounting Number Format have on the selected cells?

Displays cell contents with two decimal places and commas as thousands separators.

What effect does the Comma Style format have on the selected cells?

CTRL+HOME

Pressing the ________ keyboard shortcut key(s) selects the cell A1.

11

How many chart types does Excel offer?

embedded

A(n) ________ chart is drawn on the same worksheets as the data.

legend

In the accompanying figure, the ________ identifies the colors assigned to each bar in the chart on a worksheet.

Standard

________ properties are associated with all Microsoft Office documents and include author, title, and subject.

Auto Calculate

The ________ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected number in the worksheet.

INSERT

Which key toggles between Insert mode and Overtype mode?

HOME

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

END

Which key moves the insertion point to the end of data in a cell?

F2

Which key is an alternative to double-clicking the cell to edit it?

Undo

The ________ button is located on the Quick Access Toolbar.

100

Excel remembers the last ________ actions you have completed.

click

To remove an embedded chart, you should ________ it and press the DELETE key.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set