Excel Functions and Pivot Table Quiz
Authored by sajjan yadav
English
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
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 Microsoft
or continue with
%20(1).png)
Apple
Others
Already have an account?
