wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheet Key Terms

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

The intersection of a column and row is a

a)

Connection Point

b)

Cell

c)

Box

d)

Insertion Point

2.

A _______________ is a way of visually showing information in a spreadsheet to make it easier to understand

a)

Chart

b)

Formula

c)

Function

d)

None of the Above

3.

This word describes the contents of a cell and can be numbers, text, colors, etc.

a)

Form

b)

Chart

c)

Fill

d)

Insert

4.

The horizontal parts of a spreadsheet that are labeled numerically

a)

Columns

b)

Rows

c)

Functions

d)

Cells

5.

When you do this, you put the information in alphabetical or numerical order

a)

Round Up

b)

Insert

c)

Sort

d)

Store

6.

Numbers in a spreadsheet that will be used for calculations

a)

Values

b)

Text

c)

Functions

d)

Formulas

7.

The vertical parts (Up and down) of a spreadsheet that are labeled alphabetically

a)

Columns

b)

Rows

c)

Cells

d)

Boxes

8.

The editable settings in spreadsheet software that allow you to change the display of each cell

a)

Formulas

b)

Functions

c)

Formats

d)

None of the Above

9.

An expression which calculates the value of a cell (ex. 1+2=?)

a)

Fills

b)

Formulas

c)

Fonts

d)

Formats

10.

A built in formula that calculates such things as average, sum

a)

Function

b)

Format

c)

Fill

d)

Font

11.

A visual representation of the information in a spreadsheet

a)

Pie Chart

b)

Bar Chart

c)

Line Chart

d)

All of the above

12.

Selecting cells by clicking and dragging over the cells you want included

a)

Format

b)

Fill

c)

Copy

d)

Highlight

13.

What you are doing when you are putting text into a box.

a)

Format

b)

Copy

c)

Insert

d)

Highlight

14.

A selection of 2 or more cells that lets you perform an action on a group of cells at once

a)

Copy

b)

Format

c)

Range

d)

Function

15.

The file that contains the individual worksheets

a)

Worksheets

b)

Workbook

c)

Workout

d)

None of the Above

16.

The cell in which you are working, outlined in a darker color than the rest of the cells

a)

Last Cell

b)

Next Cell

c)

Active Cell

d)

Inactive Cell

17.

A built-in shortcut that will add up a group of numbers

a)

Average

b)

Mean

c)

Autosum

d)

Mode

18.

The individual "pages" inside a workbook

a)

Worksheet

b)

Workbook

c)

Worksite

d)

Worktab

19.

When calculating your grades, you would use the "average" function

a)

True

b)

False

20.

Microsoft's version of a spreadsheet is called Sheets

a)

True

b)

False