Advance Excel Quiz
Authored by Rakesh undefined
Computers
Professional Development
Used 7+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
28 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will be the result of =ROUND(14.567,1)?
14.6
14.4
14.56
15
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to find the remainder of a division operation in Excel?
MOD
QUOTIENT
REMAINDER
INT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If A1=10, A2=3, what will =POWER(A1,A2) return?
100
1000
30
1
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function calculates the average while ignoring blank cells?
AVERAGE
AVERAGEIF
AVERAGEA
AVERAGEX
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will be the output of =IF(A1>10, "High", "Low") if A1=5?
High
Low
Error
True
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does =AND(A1>10, A2<5) return if A1=12 and A2=6?
TRUE
FALSE
#VALUE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function returns TRUE if at least one condition is TRUE?
AND
OR
NOT
XOR
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?
