Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets Review

Total questions: 35

Worksheet time: 28mins

Name
Class
Date
1.
Allows you to narrow down data in your worksheets
a)
Sorting
b)
Filtering
c)
Absolute Cell Reference
d)
Merge Cells
2.
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
3.
Which function would you use to add the values of several cells?
a)
SUM
b)
AVERAGE
c)
MIN
d)
MAX
4.
 If you wanted to arrange your data by column A from highest to lowest value, you would _____ it.
a)
Sort
b)
Filter
c)
Add
d)
Reference
5.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
6.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
7.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
8.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
9.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
10.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
11.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
12.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
13.
Which of the following is NOT a spreadsheet?
a)
Google Sheets
b)
Microsoft Excel
c)
Google Docs
d)
none of the above
14.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
15.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
16.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
17.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
18.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
19.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
20.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
21.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
22.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
23.

In Google Sheets, rows are identified by

a)

Letters

b)

Numbers

24.

In Google Sheets, columns are identified by

a)

Letters

b)

Numbers

25.

Which of the following options will allow all text to fit into one cell without spilling into the next column?

a)

Overflow

b)

Text wrapping

c)

Clip

26.

Which of the following can you do in a spreadsheet?

a)

Sort in alphabetical order

b)

Sort in number order

c)

Sort in reverse alphabetical order

d)

Sort in reverse number order

e)

All of these can be done using spreadsheets

27.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
28.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
29.
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
30.
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
31.
It is essential for a business owner to track their expenses and income by using a spreadsheet application like Google Sheets.
a)
True
b)
False
32.

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.

33.

You can not adjust a row height or column width.

a)

True

b)

False

34.

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

35.
The only colors you can change your sheet tabs to are red, blue, green, or yellow.
a)
True
b)
False

Similar Resources on Wayground

Bisnis online XII Bisnis Daaring dan Pemasaran 1

30 questions

Bisnis online XII Bisnis Daaring dan Pemasaran 1

quiz

Worksheet

•

12th Grade

BKTCHKII Tin 6 BS3

40 questions

BKTCHKII Tin 6 BS3

quiz

Worksheet

•

6th - 8th Grade

Grip, Electric, & Cameras

30 questions

Grip, Electric, & Cameras

quiz

Worksheet

•

9th - 12th Grade

FINAL_QUIZ_TERM2_Authorware

30 questions

FINAL_QUIZ_TERM2_Authorware

quiz

Worksheet

•

9th - 10th Grade

Flowcharts

35 questions

Flowcharts

quiz

Worksheet

•

9th Grade

Computer: Internet

40 questions

Computer: Internet

quiz

Worksheet

•

6th - 10th Grade

ตอบปัญหาคอมพิวเตอร์ (Computer)

30 questions

ตอบปัญหาคอมพิวเตอร์ (Computer)

quiz

Worksheet

•

9th - 12th Grade

1ºFPB Tema 1: Tramitación de información

30 questions

1ºFPB Tema 1: Tramitación de información

quiz

Worksheet

•

9th Grade