Creating Formulas and Functions
Quiz
•
Computers
•
7th - 12th Grade
•
Medium
Susan Crane
Used 36+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Multiply H3 times C4
=H3xC4
H3XC4
H3*C4
=H3*C4
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Add C2 and C3
C2+C3
C3+C2
=C2+C3
=SUM(C2+C3)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Subtract D4 from D3
=D4-D3
=D3-D4
=SUBTRACT(D4-D3)
D3-D4
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Divide E3 by C1
=C1/E3
=E3/C1
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Add the range B2-B10
=B2+B10
=SUM(B2,B10)
=SUM(B2-B10)
=SUM(B2:B10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Add C6 through C10 then subtract C5
=SUM(C6:C10)-C5
=C6+C7+C8+C9+C10-C5
=SUM(C6-C10)/C5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Add A3 and A4 then divide by C10
=A3+A4/C10
=(A3+A4)/C10
=C10/A3+A4
=C10/(A3+A4)
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
10 questions
Python with DataScience
Quiz
•
7th Grade - University
10 questions
T_4.2 Identifier, Data Types, Operators & Expressions
Quiz
•
12th Grade - University
15 questions
bài 4: SỬ DỤNG CÁC HÀM ĐỂ TÍNH TOÁN
Quiz
•
7th Grade
10 questions
UH EXCEL TIK
Quiz
•
10th Grade
10 questions
KISI-KISI PTS INFORMATIKA
Quiz
•
10th Grade
10 questions
Ms Excel - Grade 8
Quiz
•
8th Grade
15 questions
Ms. Exel dan Fungsi Logika IF
Quiz
•
10th Grade - University
12 questions
Bài 12A: Sử dụng hàm IF
Quiz
•
9th Grade - University
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
