
Excel Formulas Quiz
Quiz
•
Computers
•
7th Grade
•
Practice Problem
•
Medium
Mr A Sheik
Used 20+ times
FREE Resource
Enhance your content in a minute
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of using the SUM function on the following set of numbers: 3, 5, and 7?
10
15
12
18
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you have the values 10 in cell A1 and 20 in cell A2, what formula should you use to subtract A1 from A2?
=A2-A1
=A1-A2
=SUB(A2,A1)
=MINUS(A2,A1)
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How do you multiply the values in cells A1 (5) and A2 (4) using an Excel formula?
=A1+A2
=A1*A2
=MULTIPLY(A1,A2)
=A1^A2
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the result of dividing 20 by 4 in Excel?
4
5
80
0.2
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Using Excel, if you need to sum the numbers 8, 13, and 21 which are in cells A1, A2, and A3 respectively, what would be the correct formula?
=SUM(A1:A3)
=ADD(A1:A3)
=A1+A2+A3
Both A) and C) are correct
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula will you use to subtract the number in cell B1 (15) from the number in cell A1 (30)?
=A1-B1
=SUBTRACT(A1,B1)
=B1-A1
=DIFF(A1,B1)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If you want to divide the number in cell A1 (50) by the number in cell B1 (10), which formula is correct?
=A1/B1
=DIVIDE(A1,B1)
=A1\B1
=A1 divided by B1
Create a free account and access millions of resources
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
12 questions
Spreadsheet
Quiz
•
5th - 11th Grade
10 questions
5. Final Excel Quiz
Quiz
•
7th Grade
12 questions
Spreadsheets for year 7
Quiz
•
7th Grade
10 questions
Formulas in Excel
Quiz
•
6th - 9th Grade
10 questions
BÀI 8 + BÀI 9
Quiz
•
7th Grade
12 questions
Kiểm tra giửa kỳ 2 - Tin học 7
Quiz
•
7th Grade
10 questions
Grade 8 (Analyst Data)
Quiz
•
7th Grade
12 questions
prep1-revision
Quiz
•
7th Grade
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
