Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Vocabulary - Google Sheets

Total questions: 18

Worksheet time: 9mins

Name
Class
Date
1.

a collection of worksheets which are stored together in a single file and given a single name.

a)

Workbook

b)

Cells

c)

Row

d)

Column

2.

a single sheet (page) of rows and columns in a workbook

a)

Cells

b)

Worksheets

c)

Row

d)

Column

3.

intersection of a column and a row on a worksheet

a)

Column

b)

Row

c)

Cells

d)

Freeze Row/Column

4.

a range of cells that go down (vertical) in a spreadsheet/worksheet

a)

Column

b)

Data Validation

c)

Row

d)

Sort

5.
a range of cells that go across (horizontal) the spreadsheet/worksheet
a)
Row
b)
Filter Views
c)
Data Validation
d)
Filter
6.

keeps a row/column from moving when scrolling on a sheet making it easier to align data with its correct heading

a)

Column

b)

Filter

c)

Row

d)

Freeze Row/Column

7.

a method of limiting the entries and responses used in a spreadsheet

a)

Sort

b)

Row

c)

Data Validation

d)

Filter Views

8.

puts date from a specific range, such as a column, in numerical or alphabetical order

a)

Filter

b)

Sort

c)

Column

d)

SUM function

9.

temporarily hide data in a spreadsheet so you see only a selection of specific rows or values

a)

Data Validation

b)

Formulas

c)

SUM function

d)

Filter

10.
visible only when selected
a)
Filter Views
b)
Functions
c)
Row
d)
Column
11.

expressions which return values

a)

Rows

b)

Filter Views

c)

Formulas

d)

Columns

12.

pre-set formulas used to make calculations in Google Sheets

a)

Formulas

b)

Functions

c)

Column

d)

Average

13.

adds a range of values in spreadsheet cells

a)

Column

b)

Sort

c)

Charts

d)

SUM function

14.
graphic representations used to compare and contrast worksheet data
a)
Charts
b)
Row
c)
Relative Cell Reference
d)
Filter
15.

change when a formula is copied to another cell

a)

Row

b)

Filter Views

c)

Relative Cell Reference

d)

Absolute Cell Reference

16.

remain constant when you copy them to another cell

a)

Relative Cell Reference

b)

Absolute Cell Reference

c)

Charts

d)

Functions

17.
the middle value in a set of numbers
a)
Average
b)
Filter
c)
Sort
d)
Formulas
18.

changes the background color of cells that contain specific information

a)

Sort

b)

Formulas

c)

Average

d)

Conditional Formatting