MS Excel - Day 06

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("[e-mail]")

• [e-mail]

• [e-mail]

• [e-mail]

• None of the mentioned

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