Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Spreadsheets 1 Test

Total questions: 29

Worksheet time: 15mins

Name
Class
Date
1.

This button moves the decimal 1 place to the left for each selected cell.

a)

Decrease decimal button

b)

Currency button

c)

Undo and Redo the button

d)

Insert Chart button

2.

named by letters (A, B, C...)

a)

Rows

b)

Columns

c)

Cells

d)

Cell grid

3.

Copies the contents of the current cell to multiple cells below or to the right.

a)

Merge

b)

Cell range

c)

Fill handle

d)

Copy handle

4.

Used to handle text that is too big to fit within a cell. Allows text to: overflow, wrap, or clip within the selected cell.

a)

Text wrapping button

b)

Vertical Align button

c)

Font size button

d)

Text color button

5.

Allows users to insert a link to the selected cell.

a)

Insert chart button

b)

Text color button

c)

Undo and redo buttons

d)

Insert link button

6.

This button opens a menu with several number formatting options (number, percent, scientific, financial).

a)

Fill color button.

b)

More formats button.

c)

Text color button.

d)

Italic button.

7.

Used to change the text to a different font name.

a)

Font size button.

b)

Insert chart button

c)

Text color button

d)

Font style button.

8.

The intersection of a column and a row in a table or worksheet.

a)

cell

b)

columns

c)

merge

d)

rows

9.

Used to change the color of the text.

a)

Vertically align button.

b)

Text color button.

c)

Text wrapping button.

d)

Font style button.

10.

Used to copy formatting from one cell to another.

a)

Paint format button

b)

Text color button

c)

Merge button

d)

Fill color button

11.

This adds a dollar sign, a decimal, and two zeroes to the selected cells.

a)

Currency button

b)

Share button

c)

Freeze button

d)

Border button

12.

Alerts Google Sheets that you are entering a formula or function and not text

a)

number sign

b)

equal sign

c)

share button

d)

fill handle

13.

Allows user to insert charts to a spreadsheet and customize the charts.

a)

Insert link button

b)

Text color button

c)

Comment button

d)

Insert chart button

14.

A spreadsheet can have multiple pages called ____. The name of each page is found on a tab at the bottom of the screen.

a)

Merge

b)

Cell

c)

Columns

d)

Sheets

15.

A cell reference that adjusts to its new location when copied or moved

a)

cell

b)

relative cell reference

c)

cell range

d)

absolute cell reference

16.

Used to make text slant.

a)

Merge button

b)

Bold button

c)

Italic button

d)

Undo and redo buttons

17.

The left button removes the last action. The right button adds a removed action back to the spreadsheet.

a)

Undo and Redo buttons

b)

Fill handle

c)

Rows are Named by

d)

Columns are Named by

18.

Displays the print dialog box that is used to print the worksheet.

a)

Print button

b)

Printer selection

c)

Text color button

d)

Functions button

19.

Used to align text: left, right, or center within a cell.

a)

Vertical align button

b)

Horizontal align button

c)

Font size button

d)

Fill color button

20.

Allows users to share a spreadsheet with others.

a)

Insert link button

b)

Share button

c)

Merge button

d)

Fill color button

21.

A reference that does not change when the formula is copied or moved to a new location.

a)

relative cell reference

b)

cell range

c)

absolute cell reference

d)

mixed cell reference

22.

Used to merge two or more cells into one.

a)

Bold button

b)

Italic button

c)

Paint format button

d)

Merge button

23.

named by numbers (1, 2, 3, ...)

a)

Rows

b)

Cell

c)

Columns

d)

Index

24.

Used to make the text darker.

a)

Italic button.

b)

Bold button.

c)

Paint format button

d)

Merge button

25.

Button used to define a border.

a)

Vertical align button

b)

Bold button

c)

Font style button

d)

Borders button

26.

Used to change the text to a larger or smaller size.

a)

Text wrapping button

b)

Font style button

c)

Fill color button

d)

Font size button

27.

To combine multiple cells into one cell.

a)

Cell Range

b)

Autofit

c)

Merge

d)

Cell

28.

Used to add background color to selected cells in a spreadsheet.

a)

Merge button

b)

Paint format button

c)

Font size button

d)

Fill color button

29.

A group of adjacent cells you select to perform operations on all of the selected cells.

a)

merge

b)

cell range

c)

fill handle

d)

cell address