wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets/Charts & Graphs

Total questions: 60

Worksheet time: 49mins

Name
Class
Date
1.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
2.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
3.
=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.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
6.
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
7.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
8.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
9.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
10.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
11.
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
12.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
13.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
14.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
15.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
16.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
17.
You can not give an exact size for a row height or column width.
a)
True
b)
False
18.
It is possible to insert images in Google Sheets
a)
True
b)
False
19.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
20.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
21.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
22.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
23.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
24.
A spreadsheet is made up of all of the following EXCEPT
a)
Rows
b)
Cells
c)
Pictures
d)
Columns
25.
Which cursor allows you to drag and fill a series?
a)
Skinny Plus Sign
b)
Fat Plus Sign
c)
Hand
d)
Arrow
26.
Which of the following is NOT a spreadsheet?
a)
Google Sheets
b)
Microsoft Excel
c)
Google Docs
d)
none of the above
27.

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.

28.

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

a)

True

b)

False

29.

It is possible to insert images in Google Sheets

a)

True

b)

False

30.

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

a)

True

b)

False

31.

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

a)

True

b)

False

32.

Google Sheets is used to?

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

33.

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

34.

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

a)

Home

b)

Insert

c)

Page

d)

Data

35.

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

36.

A Sheets document is called a?

a)

Work page

b)

Work paper

c)

Spreadsheet

d)

Slide

37.

expressions which return values

a)

Rows

b)

Filter Views

c)

Formulas

d)

Columns

38.

pre-set formulas used to make calculations in Google Sheets

a)

Formulas

b)

Functions

c)

Column

d)

Average

39.

adds a range of values in spreadsheet cells

a)

Column

b)

Sort

c)

Charts

d)

SUM function

40.
graphic representations used to compare and contrast worksheet data
a)
Charts
b)
Row
c)
Relative Cell Reference
d)
Filter
41.

Which programs are used to calculate spreadsheets?

a)

Microsoft publisher & Google templates

b)

Microsoft excel & Google sheets

c)

Microsoft powerpoint & Google slides

d)

Microsoft word & Office 365

42.

Which is NOT a type of chart?

a)

pie

b)

column

c)

bar

d)

axis

43.

What does autosum do?

a)

subtracts totals

b)

adds totals

c)

multiplies totals

d)

divides totals

44.

Which chart would I use to show how Team Teachers beat Team Students in the bowling tournament?

a)

column

b)

xy scatter

c)

pie

d)

line

45.

Which type of chart would you create to compare groups of data?

a)

pie

b)

line

c)

bar

d)

column

46.

Why are charts/graphs used in spreadsheets?

a)

to show a visual of the data in a spreadsheet

b)

to make the spreadsheet look cool

c)

to backup the data you input into the spreadsheet

d)

all of these are reasons

47.

Which is NOT a formula?

a)

b2+b3+b4

b)

=b1+b2+b3

c)

=b4*c4

d)

=b5/b7

48.

Which icon represents currency?

a)

*

b)

&

c)

$

d)

@

49.

What is the first thing you have to do in a spreadsheet before you can create a chart/graph?

a)

click insert charts/graphs

b)

go to file, print

c)

highlight the data with your mouse

d)

bold all the information

50.

Which chart would you use to show trends or changes over time?

a)

stacked bar chart

b)

pie chart

c)

bar chart

d)

line chart

51.

A pie chart is used to do what?

a)

show trends over time

b)

represent only one series of data

c)

show the correlation of two or more sets of data

d)

show how many pieces you can eat

52.

When you open a Google Sheet the file is called a

a)

Document

b)

Slideshow

c)

Spreadsheet

d)

Publication

53.

Boxes in spreadsheets are called

a)

squares

b)

cells

c)

boxes

d)

units

54.

Information typed into a spreadsheets is called

a)

data

b)

info

c)

research

d)

text

55.

Google Sheets is used to?

a)

Add numbers

b)

Make charts/graphs

c)

Work with data

d)

All of the above

56.

If you want to create a graph, what is the first step after typing in the data?

a)

Select the chart button

b)

Select the data by highlighting it

c)

Go to Chart Editor

d)

Go to Series

57.

Once you highlight the data, what is the next step to create a graph?

a)

Go to the Format tab

b)

Widen the cell

c)

Go to Chart Editor

d)

Select the Insert Chart button on the right

58.

How can you change the type of graph?

a)

Go to the Insert tab

b)

Go to Chart Editor

c)

Go to the Functions button

59.

Data Labels are used to

a)

Show the value on each bar in a graph

b)

Change the title of the graph

c)

Add values in a spreadsheet

60.

What section in Chart Editor do you go to to add Data Labels?

a)

Chart Style

b)

Series

c)

Format Data Points

Similar Resources on Wayground

LỚP 6_ÔN THI HK1_2022 2023

55 questions

LỚP 6_ÔN THI HK1_2022 2023

quiz

Worksheet

•

6th - 8th Grade

Grade 8 Quiz Quarter 2

55 questions

Grade 8 Quiz Quarter 2

quiz

Worksheet

•

7th Grade

DeskTop Publishing Test in Review

60 questions

DeskTop Publishing Test in Review

quiz

Worksheet

•

8th Grade

FTC CenterStage Prep Quiz

60 questions

FTC CenterStage Prep Quiz

quiz

Worksheet

•

8th Grade

BTEC L2 IT Online World Aim A Quiz

63 questions

BTEC L2 IT Online World Aim A Quiz

quiz

Worksheet

•

6th - 10th Grade

Quarter 1 - LONG QUIZ

55 questions

Quarter 1 - LONG QUIZ

quiz

Worksheet

•

7th - 9th Grade

Year 8 End of Year Assessment

60 questions

Year 8 End of Year Assessment

quiz

Worksheet

•

7th - 9th Grade

Y8 Term 3 Python recap

60 questions

Y8 Term 3 Python recap

quiz

Worksheet

•

8th Grade