Google Sheets Quiz - Basic Formulas and Functions
Assessment
•
Hillary Bishop
•
Computers
•
7th Grade
•
205 plays
•
Medium
Student preview
20 questions
Show answers
1.
Multiple Choice
1. The "order of operations" defines which parts of a complex formula are calculated first.
True
False
2.
Multiple Choice
2. Which formula is a simple formula?
=E10/5+1
=5+A1*B1
=C3+10-E3
=10-(A3-D13)
3.
Multiple Choice
3. What is the argument in this function? =AVERAGE(B11:H14)
B11
B11:H14
H11
AVERAGE
4.
Multiple Choice
4. In the formula "=A3/B3", what part of the formula is the "/"?
An operator
An operand
5.
Multiple Choice
5. Which of these statements about cell references is NOT true?
You can enter a cell references in a formula by typing in the reference.
Cell references make it easy to use values from other cells in a formula
You can enter a cell reference in a formula by clicking the cell location on the spreadsheet.
Cell references can only be entered in a formula by using the Formula Bar
Explore all questions with a free account
Find a similar activity
Create activity tailored to your needs using
.svg)
Google Sheets Basics
•
7th Grade
Google Sheets Formula Test
•
7th Grade
AES Excel 1: Essentials - Basic Formulas
•
6th - 8th Grade
Writing Formulas in Spreadsheets
•
7th Grade
Basic Formula Review
•
6th - 8th Grade
Google Sheets Basic Formulas
•
7th Grade
Google Sheets Formulas
•
7th Grade
Google Sheets Problems
•
7th Grade