wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets

Total questions: 21

Worksheet time: 11mins

Name
Class
Date
1.

What is the name of this cell?

a)

B10

b)

5B

c)

B5

d)

You cannot know the name from this picture

2.

All formulas in Google sheets begin with the following symbol:

a)

+

b)

-

c)

=

d)

%

3.

B1 is called

a)

Row

b)

Cell

c)

Column

d)

Sheet

4.

Select ______________ from the functions drop-down menu to add a set of numbers together.

a)

Average

b)

Count

c)

Max

d)

Sum

5.

Select ___________________ from the functions menu to find the smallest value in a group.

a)

Max

b)

Min

c)

Sum

d)

Average

6.

Which item is FALSE regarding charts in Google Sheets?

a)

You can create pie and line charts.

b)

Charts can't be inserted on their own sheet.

c)

You can change the chart title.

d)

You can put a background color on your chart.

7.

Text wrapping in Sheets means the text will be on more than 1 line within the same cell.

a)

True

b)

False

8.

You can have multiple sheets within the same Google Sheet document.

a)

True

b)

False

9.

You can not adjust a row height or column width.

a)

True

b)

False

10.

Merging cells automatically centers the text within the merged cells.

a)

True

b)

False

11.

It is possible to insert images in Google Sheets

a)

True

b)

False

12.

What is the name of a vertical section of a spreadsheet as selected in the image?

a)

Row

b)

Cell

c)

Column

d)

Format

13.

It is possible to change the color of a cell border.

a)

True

b)

False

14.

The only colors you can change your sheet tabs to are red, blue, green, or yellow.

a)

True

b)

False

15.

Google Sheets is used to?

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

16.

Double-clicking between two columns will ____________ the column.

a)

Delete

b)

Copy

c)

Resize

d)

Fill

17.

Why would you want to change the column width?

a)

To make sure the title is visible

b)

To make sure headings are always visible

c)

To make sure all of the numbers are visible

d)

All of the Above

e)

None of the Above

18.

What is horizontal (left to right)?

a)

Row

b)

Addition

c)

Column

d)

Format

19.

If I want to add a Chart, one way is to select the ____________ tab.

a)

Home

b)

Insert

c)

Page

d)

Data

20.

If I want to make a cell a particular color, which button would I click on?

a)

Format tab

b)

Font style

c)

Text color

d)

Fill color

21.

A Sheets document is called a?

a)

Work page

b)

Work paper

c)

Spreadsheet

d)

Slide