Formulas and Functions Drill
Authored by Rogevir Rivera
Computers
4th Grade
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
18 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Choose the correct formula:
Cells: A1, B1
Operation: Addition
=A1+B1
=A1-B1
=A1*B1
2.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Choose the correct formula:
Cells: A1, B1
Operation: Subtraction
=A1+B1
=A1-B1
=A1/B1
3.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Choose the correct formula:
Cells: A1, B1
Operation: Multiplication
A1*B1=
=A1xB1
=A1*B1
4.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Choose the correct formula:
Cells: A1, B1
Operation: Division
A1/B1=
=A1/B1
=A1÷B1
5.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Choose the correct syntax:
Cells: A1:A20
Function name: SUM
=SUM(A1:A20)
=TOTAL(A1:A20)
=(A1:A20)SUM
6.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Choose the correct syntax:
Cells: A1:A20
Function name: AVERAGE
=AVERAGE(A1,A20)
=AVERAGE(A1:A20)
=(A1:A20)AVERAGE
7.
MULTIPLE CHOICE QUESTION
10 sec • 1 pt
Choose the correct syntax:
Cells: A1:A20
Function name: COUNT
=COUNT(A1:A20)
=COUNT(A1,A20)
=COUNT[A1:A20]
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
22 questions
Coding and Using Code.Org
Quiz
•
3rd - 4th Grade
13 questions
Technology Expectations
Quiz
•
2nd - 5th Grade
20 questions
Excel Spreadsheet Intro
Quiz
•
KG - University
20 questions
Parts Of Computer
Quiz
•
4th - 5th Grade
16 questions
MS Excel
Quiz
•
3rd - 4th Grade
20 questions
MS-Word Grade IV
Quiz
•
3rd - 5th Grade
18 questions
Word Tables and Tabs
Quiz
•
4th - 11th Grade
20 questions
CodeMonkey
Quiz
•
1st Grade - Professio...
Popular Resources on Wayground
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Latin Bases claus(clois,clos, clud, clus) and ped
Quiz
•
6th - 8th Grade
22 questions
fractions
Quiz
•
3rd Grade
7 questions
The Story of Books
Quiz
•
6th - 8th Grade
Discover more resources for Computers
8 questions
2 Step Word Problems
Quiz
•
KG - University
20 questions
Comparing Fractions
Quiz
•
4th Grade
15 questions
Adding and Subtracting Fractions with Like Denominators
Quiz
•
4th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
5 questions
Drama
Quiz
•
3rd - 4th Grade
15 questions
Fractions on a Number Line
Quiz
•
4th Grade
10 questions
Martin Luther King, Jr. For Kids
Interactive video
•
1st - 12th Grade
20 questions
Equivalent Fractions
Quiz
•
4th Grade