Advanced Excel Quiz #2
True or False: VLOOKUP function in Excel performs a case-insensitive lookup
True
False
True or False: The VLOOKUP function always looks up a value in the leftmost column of a table and returns the corresponding value from a column to the left.
True
False
This Function checks whether a condition is met, and returns one value if true and another value if false
IF
AND
OR
NOT
This Function changes TRUE to FALSE, and FALSE to TRUE.
IF
AND
OR
NOT
This Function returns TRUE if all conditions are true and returns FALSE if any of the conditions are false
IF
AND
OR
NOT
This Function returns TRUE if any of the conditions are TRUE and returns FALSE if all conditions are false.
IF
AND
OR
NOT
What will be the result on the red highlighted cell based on the given formula?
Good
Bad
What will be the result on the red highlighted cell based on the given formula?
Excellent
Satisfactory
Good
Poor
What will be the result on the red highlighted cell based on the given formula?
X
"Blank"
True
False
{"name":"Advanced Excel Quiz #2", "url":"https://www.quiz-maker.com/Q6JN5Y2Q","txt":"True or False: VLOOKUP function in Excel performs a case-insensitive lookup, True or False: The VLOOKUP function always looks up a value in the leftmost column of a table and returns the corresponding value from a column to the left., This Function checks whether a condition is met, and returns one value if true and another value if false","img":"https://cdn.poll-maker.com/56-2237302/if-and.jpg?sz=1200"}