wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Unit 6 | Spreadsheet Vocabulary

Total questions: 20

Worksheet time: 7mins

Name
Class
Date
1.

Light gray lines that divide each of the cells, rows, and columns in a spreadsheet

a)

Sparkline

b)

Gridlines

c)

Worksheet

d)

Cell Location

2.

A tool that allows you to copy animations or formatting easily from one object to another

a)

Painter

b)

Function

c)

Autofill

d)

Workbook

3.

To format data in such a way that it can be used by another application

a)

Autofill

b)

Export

c)

Import

d)

Merge

4.

To use data produced by another program

a)

Filter

b)

Import

c)

Export

d)

Sort

5.

To combine into one

a)

Sort

b)

Filter

c)

Import

d)

Merge

6.

A formula or equation used to generate an answer

a)

Cell Reference

b)

Function

c)

Autofill

d)

AutoSum

7.

A tool which fills in a field or cells automatically

a)

AutoSum

b)

Import

c)

Autofill

d)

Merge

8.

The vertical parts of a spreadsheet denoted by capital letters

a)

Cell Location

b)

Columns

c)

Rows

d)

Cell Reference

9.

The horizontal parts of a spreadsheet denoted by numbers

a)

Rows

b)

Columns

c)

Cell

d)

Relative Reference

10.

Referring to a rectangle on a spreadsheet by naming the column and then row in which it lies

a)

Cell Location

b)

Absolute Reference

c)

Cell Reference

d)

Sparkline

11.

The rectangular fields you can type in on a spreadsheet formed when a column and row intersect

a)

Worksheet

b)

Cell

c)

Workbook

d)

Painter

12.

The entire spreadsheet file you are working in. It can contain one or more worksheets

a)

Workbook

b)

Worksheet

c)

Painter

d)

Cell Reference

13.

A part/page on a spreadsheet file you are working in

a)

Workbook

b)

Sparkline

c)

Cell Location

d)

Worksheet

14.

A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes

a)

Gridlines

b)

Painter

c)

Sparkline

d)

Workbook

15.

Automatically adds up values in a row or column

a)

AutoSum

b)

Autofill

c)

Import

d)

Export

16.

To put in order

a)

Merge

b)

Function

c)

Filter

d)

Sort

17.

To remove unwanted pieces of data from view in a table

a)

Sort

b)

Merge

c)

Filter

d)

Autofill

18.

A spreadsheet cell that does not change regardless of its attributes

a)

Relative Reference

b)

Cell Reference

c)

Absolute Reference

d)

Cell Location

19.

A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on

a)

Relative Reference

b)

Cell Reference

c)

Absolute Reference

d)

Cell Location

20.

Refers to a cell or range of cells on a worksheet and can be used in a formula so the program can find the values or data you want a formula to calculate

a)

Relative Reference

b)

Cell Reference

c)

Absolute Reference

d)

Cell Location