Have an account?
Skip to Content
Build your own quiz
Computers, Instructional Technology, Business
7th -
9thgrade
Google Sheets Part 1 and 2
50 questions
Show Answers
See Preview
- 1. Multiple Choice
Which of the following is NOT a spreadsheet?
Google Sheets
Microsoft Excel
Google Docs
none of these
- 2. Multiple ChoiceWhich symbol tells the computer you want to create an equation or formula?$+=-
- 3. Multiple ChoiceSpreadsheets work much like the game ________________.MonopolyMinecraftBattleshipYahtzee
- 4. Multiple ChoiceColumns are labeled by ______________.numbersletterssymbolscolors
- 5. Multiple ChoiceRows are labeled by __________.numbersletterssymbolscolors
- 6. Multiple ChoiceA ____________ is where a row and column meet.sheetformulablankcell
- 7. Multiple ChoiceRows run ____________.horizontallydiagonallyverticallymuch faster than columns
- 8. Multiple ChoiceColumns run _______________.verticallydiagonallyhorizontallyreally, really fast
- 9. Multiple ChoiceWhat is the name of this cell?B105BB5you cannot know the name from this picture
- 10. Multiple ChoiceYou can have multiple sheets within the same Google Sheet document.TrueFalse
- 11. Multiple ChoiceWhich cursor allows you to drag and fill a series?Skinny Plus SignFat Plus SignHandArrow
- 12. Multiple ChoiceWhich cursor would you use to auto fit content in a column?vertical line with arrows pointing left and rightplus signhandwhite arrow
- 13. Multiple ChoiceSelect ______________ from the functions drop-down menu to add a set of numbers.averagecountmaxsum
- 14. Multiple ChoiceIf I want to make a cell a particular color, which button would I click on?Format tabFont styleText colorFill color
- 15. Multiple ChoiceWhich is the correct formula to add cells A1 to A5?=SUM(A1+A5)=SUM(A1:A5)=A1+A2+A3=SUM(A1:A4)
- 16. Multiple ChoiceIt is possible to change the color of a cell border.TrueFalse
- 17. Multiple Choice
A cell you are currently working on
Active Cell
Auto Sum
Cell Reference
Column
- 18. Multiple Choice
The column and row letter of a cell
Active Cell
Auto Sum
Cell Reference
Column
- 19. Multiple Choice
The procedure to select certain information in a spreadsheet
Fill
Fill Handle
Filter
Formula
- 20. Multiple Choice
A visual representation of data
Graph
Grid Lines
Row
Selecting
- 21. Multiple Choice
The horizontal and vertical lines on the spreadsheet
Graph
Grid Lines
Row
Selecting
- 22. Multiple Choice
Tabs that identify the worksheets in a workbook
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- 23. Multiple Choice
A number that can be entered into a cell
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- 24. Multiple ChoiceWhat is the command line above the sheet called where you can enter formulas, text, etc.autofilllabelcolumnformula or entry bar
- 25. Multiple Choice
What do these buttons do?
Back space and move forward
Look back before moving forward
Undo or Redo
Get Out the Way
- 26. Multiple ChoiceIf I want to add a Chart, one way is to select the ____________ tab.HomeInsertPage LayoutData
- 27. Multiple Choice
Arranging objects in a certain sequence or order according to specific rules is..
Sort/Filter
Annoying
Search
Seek
- 28. Multiple Choice
What is this icon used for?
Adjusting the Border Style of Selected Cells
Connect Four
4 Square
Rubic's Cube
- 29. Multiple Choice
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.
- 30. Multiple Choice
What is the name of this button?
Formula
Function
Cell Address
Sort/ Filter
- 31. Multiple Choice
What is the name of this button?
the "M" button
the backwards 3 button
Function button
the math button
- 32. Multiple Choice
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")
- 33. Multiple Choice
a method of limiting the entries and responses used in a spreadsheet
Sort
Row
Data Validation
Filter Views
- 34. Multiple Choice
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
- 35. Multiple Choice
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.
- 36. Multiple Choice
Text wrapping in Sheets means the text will be on more than 1 line within the same cell.
True
False
- 37. Multiple Choice
A grid that organizes data
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- 38. Multiple Choice
A collection of worksheets
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- 39. Multiple Choice
One page of a spreadsheet
Sheet Tabs
Spreadsheets
Value
Workbook
Worksheet
- 40. Multiple Choice
What is the name of the yellow highlighted area?
Task bar
Formula bar
Tool bar
Functions
- 41. Multiple ChoiceThe correct formula to add cell B1 and B2 isAddB1+C1=sum(B1+C1)=B1+B2
- 42. Multiple Choice
Which icon will change the color of the text?
- 43. Multiple Choice
Sheets can be downloaded as...
.pdf
.xlxs
.csv
All of the Above
None of the Above
- 44. Multiple Choice
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
- 45. Multiple Choice
You can collaborate with others on Google Sheets?
True
False
- 46. Multiple Choice
Filters typically occur by...
Columns
Rows
- 47. Multiple Choice
I can select filter views by...
Color
Condition
Values
All of the These
None of These
- 48. Poll
I would like to complete Part 3 Google Sheets to learn more Advanced Skills.
Yes - It's Fun! :)
No - It's too Hard :(
- 49. Multiple Choice
Spreadsheets help you...
Analyze Data
Make Calculations
Collect and Find the information you need
None of These
All of These
- 50. Multiple Choice
Raw data from a Google Form can be better organized with
formatting
sorting
data validation
None of These
All of These
- Answer choicesTagsAnswer choicesTags