Google News
logo
Microsoft Excel - Quiz(MCQ)
Which function is used to match multiple values and returns the first match?
A)
IF()
B)
SWITCH()
C)
IIF()
D)
IFS()

Correct Answer : Option (B) :   SWITCH()


Explanation :

The SWITCH() function is used to match multiple values and returns the first match.
 
Syntax : =SWITCH (expression, val1/result1, [val2/result2], ..., [default])

Example : =SWITCH(G4,0,"Sun",1,"Mon",2,"Tue",3,"Wed",4,"Thu",5,"Fri",6,"Sat")

Advertisement