wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets Quiz

Total questions: 36

Worksheet time: 3hrs 0mins

Name
Class
Date
1.

The correct formula to add cell B1 and B2 is

a)

AddB1+C1

b)

=add(b1:b2)

c)

=B1+B2

d)

=total(B1-B2)

2.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
3.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
4.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
5.
What value would you get if you put in the formula: =B1+C1
a)
2
b)
3
c)
4
d)
Error
6.
What number should be in E1 (based on the formula shown)?
a)
1
b)
3
c)
5
d)
9
7.

Which is the correct formula to add cells A1 thru A5?

a)

=SUM(A1+A5)

b)

=SUM(A1:A5)

c)

=A1+A5

d)

=SUM(A1:A4)

8.

The function to find the smallest value in a group is

a)

max

b)

min

c)

sum

d)

average

9.

When you sort information, it can only be sorted by the first column of information.

a)

True

b)

False

10.
Text wrapping in Sheets means the text will be on more than 1 line within the same cell.
a)
True
b)
False
11.

You can adjust the size of columns in Sheets.

a)

True

b)

False

12.
Merging cells automatically centers the text within the merged cells.
a)
True
b)
False
13.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
14.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
15.

Where would you click to select a column?

a)

A

b)

B

c)

C

d)

D

16.

Which letter on the image is a column?

a)

A

b)

B

c)

C

d)

D

17.

Which letter on the image is a Cell?

a)

A

b)

B

c)

C

d)

D

18.

What is the address of the indicated cell?

a)

B4

b)

4B

c)

C4

d)

B5

19.

What symbol is used to designate an absolute cell reference?

a)

!

b)

%

c)

@

d)

$

20.

Where is the formula bar?

a)

A

b)

B

c)

C

d)

D

21.
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
22.
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
23.
Why would you want to freeze rows in your spreadsheet?
a)
To limit the data that can be entered in the frozen row
b)
Scroll through the spreadsheet continuing to see frozen rows
c)
To modify only the frozen rows
d)
To control the rows from being edited by collaborators
24.

Which picture represents Google Sheets?

a)
b)
c)
d)
25.

How would you format a large amount of text to fit in a single cell?

a)

Overflow

b)

Wrap

c)

Clip

d)

It's not possible.

26.
Select ______________ from the functions drop-down menu to add a set of numbers together. 
a)
average
b)
count
c)
max
d)
sum
27.

Mr. Tone wanted to see which student received the highest score on the last Quizizz. In his spread sheet he used the ______________ function to identify the highest score.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

28.

Betty has a spreadsheet of sales for her bakery for a month. In one column she lists the amount of donuts sold each day. If she wanted to find out what day she sold the LEAST amount of donuts she would use the _________________ function.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

29.

What do these buttons do?

a)

Back space and move forward

b)

Look back before moving forward

c)

Undo or Redo

d)

Get Out the Way

30.
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
31.

Which cursor represents AUTOFILL

a)

b)
c)

d)
32.

True or False? Google sheets saves your changes automatically.

a)

True

b)

False

33.

A group of cells is called a _______.

a)

chart

b)

multicell

c)

cell cluster

d)

cell range

34.

Which of the following features allows you to narrow down the data in your worksheet?

a)

Sorting

b)

Relative cell reference

c)

Merge cells

d)

Filters

35.

Which of the following symbols are recognized as mathematical operations within Google Sheets? Select all that apply.

a)

*

b)

^

c)

x

d)

+

e)

@

36.

Which of the following is an absolute cell reference?

a)

$A$2

b)

A2

c)

#A2

d)

A:2

Similar Resources on Wayground

Alg2 Exam Review U1-6 (20-21)

38 questions

Alg2 Exam Review U1-6 (20-21)

quiz

Worksheet

•

9th - 12th Grade

The 4 operators - add subtract multiply divide

35 questions

The 4 operators - add subtract multiply divide

quiz

Worksheet

•

6th - 12th Grade

Concept Check: Data Displays and Types of Data

33 questions

Concept Check: Data Displays and Types of Data

quiz

Worksheet

•

9th - 12th Grade

Unit 6, Indicator 24, Greatest Common Factor

35 questions

Unit 6, Indicator 24, Greatest Common Factor

quiz

Worksheet

•

9th - 12th Grade

Complex Numbers 2

37 questions

Complex Numbers 2

quiz

Worksheet

•

12th Grade

Mathematics Is Fun

40 questions

Mathematics Is Fun

quiz

Worksheet

•

1st Grade - University

Statistics Chapter 8.1 & 8.2 Review

40 questions

Statistics Chapter 8.1 & 8.2 Review

quiz

Worksheet

•

11th Grade - University

KBAT 2

40 questions

KBAT 2

quiz

Worksheet

•

3rd Grade - University