Excel Functions and Pivot Table Quiz
Quiz
•
English
•
Professional Development
•
Practice Problem
•
Hard
sajjan yadav
Used 1+ times
FREE Resource
Enhance your content in a minute
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the `=MAX(A1:A10)` return?
Minimum value
Sum
Largest value
Count
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to count numeric values only?
COUNTA
COUNT
LEN
AVERAGE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the `=LEFT("Excel",2)` return?
"Ex"
"El"
"ce"
Error
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the use of `=TRIM()` function in Excel?
Text combine करने के लिए
Extra spaces हटाने के लिए
Text को छोटा करने के लिए
कुछ नहीं
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns today’s date?
NOW
DATE
TODAY
TIME
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to join texts?
CONCATENATE
SUM
JOIN
LINK
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the use of `=IF(A1>10, "High", "Low")`?
Comparison
Sum
Average
Formatting
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
25 questions
Grammar tet
Quiz
•
Professional Development
25 questions
Moni's Review
Quiz
•
Professional Development
25 questions
1B
Quiz
•
Professional Development
25 questions
English Placement Test
Quiz
•
Professional Development
26 questions
U 7 Top Notch 1
Quiz
•
Professional Development
25 questions
Use of English A2+ Quiz3
Quiz
•
Professional Development
25 questions
English Verbs Quiz - GES1
Quiz
•
Professional Development
25 questions
So B1 Unit 8
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for English
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
100 questions
Screening Test Customer Service
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
10 questions
Reading a ruler in Inches
Quiz
•
4th Grade - Professio...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development
