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 of the following is an absolute cell reference in Excel? ...
In Microsoft PowerPoint, the entry effect as one slide replaces another in a show is called a/an ...
What are Macros in MS Word? ...
When all the numbers between 0 and 100 in a range should be displayed in red color, apply ...
A PowerPoint ____ is a pattern or blueprint of a slide or group of slides. ...
How many worksheets can a workbook have? ...
How many commands are present in the References tab of Microsoft Word? ...
What is the keyboard shortcut to stop the slideshow of a PowerPoint presentation? ...