Have an account?
Skip to Content
Build your own quiz
Suggestions for you
Computers
7th
grade
Google Sheets Quiz - Basic Formulas and Functions
20 questions
Show Answers
See Preview
- 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
- 6. Multiple Choice
6. In the formula =10+C5, what part of the formula is the "10"?
An operator
An operand
- 7. Multiple Choice
7. Define the following operator: +
Subtraction
Division
Addition
Multiplication
- 8. Multiple Choice
8. Define the following operator: *
Multiplication
Addition
Division
Subtraction
- 9. Multiple Choice
9. A cell reference in a formula allows you to point to another cell location?
True
. False
- 10. Multiple Choice
10. Using the correct order of operations, what does this formula equal? =5+3*2
=11
=20
=15
=10
- 11. Multiple Choice
11. Using the correct order of operation, what does this formula equal? =4/(5-3)*2
=4
=2
=3
=1
- 12. Multiple Choice
12. Which of the following is a valid formula?
(C2-D16)
=B5/10
A2/F2
=E10
- 13. Multiple Choice
13. Clicking on a cell will show its content in the Formula Bar.
True
False
- 14. Multiple Choice
14. Which formula is a complex formula?
=D6/E10
=10-(A3-D13)
=C3+10+E3
=5+A1*B1
- 15. Multiple Choice
15. In this formula, =12*27+(71-54), which calculation would be performed first?
12*27
27+(71-54)
71-54
It is unknown
- 16. Multiple Choice
16. Which formula contains a cell reference?
=21-6
=G10
=10+13
=F6/3
- 17. Multiple Choice
17. Cell A1 contains the formula "=10+D2". If you copied A1 to B3, what would be the formula in B3?
=10+B3
=10+B4
=10+E3
=10+E4
- 18. Multiple Choice
18. What is the best formula for finding the total value for cells B2 through B5?
=B1++B5
=SUM(B2:B5)
=B2+B3+B4+B5
=13.5+6.08+7.53+45.1
- 19. Multiple Choice
19. Where is the Formula Bar?
A
B
C
D
- 20. Multiple Choice
20. Which function would return the number 2?
=AVERAGE(A2:B5)
=MAX(A2:B5)
=SUM(A2:B5)
=MIN(A2:B5)
- Answer choicesTagsAnswer choicesTags