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")
Which option is used to hide/show the Headings in MS Excel? ...
In MS Access, AutoNumber data type__? ...
By using the ___, we can see all slides at once in PowerPoint. ...
Which of the following Charts can be created in Excel? ...
Which of the following method can insert a new slide in current presentation? ...
Which of the following shortcut key is used to check spelling when required? ...
To create a table in MS Access ...
In Microsoft Excel, shortcut key CTRL + D is used to ____ ...