NEW
Font size
WorksheetsUnit 5: Google Sheets Review
Total questions: 37
Worksheet time: 19mins
___________ is a web-based application that enables users to create, update and modify spreadsheets and share the data online
In Google Sheets, columns are identified by _______ ?
In Google Sheets, rows are identified by ________ ?
In the spreadsheet below, Identify the cell with the red border.
A _______ is where a row and Column intersect.
True or False: Each Cell is identified by a number first and then a letter.
In google sheets, what is another word used for "Equation"?
Which symbol below is used in an addition formula?
Which symbol below is used in an subtraction formula?
Which symbol below is used in a multiplication formula?
Which symbol below is used in a division formula?
In Google sheets, each formula must start with which symbol?
What is a group of selected cells called?
When you are trying to resize your columns to fit the data perfectly and your cursor is in the following position in the image below, how many times do you click to make the column auto fit?
Which menu do you click to add a column to your spreadsheet?
What Google sheets feature do you use to complete a sequence / series / pattern ?
True or False: The Google sheets toolbar is located at the top of the screen.
True or False: You can bold, italicize, and underline data in Google sheets.
True or False: You click and drag the bottom right hand corner (Blue Circle) to use the fill handle.
Which button do you click to change data to a currency?
If I wanted to type a formula where I multiply 5 times 20, which formula below would I use?
If I wanted to type a formula where I add 70 plus 20, which formula below would I use?
A ______ is a premade formula.
Which function would I use if I want to add an entire column of numbers?
Which function do you use to find the average of a range of numbers?
Which function do you use to find the highest number from a range of numbers?
Which function do you use to find the lowest number from a range of numbers?
Which symbol is the insert function button?
What range is selected in the attached image?
B4:E4
B4:E9
B9:E4
B:1:E9
Which of the following is the Icon for Google Sheets?
A
B
C
D
Which of the following is the icon for Google Docs?
A
B
C
D
Which of the following is the icon for Google Slides?
A
B
C
D
You're tracking weekly allowance for your babysitting business. You have the following data:
Which function would you use in cell B6 to find your total earnings for the month?
=AVERAGE(B2:B5)
=SUM(B2:B5)
=MAX(B2:B5)
=B2+B3+B4+B5+B6
Your teacher wants to know your average test score for the semester. Here's your data:
What formula or function should you use to calculate your average test score?
=SUM(B2:B6)/5
=AVERAGE(B2:B6)
=(B2+B3+B4+B5+B6)/5
=B2-B5*B6
You're the team manager for your school's soccer team. You need to find out which player scored the most goals this season:
Which function would help you find the highest number of goals scored?
=MIN(B2:B5)
=SUM(B2:B5)
=MAX(B2:B5)
=AVERAGE(B2:B5)
You're planning a party and tracking how much each friend can contribute. You want to find the smallest donation amount to make sure everyone can afford to participate:
What function will tell you the minimum donation amount?
=MAX(C2:C7)
=MIN(C2:C7)
=AVERAGE(C2:C7)
=SUM(C2:C7)
You run a lemonade stand and want to calculate your profit. You have this data:
What formula should you enter in cell B3 to calculate your profit (Total Sales minus Total Costs)?
=B1+B2
=AVERAGE(B1:B2)
=SUM(B1:B2)
=B1-B2
