Font size
WorksheetsGoogle Sheets
Total questions: 32
Worksheet time: 24mins
In Google Sheets, rows are identified by
Letters
Numbers
In Google Sheets, columns are identified by
Letters
Numbers
In a spreadsheet, what is the small box where a row and column meet called?
Compartment
File
Cell
Formula
What is the name of the yellow highlighted area?
Task bar
Formula bar
Tool bar
Functions
Using cell references, select the correct formula for calculating the initial cost of goldfish.
=b9*c9
b9*c9
.25*6
=.25*6
I forgot to add a column. Which menu should I use?
File
Edit
Format
Insert
Which of the following options will allow all text to fit into one cell without spilling into the next column?
Overflow
Text wrapping
Clip
Which of the following can you do in a spreadsheet?
Sort in alphabetical order
Sort in number order
Sort in reverse alphabetical order
Sort in reverse number order
All of these can be done using spreadsheets
What is used to label the COLUMNS in a Google Sheet?
Letters
Numbers
Letter then Number
Number then Letter
What is used to label the ROWS in a Google Sheet?
Letters
Numbers
Letter then Number
Number then Letter
What is used to label the CELLS in a Google Sheet?
Letters
Numbers
Letter then Number
Number then Letter
Which of the following toolbar items is used to increase the number of decimal places?
Which of the following toolbar items is used to decrease the number of decimal places?
Which of the following toolbar items is used to change the number format to percent?
Which of the following toolbar items is used to change the number format to currency?
You can have multiple sheets on One Google Sheets Document.
True
False
Which of the following formulas can be used to calculate the total of a specified range of cells?
=SUM()
=AVERAGE()
=MAX()
=MIN()
What is the value in cell C5?
(a)
What is the value in cell B3?
(a)
What is the value in cell D1?
(a)
To change the column width or row height, you would navigate to where the column or row is bordered, then click and drag your mouse until you get the desired width or height.
True
False
To create a simple chart, you would click on Insert, then...?
Chart
Image
Drawing
Form
To sum all the data in a column, you could use the following:
The structure of a Google spreadsheet consists of vertical _______________ and horizontal _________________.
Columns; rows
Charts; images
Forms; equations
Formulas; links
Using Google Drive, the sharing settings are the same in Docs, Sheets and Slides
TRUE
FALSE
