Excel Assessment
Quiz
•
Other
•
Professional Development
•
Practice Problem
•
Medium
Gibburion Analytics
Used 2+ times
FREE Resource
Enhance your content in a minute
55 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
What is the shortcut for creating a new workbook?
Ctrl + P
Ctrl + O
Ctrl + N
Ctrl + S
2.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
Which function is used to find the average of a range of numbers?
AVG
SUM
AVERAGE
MIN
3.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
What symbol is used to start a formula in Excel?
@
+
=
#
4.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
How do you create an absolute cell reference?
&A1
A1
#A1
$A$1
5.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
Which of the following is a valid cell reference?
A1
1A
$1A
A#1
6.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
What does the VLOOKUP function do?
Calculates the sum of a range of cells
Searches for a value in a horizontal row
Looks for a value in a vertical column
Finds the average of a set of numbers
7.
MULTIPLE CHOICE QUESTION
10 sec • 2 pts
Which of these formulas will add the values in cells A1 through A5?
=SUM(A1:A5)
=SUMMATION(A1:A5)
=ADD(A1:A5)
=SUM(A1;A5)
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
50 questions
Taruna Akpol
Quiz
•
Professional Development
50 questions
SERTIFIKASI HR CABANG
Quiz
•
Professional Development
56 questions
General knowledge quiz
Quiz
•
Professional Development
53 questions
UQ/L-3/BK-2/Assessment/English
Quiz
•
3rd Grade - Professio...
50 questions
REDES1
Quiz
•
University - Professi...
50 questions
The NBA All-Time quiz (Hard)
Quiz
•
Professional Development
50 questions
(MI PA) TEBAK GAMBAR TOKOH & LOGO BANOM NU
Quiz
•
Professional Development
50 questions
II_III Years-Java, Python, and C Quiz
Quiz
•
Professional Development
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 Other
44 questions
Would you rather...
Quiz
•
Professional Development
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
12 questions
Mardi Gras Trivia
Quiz
•
Professional Development
14 questions
Valentine's Day Trivia!
Quiz
•
Professional Development
7 questions
Copy of G5_U5_L14_22-23
Lesson
•
KG - Professional Dev...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
11 questions
NFL Football logos
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development
