WorksheetsMS Excel - Day 06
Total questions: 10
Worksheet time: 5mins
What does AVERAGE function do if the selected range has blanks/text in it?
It ignores those
It returns error
It takes those into account for calculation
None of the mentioned
The main difference between AVERAGEIF and AVERAGEIFS function is
AVERAGEIF checks multiple conditions whereas AVERAGEIFS checks one condition
AVERAGEIF checks one condition whereas AVERAGEIFS checks multiple conditions
Both works in a similar manner
None of the mentioned
What is the difference between LARGE and MAX function?
Both works same
LARGE can be used to find the largest of a range whereas MAX is used to find the Nth maximum of a range
LARGE can be used to find the Nth largest of a range whereas MAX is used to find the largest of a range
None of the mentioned
What will be the output of the following? Assume A2 hold the value Alex
LEFT(A2, 0)
A
x
Error
Blank
What will be the output of the following? Assume A2 hold the value Pooja
RIGHT(A2, -1)
P
a
Error
Blank
What will the following function do?
MID(B3,7,5)
Extracts 5 characters beginning from the 7th character of B3
Extracts 7 characters beginning from the 5th character of B3
Error
None of the mentioned
LEN function will work only for text values
TRUE
FALSE
What will be the output of the following function?
PROPER("john@gmail.com")
Suppose we have some data in Excel. What will happen to the invalid data if we apply data validation to it?
Invalid data gets deleted
Invalid data gets circled
Nothing happens
Data validation cannot be applied to existing data
Which among the following keys allows to do various named range operations?
F2
F3
F4
F9
