NEW
Font size
WorksheetsGoogle Sheets: Spreadsheets, Charts and Functions
Total questions: 15
Worksheet time: 8mins
When you open a Google Sheet the file is called a
Document
Slideshow
Spreadsheet
Publication
Boxes in spreadsheets are called
squares
cells
boxes
units
How are columns in spreadsheets labelled?
As numbers
As symbols
As shapes
As letters
Information typed into a spreadsheets is called
data
info
research
text
In order to perform calculations in Google Sheets which button do you select on the toolbar?
+
Σ
xy
=
What menu item do you choose to sort a list of names from A to Z?
Inert
Tools
Data
View
When using the Data menu, what do you choose to sort data by more than one criteria?
Sort sheet by column A, A → Z
Sort sheet by column A, Z ← A
Sort Range
When using Data Sort, what do you select to sort more than one criteria?
Data has a header row
Sort
Cancel
Add another sort column
When sorting data with more than one criteria, what can you select to see headers to sort by?
A → Z
Z → A
Data has a header row
Add another sort column
Google Sheets is used to?
Add numbers
Make charts/graphs
Work with data
All of the above
If you want to create a graph, what is the first step after typing in the data?
Select the chart button
Select the data by highlighting it
Go to Chart Editor
Go to Series
Once you highlight the data, what is the next step to create a graph?
Go to the Format tab
Widen the cell
Go to Chart Editor
Select the Insert Chart button on the right
How can you change the type of graph?
Go to the Insert tab
Go to Chart Editor
Go to the Functions button
Data Labels are used to
Show the value on each bar in a graph
Change the title of the graph
Add values in a spreadsheet
What section in Chart Editor do you go to to add Data Labels?
Chart Style
Series
Format Data Points
