wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Computer Apps and Skills Google Sheets Final

Total questions: 32

Worksheet time: 32mins

Name
Class
Date
1.
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
2.
What is a vertical (up and down) section of a spreadsheet
a)
row
b)

Vertical lane

c)
column
d)

Vertical cells

3.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
4.
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
5.
Identify this cell (highlighted)
a)
A3
b)
C3
c)
C1
d)

Anime

6.
If you want to calculate something in a cell, the first symbol you must enter in that cell is?
a)
Plus sign
b)
Open parenthesis
c)
Equal sign
d)
Divide sign
7.

A Sheets document is called a?

a)

Work page

b)

Fullmetal Alchemist

c)

Slide

d)

Spreadsheet

8.
What value would you get if you put in the formula: =B1+C1
a)
2
b)

10

c)
4
d)
Error
9.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)

add

b)
count
c)
max
d)
sum
10.
It is possible to insert images in Google Sheets
a)
True
b)
False
11.
It is possible to change the color of a cell border.
a)
True
b)
False
12.

What is this icon used for?

a)

Inserting capital a "B"

b)

Playing The Bee Movie

c)

Being Beautiful

d)

Making selected text Bold

13.

What is the sign used for subtracting values in a cell?

a)

-

b)

+

c)

*

d)

/

14.

What is the sign for adding values in a cell?

a)

*

b)

-

c)

/

d)

+

15.

What is the sign for multiplying values in a cell?

a)

*

b)

+

c)

-

d)

/

16.

What is the value for dividing values in a cell?

a)

+

b)

/

c)

-

d)

*

17.

A cell's name is based on its column letter and row number. What do you call a cell name?

a)

cell bar

b)

cell address

c)

cell location

18.

What is the name of this cell?

a)

B10

b)

5B

c)

B5

d)

B6

19.

B1 is a?

a)

row address

b)

column address

c)

cell address

d)

sheet address

20.

Google Sheets is a program that allows a user to _____.

a)

create a Google Sheet

b)

create a slide show

c)

write Hip-Hop songs

d)

calculate numerical information

21.

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

a)

row

b)

cell

c)

column

d)

location address

22.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
 =B1+B2
d)
=sum(B1-B2)
23.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
24.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
25.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
26.

You can not adjust a row height or column width.

a)

True

b)

False

27.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)

GTA 5

28.
Which cursor allows you to drag and fill a series?
a)
Skinny Plus Sign
b)
Fat Plus Sign
c)
Hand
d)

Double arrow

29.
This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 
a)

Snoop Dog Arrow

b)
Hand
c)
Arrow
d)
Fat Plus Sign
30.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
31.
You can not give an exact size for a row height or column width.
a)
True
b)
False
32.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Yellow is better bar

d)

Functions