wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets Part 1 and 2

Total questions: 50

Worksheet time: 32mins

Name
Class
Date
1.

Which of the following is NOT a spreadsheet?

a)

Google Sheets

b)

Microsoft Excel

c)

Google Docs

d)

none of these

2.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
3.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
4.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
5.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
6.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
7.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
8.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
9.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
10.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
11.
Which cursor allows you to drag and fill a series?
a)
Skinny Plus Sign
b)
Fat Plus Sign
c)
Hand
d)
Arrow
12.
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
13.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
14.
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
15.
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)
16.
It is possible to change the color of a cell border.
a)
True
b)
False
17.

A cell you are currently working on

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

18.

The column and row letter of a cell

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

19.

The procedure to select certain information in a spreadsheet

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

20.

A visual representation of data

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

21.

The horizontal and vertical lines on the spreadsheet

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

22.

Tabs that identify the worksheets in a workbook

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

23.

A number that can be entered into a cell

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

24.
What is the command line above the sheet called where you can enter formulas, text, etc.
a)
autofill
b)
label
c)
column
d)
formula or entry bar
25.

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

26.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
27.

Arranging objects in a certain sequence or order according to specific rules is..

a)

Sort/Filter

b)

Annoying

c)

Search

d)

Seek

28.

What is this icon used for?

a)

Adjusting the Border Style of Selected Cells

b)

Connect Four

c)

4 Square

d)

Rubic's Cube

29.

This button is used to...

a)

merge cells together into on larger cell.

b)

move rectangles to the middle.

c)

point things together.

d)

put some arrows in boxes.

30.

What is the name of this button?

a)

Formula

b)

Function

c)

Cell Address

d)

Sort/ Filter

31.

What is the name of this button?

a)

the "M" button

b)

the backwards 3 button

c)

Function button

d)

the math button

32.

Which one of these functions gives the result shown in the picture?

a)

=COUNTIF(D5:D13,"<>10")

b)

=COUNTIF(D5:D13,"<15")

c)

=COUNTIF(D5:D13,"=16")

d)

=COUNTIF(D5:D13,">=10")

e)

=COUNTIF(D5:D13,">=15")

33.

a method of limiting the entries and responses used in a spreadsheet

a)

Sort

b)

Row

c)

Data Validation

d)

Filter Views

34.

keeps a row/column from moving when scrolling on a sheet making it easier to align data with its correct heading

a)

Column

b)

Filter

c)

Row

d)

Freeze Row/Column

35.

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.

36.

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

a)

True

b)

False

37.

A grid that organizes data

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

38.

A collection of worksheets

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

39.

One page of a spreadsheet

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

40.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

41.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
 =B1+B2
42.

Which icon will change the color of the text?

a)
b)
c)
d)
43.

Sheets can be downloaded as...

a)

.pdf

b)

.xlxs

c)

.csv

d)

All of the Above

e)

None of the Above

44.

Why is data validation used ?

a)

(A) to control the type of data entered

b)

(B) to ensure data entered meets requirements

c)

Both (A) & (B)

d)

None of the above

45.

You can collaborate with others on Google Sheets?

a)

True

b)

False

46.

Filters typically occur by...

a)

Columns

b)

Rows

47.

I can select filter views by...

a)

Color

b)

Condition

c)

Values

d)

All of the These

e)

None of These

48.

I would like to complete Part 3 Google Sheets to learn more Advanced Skills.

a)

Yes - It's Fun! :)

b)

No - It's too Hard :(

49.

Spreadsheets help you...

a)

Analyze Data

b)

Make Calculations

c)

Collect and Find the information you need

d)

None of These

e)

All of These

50.

Raw data from a Google Form can be better organized with

a)

formatting

b)

sorting

c)

data validation

d)

None of These

e)

All of These

Similar Resources on Wayground

Career Clusters

50 questions

Career Clusters

quiz

Worksheet

•

9th - 12th Grade

CompTIA ITFundamentals CRAM

46 questions

CompTIA ITFundamentals CRAM

quiz

Worksheet

•

6th Grade - University

GCSE Computer Science [Component 1]

46 questions

GCSE Computer Science [Component 1]

quiz

Worksheet

•

9th Grade

Tema de Estructuras completo (algunas en inglés)

55 questions

Tema de Estructuras completo (algunas en inglés)

quiz

Worksheet

•

9th - 12th Grade

Komputer Akuntansi XII AK1

50 questions

Komputer Akuntansi XII AK1

quiz

Worksheet

•

KG - 12th Grade

TLE_Illustration-9 Year-End Assessment

51 questions

TLE_Illustration-9 Year-End Assessment

quiz

Worksheet

•

9th Grade

UNIT 5 TEST Boolean Search, Fake News, Current Events.

55 questions

UNIT 5 TEST Boolean Search, Fake News, Current Events.

quiz

Worksheet

•

5th - 9th Grade

Chapter 4: Social Responsibility of Business and Government

45 questions

Chapter 4: Social Responsibility of Business and Government

quiz

Worksheet

•

9th - 12th Grade