wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets

Total questions: 70

Worksheet time: 23mins

Name
Class
Date
1.

To add the total of a column or row, you select Function and ...

a)

Add

b)

Sum

c)

Total

d)

Help

2.

What number is the border shortcut?

a)

8

b)

11

c)

9

d)

4

3.

What number is the shortcut toolbar?

a)

1

b)

2

c)

3

d)

4

4.

What number is the word toolbar?

a)

1

b)

2

c)

3

d)

4

5.

What number is the url?

a)

1

b)

2

c)

3

d)

4

6.

What number is the sheet title?

a)

10

b)

2

c)

8

d)

6

7.

What number is the function key (for math formulas)?

a)

12

b)

16

c)

13

d)

10

8.

To add the total of a column or row, you select Function and ...

a)

Add

b)

Sum

c)

Total

d)

Help

9.

What number is the chart shortcut?

a)

8

b)

11

c)

9

d)

4

10.

What number is the tab?

a)

7

b)

13

c)

6

d)

14

11.

How do you rename the tab?

a)

7

b)

13

c)

15

d)

14

12.

Which number is a cell?

a)

5

b)

6

c)

14

d)

13

13.

If I can't see my sheet title or toolbar, I should click on...

a)

13

b)

4

c)

16 carat

d)

5

14.

To move a chart to its own sheet, you need to click on the...

a)

tab

b)

toolbar

c)

3 dots

d)

column

15.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
16.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
17.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
18.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
19.
The little triangle in the top right corner of a cell means there is a ________ with that cell.
a)
formula
b)
number
c)
letter
d)
note
20.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
21.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
22.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
23.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
24.
This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 
a)
Skinny Plus Sign
b)
Hand
c)
Arrow
d)
Fat Plus Sign
25.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
26.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
27.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
28.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
29.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
30.
It is possible to insert images in Google Sheets
a)
True
b)
False
31.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
32.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
33.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
34.
A spreadsheet is made up of all of the following EXCEPT
a)
Rows
b)
Cells
c)
Pictures
d)
Columns
35.
Which cursor allows you to drag and fill a series?
a)

Plus Sign

b)
Fat Plus Sign
c)
Hand
d)
Arrow
36.
Which cursor would you use to auto fit content in a column?
a)
vertical line with arrows pointing left and right
b)
plus sign
c)
hand
d)
white arrow
37.
Which of the following is NOT a spreadsheet?
a)
Google Sheets
b)
Microsoft Excel
c)
Google Docs
d)
none of the above
38.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
39.
In a Google Spreadsheet, the first thing you should type in a cell where you want to insert a formula/function to get an answer is a(n) ____________.
a)
Plus sign
b)
Minus sign
c)
Equal sign
d)
Multiplication sign
40.
In a Google Spreadsheet, you can manually type the function/formula in a cell if the operation is not available in the function drop-down list.
a)
True
b)
False
41.

Google Sheets is used to? (Select ALL that apply?)

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

42.

Double-clicking between two columns will ____________ the column.

a)

Delete

b)

Copy

c)

Resize

d)

Fill

43.

A Sheets document is called a..............

a)

Work page

b)

Work paper

c)

Spreadsheet

d)

Slide

44.

B1 is called

a)

Row

b)

Cell

c)

Column

d)

Sheet

45.

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

a)

Max

b)

Min

c)

Sum

d)

Average

46.

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.

47.

You can not adjust a row height or column width.

a)

True

b)

False

48.

Merging cells automatically centers the text within the merged cells.

a)

True

b)

False

49.

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

a)

True

b)

False

50.

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

a)

True

b)

False

51.

Google Sheets is used to?

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

52.

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

a)

Home

b)

Insert

c)

Page

d)

Data

53.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

54.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
55.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
56.

What is the name of this button?

a)

Function button

b)

the backwards 3 button

57.
What is it called when you hold your mouse button down to select a group of cells?
a)
fill down
b)
fill right
c)
drag
d)
row
58.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
59.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
60.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
61.

Look at the picture. What is the result of the MIN function?

a)

16

b)

20

c)

25

d)

15

62.

What is this icon used for?

a)

Rubic's cube

b)

Adjusting the border style of selected cells

c)

Connect 4

d)

4 Square

63.

What is this icon used for?

a)

Moving your zeros

b)

Adding or taking away decimals

c)

Changing direction

d)

Adding 10ths and 100ths

64.

These are found at the beginning of a row that contain a number inside it.

a)

Column Heading

b)

Column Number

c)

Row Number

d)

Row Heading

65.

The cell ready to enter text or numbers with the blue box around it is call the....

a)

Active Cell

b)

Active Box

c)

Ready Cell

d)

Cell Box

66.

The cell's name, or the address of the cell is called the....

a)

Cell Box

b)

Cell Reference

c)

Cell Position

d)

Position Name

67.

Multiple adjacent cells selected at the same time is called a...

a)

Cell Cluster

b)

Cluster Cells

c)

Cell Range

d)

Cell group

68.

The small box in the bottom right corner of a cell is called?

a)

Fill Handle

b)

Fill Box

c)

Box Option

d)

Box Fill

69.

The boxes at the top of each column with a letter inside is called the...

a)

Column Heading

b)

Column Label

c)

Column Box

d)

Label Box

70.

If I wanted to collect data and create a graph for my science fair data, I should use

a)

Google Docs

b)

Google Sheets

c)

Google Slides

d)

Google Forms

Similar Resources on Wayground

English Level Tests - Grammar A1 to B2

70 questions

English Level Tests - Grammar A1 to B2

quiz

Worksheet

•

9th Grade - Professio...

AWS Certified Cloud Practitioner - Simulado 01

65 questions

AWS Certified Cloud Practitioner - Simulado 01

quiz

Worksheet

•

Professional Development

Rapid Fire Q&A Quiz

70 questions

Rapid Fire Q&A Quiz

quiz

Worksheet

•

Professional Development

Level Up - CCM Basic III (Officer)

75 questions

Level Up - CCM Basic III (Officer)

quiz

Worksheet

•

Professional Development

Fundamental of Computer Principles (2023 Final's PREP) sem 1

70 questions

Fundamental of Computer Principles (2023 Final's PREP) sem 1

quiz

Worksheet

•

Professional Development

VERNACULAR TERMS IMAGES

73 questions

VERNACULAR TERMS IMAGES

quiz

Worksheet

•

Professional Development

Leasing Agent IT Quiz

65 questions

Leasing Agent IT Quiz

quiz

Worksheet

•

Professional Development

Management and Team Working Skills Quiz

70 questions

Management and Team Working Skills Quiz

quiz

Worksheet

•

Professional Development