Exel Formulas
Quiz
•
Computers
•
6th - 8th Grade
•
Practice Problem
•
Medium
Joshua Coleman
Used 116+ times
FREE Resource
Enhance your content in a minute
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What formula needs to be inserted into cell B6?
=TOTAL(B1:B5)
=(B1:B5)TOTAL
=SUM(B1:B5)
=(B1:B5)SUM
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula has been entered into cell D10?
=2*£0.25
=D10*C10
=B10*C10
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is being used in cell D6?
=4*£1.00
C6+B6
=D6*B6
=B6*C6
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is being used in cell D2?
=D2*C2
=B2*C2
=10*£0.25
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula is being used in cell D11?
SUM(D10 to D2)=
=SUM(D2,D10)
=(D2:D10)SUM
=SUM(D2:10)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the cell range for A?
B2 to B6
A4:A5
A4,A5
A4 to A5
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the cell range for B?
B2,B6
A4:A5
A8, D8
B2:B6
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
10 questions
Microsoft Excel 2010
Quiz
•
6th Grade
15 questions
Microsoft Excel Review
Quiz
•
6th - 8th Grade
15 questions
kiểm tra lớp 5
Quiz
•
1st - 12th Grade
10 questions
INFORMATIKA
Quiz
•
7th Grade
13 questions
Microsoft Word 2016 Tables
Quiz
•
8th - 12th Grade
11 questions
Spreadsheet Charts & Advanced Functions
Quiz
•
6th - 8th Grade
10 questions
Microsoft Excel Basics
Quiz
•
5th Grade - University
15 questions
運算思維二
Quiz
•
8th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd 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
