Excel Functions & Formulas Review
Authored by Alyson Walls
Computers
9th - 12th Grade
Used 17+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
1. Which of the following is not an arithmetic operator?
+
-
*
]
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an acceptable name for a named range?
C7
subtotal_west
subtotal west
subtotal/west
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of an absolute cell reference?
A9
A$9
$A$9
A9:E9
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is an example of an mixed cell reference?
A9
A$9
$A$9
A9:E9
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To allow Excel to distinguish formulas from data, all formulas must begin with
+
cell reference
function name
=
6.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.
True
False
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
The order of operations determines which parts of a formula are calculated before other parts of the formula.
True
False
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
38 questions
IT-Security (easy4me.info)
Quiz
•
8th - 12th Grade
44 questions
AP Computer Science Principles Units 1, 2 & 3
Quiz
•
10th - 12th Grade
35 questions
EmTech Q1 Reviewer
Quiz
•
11th Grade
40 questions
Soal Latihan Simdig
Quiz
•
10th Grade
35 questions
ATS ASJ Ganjil 24-25 TJKT2
Quiz
•
11th Grade
36 questions
PARTS OF COMPUTER TEST
Quiz
•
12th Grade
40 questions
KUIS TEKPER 1
Quiz
•
10th Grade
35 questions
G9 Summative LO 2. Assess own work and LO 3. Engage in quality I
Quiz
•
9th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
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
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
Exploring Valentine's Day with Charlie Brown
Interactive video
•
6th - 10th Grade
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
El Verbo IR Practice
Quiz
•
9th Grade
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
10 questions
Valentine's Day History and Traditions
Interactive video
•
6th - 10th Grade
20 questions
Graphing Inequalities on a Number Line
Quiz
•
6th - 9th Grade
20 questions
Exponent Properties
Quiz
•
9th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade