Which function will match multiple values and return the ...
Which function will match multiple values and return the first match in Excel?
IF()
IFS()
IIF()
SWITCH()
Correct answer is D
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")
Show/Hide Gridlines option is available in the ____ menu of Excel. ...
How would you add animations to text, pictures, shapes, and more in your presentation? ...
Which function is used to get the location of text in a string in MS Excel? ...
A __________ lets you place a block of text at a specific location within your document. ...
How can you change an animation effect in a PowerPoint presentation? ...
Which of the following is NOT present in MS Word? ...
You can activate a cell in Excel by ...
What is the keyboard shortcut to view formulas instead of values in MS Excel? ...
Which function is used to remove extra spaces from the text in MS Excel? ...