Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

open office calc

Total questions: 17

Worksheet time: 9mins

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.

To combine into one

a)

Sort

b)

Filter

c)

Import

d)

Merge

3.

A formula or equation used to generate an answer

a)

Cell Reference

b)

Function

c)

Autofill

d)

AutoSum

4.

A tool which fills in a field or cells automatically

a)

AutoSum

b)

Import

c)

Autofill

d)

Merge

5.

The vertical parts of a spreadsheet denoted by capital letters

a)

Cell Location

b)

Columns

c)

Rows

d)

Cell Reference

6.

The horizontal parts of a spreadsheet denoted by numbers

a)

Rows

b)

Columns

c)

Cell

d)

Relative Reference

7.

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

8.

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

9.

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

a)

Workbook

b)

Worksheet

c)

Painter

d)

Cell Reference

10.

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

a)

Workbook

b)

Sparkline

c)

Cell Location

d)

Worksheet

11.

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

12.

Automatically adds up values in a row or column

a)

AutoSum

b)

Autofill

c)

Import

d)

Export

13.

To put in order

a)

Merge

b)

Function

c)

Filter

d)

Sort

14.

To remove unwanted pieces of data from view in a table

a)

Sort

b)

Merge

c)

Filter

d)

Autofill

15.

A spreadsheet cell that does not change regardless of its attributes

a)

Relative Reference

b)

Cell Reference

c)

Absolute Reference

d)

Cell Location

16.

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

17.

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