Font size
WorksheetsGSheet Quiz
Total questions: 20
Worksheet time: 7mins
Google Sheets is used to?
Add numbers.
Make charts (graphs).
Put information in columns and rows.
Collect Data
What is horizontal (left to right)?
Row
Addition
Column
Format
If I want to add a Chart, one way is to select the ____________ tab.
Home
Insert
Page
Data
What number should be in E1 (based on the formula)?
1
2
5
9
The little triangle in the top right corner of a cell means there is a ________ with that cell.
error
number
letter
note
An electronic document in which data is arranged in the rows and columns and can uses calculations.
Spreadsheet
Cell Address
Function
Sum
What is the name of the yellow highlighted area?
Task bar
Formula bar
Tool bar
Functions
Conditional formatting is used when you want to highlight negative numbers by red text.
True
False
What does it mean to merge cells?
apply a border around a set of cells
center the text content in the center of the cell
combine cells into a single cell
split a single cell into multiple cells
What column or row references would be updated when you copy the formula? = sum(C3:$d25)
Column D and Row 25
Column C and Row 3 and Row 25
Column C and Row 3
Column D and Row 3
What set of data is in descending order?
4, 3, 1, 2
7/1/2017, 6/2/2017, 5/3/2018, 4/2/2016
grapes, pineapples, bananas, oranges
sheep, rabbits, ponies, ostriches
What function should be entered into B7 to calculate the total budget?
=MAX(B3:B6)
=AVERAGE(B3:B6)
=SUM(B3:B6)
=SUM(B3-B6)
Is Column C being used to filter this spreadsheet?
YES
NO
