wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Lessons 5-10 Vocabulary Test

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

Rows & column labels that reprint on each page of a printout

a)

Orientation

b)

Print titles

c)

Scale

d)

Show formulas

2.

Adjust the size proportionally

a)

Orientation

b)

Print titles

c)

Scale

d)

Show Formulas

3.

A method to rearrange data by switching the positions of columns & rows

a)

Cut

b)

Paste

c)

Clipboard

d)

Transpose

4.

A cell address that can change in a copied formula, so the new address is expressed in relation to the cell containing the copied formula.

a)

Series

b)

Relative reference

c)

Contiguous range

d)

Date

5.

A cell address in a formula that will not change when you copy the formula to another location. I$I

a)

Arithmetic operators

b)

Keyboard shortcuts

c)

Absolute reference

d)

Drag-and-drop

6.

An instruction excel uses to calculate a result

a)

Scale

b)

Formula

c)

Order of precedence

d)

Default column width

7.

A feature that causes long cell entries to appear on multiple lines

a)

Wrap text

b)

Range

c)

SUM function

d)

Noncontiguous range

8.

Keyboard shortcuts for choosing ribbon commands that you display by pressing "ALT"

a)

Date

b)

Key Tips

c)

Collapse Dialog button

d)

Expand Dialog button

9.

A green box on the lower-right corner of the selected cell or range that you can use to fill (copy) a series or formula

a)

Key Tips

b)

Series

c)

Fill handle

d)

Range

10.

The feature that enables Excel to create a series automatically

a)

Range

b)

Series

c)

Show Formula

d)

Auto Fill