wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheet Terminology Review

Total questions: 18

Worksheet time: 6mins

Name
Class
Date
1.

The space formed by the intersection of a row and a column; the basic unit of a worksheet. (tiny rectangles on a spreadsheet)

a)

Spreadsheet

b)

Cell

c)

Worksheet

d)

Word Processor

2.

A vertical group of cells in a worksheet identified by letters

a)

Row

b)

Column

c)

Table

d)

Chart

3.

A horizontal group of cells in a worksheet identified by numbers

a)

Table

b)

Chart

c)

Row

d)

Column

4.

The position of data within a cell

a)

Index

b)

Tab

c)

Indent

d)

Alignment

5.

A selected worksheet cell that is ready for data entry.

a)

Cell name

b)

Active Cell

c)

Cell box

d)

Selector cell

6.

An equation that calculates a new value using values currently on a spreadsheet.

a)

Formula

b)

Function

c)

Equatiot

7.

A function that automatically adds the values in the cells directly above or to the left of the active cell.

a)

Average

b)

Max

c)

Autosum

d)

Min

8.

To copy a cell’s contents and/or formatting into an adjacent cell or range. (Allows Excel to recognize patterns in formulas and functions)

a)

Paste & Review

b)

Fill

c)

Find & Replace

d)

Autocopy

9.

A unique identifier for a cell which is formed by combining the cell's column letter and row number

a)

Cell reference

b)

Cell box

c)

Name box

d)

Name location

10.

A prewritten formula that makes it easy to perform common calculations

a)

Function

b)

Formula

c)

Phase

d)

Autocalculate

11.

Value, cell reference, range, or text that acts as an operand in a function formula

a)

formula

b)

function

c)

argument

d)

sum

12.

Selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colon

a)

Active cell

b)

Group

c)

Range

d)

Series

13.

A cell reference that adjusts to a new location when it is copied or moved.

a)

Absolute cell reference

b)

Relative cell reference

c)

Argument

d)

Operand

14.

A cell reference that does not adjust or change to the new cell location when it is copied or moved by using the fill handle.

a)

Relative cell reference

b)

Absolute cell reference

c)

Function reference

d)

Formula reference

15.

Tool that allows you to apply formats to a cell or range depending on the value of the cell

a)

Copy & Paste

b)

Format painter

c)

Conditional formatting

d)

Cell formatter

16.

A small chart in a cell that shows a visual representation of data for a row

a)

Pie chart

b)

Sparkline chart

c)

Bar chart

d)

Column chart

17.

A symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply (*), divide (/)

a)

Symbol

b)

Operator

c)

Sign

d)

Post

18.

Displays the address of the active cell or range on the worksheet.

a)

Cell Locator

b)

Insert function

c)

Formula Bar

d)

Name box