wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Excel Vocabulary and Functions

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

The name of the cell is determined by the name of the row and the column intersecting, such as A8.

a)

Cell Grid

b)

Cell Address

c)

Headings

d)

Active Cell

2.

A document that is stored on your computer. In Excel, a file is also known as a workbook.

a)

File

b)

AutoFill

c)

AutoSum

d)

Cell

3.

A feature that allows you to copy information in an active cell to another cell or range of cells selected vertically.

a)

Function

b)

Fill Right

c)

AutoFill

d)

Fill Down

4.

A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.

a)

Fill Right

b)

AutoFill

c)

Fill Down

d)

Function

5.

The lines on your worksheet that separate the columns and rows.

a)

Fill Down

b)

Cell Grid

c)

Cell Address

d)

Active Cell

6.

The identifying name that reflects the information contained in a column or row in a worksheet, such as name or date.

a)

Headings

b)

Cell

c)

File

d)

Label

7.

The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.

a)

File

b)

Cell

c)

Label

d)

Drag

8.

A combination of numbers and symbols used to express a calculation.

a)

Formula Bar

b)

Formula

c)

Workbook

d)

AutoSum

9.

A function that automatically identifies and adds ranges of cells in your worksheet.

a)

AutoFill

b)

AutoSum

c)

Workbook

d)

Formula

10.

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

a)

Fill Right

b)

AutoSum

c)

Fill Down

d)

AutoFill

11.

Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook.

a)

Fill Down

b)

Sheet Tabs

c)

Fill Right

d)

Headings

12.

In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.

a)

Drag

b)

Workbook

c)

Column

d)

Row

13.

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

a)

Active Cell

b)

Cell Address

c)

Cell Grid

d)

Formula Bar

14.

A 'page' within an Excel workbook that contains columns, rows, and cells.

a)

Workbook

b)

AutoSum

c)

Formula

d)

Worksheet

15.

When you move the mouse while holding down the mouse button (usually the left) to select a range of cells.

a)

Drag

b)

Cell

c)

File

d)

Row

16.

The identifying letters and numbers for columns and rows. Columns are identified with letters, rows with numbers.

a)

Label

b)

AutoFill

c)

Headings

d)

Cell Address

17.

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

a)
Fill Down
b)
AutoSum
c)

Fill Right

d)
AutoFill
18.

A feature that allows you to copy information in an active cell to another cell or range of cells you have selected horizontally.

a)
Fill Right
b)
AutoFill
c)

Cell Address

d)
Fill Down
19.

An Excel file that contains individual worksheets. Also called a spreadsheet file.

a)

Worksheet

b)

Formula

c)

AutoSum

d)

Workbook

20.

In a worksheet, the vertical spaces with headings A, B, C, and so on. AutoSum Row Column Formula

a)

AutoSum

b)

Row

c)

Column

d)

Formula