Have an account?
Skip to Content
Computers, Instructional Technology, Business
7th -
9thgrade
Google Sheets Part 1 and 2
50 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.
Which of the following is NOT a spreadsheet?
Google Sheets
Microsoft Excel
Google Docs
none of these
- Multiple ChoicePlease save your changes before editing any questions.Which symbol tells the computer you want to create an equation or formula?$+=-
- Multiple ChoicePlease save your changes before editing any questions.Spreadsheets work much like the game ________________.MonopolyMinecraftBattleshipYahtzee
- Multiple ChoicePlease save your changes before editing any questions.Columns are labeled by ______________.numbersletterssymbolscolors
- Multiple ChoicePlease save your changes before editing any questions.Rows are labeled by __________.numbersletterssymbolscolors
- Multiple ChoicePlease save your changes before editing any questions.A ____________ is where a row and column meet.sheetformulablankcell
- Multiple ChoicePlease save your changes before editing any questions.Rows run ____________.horizontallydiagonallyverticallymuch faster than columns
- Multiple ChoicePlease save your changes before editing any questions.Columns run _______________.verticallydiagonallyhorizontallyreally, really fast
- Multiple ChoicePlease save your changes before editing any questions.What is the name of this cell?B105BB5you cannot know the name from this picture
- Multiple ChoicePlease save your changes before editing any questions.You can have multiple sheets within the same Google Sheet document.TrueFalse
- Multiple ChoicePlease save your changes before editing any questions.Which cursor allows you to drag and fill a series?Skinny Plus SignFat Plus SignHandArrow
- Multiple ChoicePlease save your changes before editing any questions.Which cursor would you use to auto fit content in a column?vertical line with arrows pointing left and rightplus signhandwhite arrow
- Multiple ChoicePlease save your changes before editing any questions.Select ______________ from the functions drop-down menu to add a set of numbers.averagecountmaxsum
- Multiple ChoicePlease save your changes before editing any questions.If I want to make a cell a particular color, which button would I click on?Format tabFont styleText colorFill color
- Multiple ChoicePlease save your changes before editing any questions.Which is the correct formula to add cells A1 to A5?=SUM(A1+A5)=SUM(A1:A5)=A1+A2+A3=SUM(A1:A4)
- Multiple ChoicePlease save your changes before editing any questions.It is possible to change the color of a cell border.TrueFalse
- Multiple ChoicePlease save your changes before editing any questions.
A cell you are currently working on
Active Cell
Auto Sum
Cell Reference
Column
- Multiple ChoicePlease save your changes before editing any questions.
The column and row letter of a cell
Active Cell
Auto Sum
Cell Reference
Column
- Multiple ChoicePlease save your changes before editing any questions.
The procedure to select certain information in a spreadsheet
Fill
Fill Handle
Filter
Formula
- Multiple ChoicePlease save your changes before editing any questions.
A visual representation of data
Graph
Grid Lines
Row
Selecting
- Multiple ChoicePlease save your changes before editing any questions.
The horizontal and vertical lines on the spreadsheet
Graph
Grid Lines
Row
Selecting
- Multiple ChoicePlease save your changes before editing any questions.
Tabs that identify the worksheets in a workbook
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- Multiple ChoicePlease save your changes before editing any questions.
A number that can be entered into a cell
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- Multiple ChoicePlease save your changes before editing any questions.What is the command line above the sheet called where you can enter formulas, text, etc.autofilllabelcolumnformula or entry bar
- Multiple ChoicePlease save your changes before editing any questions.
What do these buttons do?
Back space and move forward
Look back before moving forward
Undo or Redo
Get Out the Way
- Multiple ChoicePlease save your changes before editing any questions.If I want to add a Chart, one way is to select the ____________ tab.HomeInsertPage LayoutData
- Multiple ChoicePlease save your changes before editing any questions.
Arranging objects in a certain sequence or order according to specific rules is..
Sort/Filter
Annoying
Search
Seek
- Multiple ChoicePlease save your changes before editing any questions.
What is this icon used for?
Adjusting the Border Style of Selected Cells
Connect Four
4 Square
Rubic's Cube
- Multiple ChoicePlease save your changes before editing any questions.
This button is used to...
merge cells together into on larger cell.
move rectangles to the middle.
point things together.
put some arrows in boxes.
- Multiple ChoicePlease save your changes before editing any questions.
What is the name of this button?
Formula
Function
Cell Address
Sort/ Filter
- Multiple ChoicePlease save your changes before editing any questions.
What is the name of this button?
the "M" button
the backwards 3 button
Function button
the math button
- Multiple ChoicePlease save your changes before editing any questions.
Which one of these functions gives the result shown in the picture?
=COUNTIF(D5:D13,"<>10")
=COUNTIF(D5:D13,"<15")
=COUNTIF(D5:D13,"=16")
=COUNTIF(D5:D13,">=10")
=COUNTIF(D5:D13,">=15")
- Multiple ChoicePlease save your changes before editing any questions.
a method of limiting the entries and responses used in a spreadsheet
Sort
Row
Data Validation
Filter Views
- Multiple ChoicePlease save your changes before editing any questions.
keeps a row/column from moving when scrolling on a sheet making it easier to align data with its correct heading
Column
Filter
Row
Freeze Row/Column
- Multiple ChoicePlease save your changes before editing any questions.
Which item is FALSE regarding charts in Google Sheets?
You can create pie and line charts.
Charts can't be inserted on their own sheet.
You can change the chart title.
You can put a background color on your chart.
- Multiple ChoicePlease save your changes before editing any questions.
Text wrapping in Sheets means the text will be on more than 1 line within the same cell.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
A grid that organizes data
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- Multiple ChoicePlease save your changes before editing any questions.
A collection of worksheets
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- Multiple ChoicePlease save your changes before editing any questions.
One page of a spreadsheet
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- Multiple ChoicePlease save your changes before editing any questions.
What is the name of the yellow highlighted area?
Task bar
Formula bar
Tool bar
Functions
- Multiple ChoicePlease save your changes before editing any questions.The correct formula to add cell B1 and B2 isAddB1+C1=sum(B1+C1)=B1+B2
- Multiple ChoicePlease save your changes before editing any questions.
Which icon will change the color of the text?
- Multiple ChoicePlease save your changes before editing any questions.
Sheets can be downloaded as...
.pdf
.xlxs
.csv
All of the Above
None of the Above
- Multiple ChoicePlease save your changes before editing any questions.
Why is data validation used ?
(A) to control the type of data entered
(B) to ensure data entered meets requirements
Both (A) & (B)
None of the above
- Multiple ChoicePlease save your changes before editing any questions.
You can collaborate with others on Google Sheets?
True
False
- Multiple ChoicePlease save your changes before editing any questions.
Filters typically occur by...
Columns
Rows
- Multiple ChoicePlease save your changes before editing any questions.
I can select filter views by...
Color
Condition
Values
All of the These
None of These
- PollPlease save your changes before editing any questions.
I would like to complete Part 3 Google Sheets to learn more Advanced Skills.
Yes - It's Fun! :)
No - It's too Hard :(
- Multiple ChoicePlease save your changes before editing any questions.
Spreadsheets help you...
Analyze Data
Make Calculations
Collect and Find the information you need
None of These
All of These
- Multiple ChoicePlease save your changes before editing any questions.
Raw data from a Google Form can be better organized with
formatting
sorting
data validation
None of These
All of These