MSITA – MOAC – Excel Lesson 3 Knowledge Assessment

Name:_____________________________________ Date: _______________ Period: _______

Matching

Match each vocabulary term with its definition. Place the correct letter on the blank.


MSITA – MOAC – Excel Lesson 3 Knowledge Assessment

a. auto fill

b. AutoComplete

c. copy

d. document properties

e. fill handle

f. formula bar

g. label

h. paste

i. range

j. file format


MSITA – MOAC – Excel Lesson 3 Knowledge Assessment

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

_______ 2. To use a worksheet or workbook outside Excel, you have the option to save as a different ________________.

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

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

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

_______ 6. To place a duplicate of a selection on the Offi ce Clipboard.

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

_______ 8. An Excel feature that automatically fi lls cells with data from another cell or range or completes a data series.

_______ 9. Entries that identify the numeric data in a worksheet.

_______ 10. Details about a fi le that describe or identify it and include details such as the author.

True/False

Circle T if the statement is true or F if the statement is false.

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

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

T F 3. Use Ctrl_: to enter the current date in a worksheet cell.

T F 4. 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.

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

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

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

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

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

T F 10. Workbooks can be saved as web pages, PDF fi les, and for use in previous versions of Excel.