Excel Quiz Cpht 1

20 terms by mchase28

Create a new folder

Advertisement Upgrade to remove ads

. A saved workbook is referred to as a ____.

File

The range of cells receiving a copy is called ____ area

Destination or paste area

. In ____ mode, as you type a character, Excel inserts the character and moves all characters to the right of the typed character one position to the right.

Insert

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

Insertion Point

____ allow users to enter, calculate, manipulate, and analyze data.

Worksheets

You view the portion of the worksheet displayed on the screen through a(n) ____.

worksheet Window

The default view in Excel is ____ view

Normal

A cell is referred to by its unique address, called a(n) ____, which is the coordinates of the intersection of a column and a row.

Cell Reference

. The mouse pointer turns to a ____ whenever you move it outside the worksheet.

Block Arrow

____ cells involves creating a single cell by combining two or more selected cells.

Merging

Which of the following is not a valid entry into a cell that requires numbers?

#

A(n) ____ chart is drawn on the same worksheet as its data.

Embedded

The number of worksheets that you can add to a workbook is ____.

LIMMITED BY THE AMOUNT OF MEMORY ON THE COMPUTER

. Each worksheet in a workbook has ____ rows

1,048,576

You press the ____ key on the keyboard to display a Key Tip badge.

ALT

The ____ feature of Excel works behind the scenes, correcting common mistakes.

AutoCorrect

To enter a number as text, start the entry with a(n)

Apostrophe

To emphasize certain entries and make the worksheet easier to read and understand, you ____ the worksheet.

Format

. Holding down the ____ key while you drag a chart snaps the edge of the chart area to the worksheet gridlines.

ALT

The ____ command in the AutoCalculate area displays the number of non blank cells in the selected range.

Count

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