WorksheetsIntro to Sheets (Part 2)
Total questions: 20
Worksheet time: 10mins
Which letter on the image is a COLUMN?
A
B
C
D
Which letter on the image is a CELL?
A
B
C
D
What is the address of the indicated cell?
B4
4B
C4
B5
In a spreadsheet, all formulas must begin with what symbol?
#
$
!
=
What function should be entered into B7 to calculate the total budget?
=SUM(B3:B6)
=CALCULATE(B3:B6
=SUM(B3-B6)
=AVERAGE(B3:B6)
Which Sheets tool stops the topmost row(s) or leftmost column(s) from moving as the user scrolls through the document?
Column
Freeze
Row
Cells
Which option would you choose to combine two or more cells within a single rectangular area (to make one large cell)?
Merge
Freeze
Cells
Columns
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
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()
FILTERS temporarily hide data so that you only see a certain selection.
True
False
Which tool allows you to save a view or arrangement of data so that you can save it for future viewing/use?
Filter
Sorting
Filter Views
Conditional Formatting
What is one way Sheets allows you to VISUALLY show/represent data or information?
Graphs
Cell Range
Conditional Formatting
Filter Views
In order to count how many orders of milk chocolate were submitted, you would use the _________ formula.
=SUM( )
=COUNTIF( )
Which tool in Google Sheets allows you to control the type of information in particular cells?
Number Formatting
Fill Color
Data Validation
Adjusting Column Widths
Karen wants to use data validation to add a drop down so people can select yes or no. What should Karen click?
A
B
C
D
With __________, you can take data from a specific range, such as a column, and put it in numerical or alphabetical order.
typing
sorting
Google Docs
alphabetizing
To easily count how many times APARTMENT appears on the sheet, what would be the correct way to use the COUNTIF formula?
=COUNTIF (Apartment)
=COUNTIF (A1:D11, "Apartment")
=COUNTIF (B2, B4, B6, "Apartment")
=COUNTIF (C3:D11, "Apartment")
