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")
To open a new database in MS Access, press ...
Paragraph group is present under which tab in Microsoft Word? ...
Which of the following option is NOT present in Office Button? ...
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________ ...
To open an existing database in MS Access, press ...
In an Excel worksheet, you can select ...
Which of the following is a type of Page Orientation? ...