Microsoft Excel 2010 Lesson 3 Knowledge Assessment

An Excel feature that automatically fills cells with data from another cell or range or completes a data series.

Auto fill

An Excel feature that helps you quickly enter data into cells.

AutoComplete

To place a duplicate of a selection on the Office Clipboard

Copy

Details about a file that describe or identify it and include details such as the author.

Document properties

An existing workbook can be opened by pressing the Ctrl+N keys.

False

The Office Clipboard collects items cut or copied from Excel worksheets only.

False

When you open Excel, the application opens by default to the Backstage area.

False

When you paste data into a cell or range of cells that contain data, the data that is replaced is copied to the Office Clipboard.

False

You can assign keywords so that others can search for your documents online.

False

To use a worksheet or workbook outside Excel, you have the option to save as a different___________.

File format

A small black square in the lower-right corner of selected cells that you can use to copy one cell to adjacent cells or create a series.

Fill handle

A bar at the top of the Excel window where you can enter or edit cell entries or formulas.

Formula bar

Entries that identify the numeric data in a worksheet.

Label

A command used to insert a cut or copied selection to a cell or range of cells.

Paste

A group of adjacent cells that you select to perform operations on all of the selected cells.

Range

If you key June 5, 2010 in a cell, the formula bar will display June 5, 2010 as well.

True

Use Ctrl+: to enter the current date in a worksheet cell.

True

Use the fill handle to create a natural series such as the months of the year.

True

Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.

True

You can accept an AutoComplete entry by pressing Tab or Enter.

True