Which function is used to create a Date with year, month, and day in Excel?
DATE()
DATEDIF()
DATEVALUE()
CURDATE()
Correct answer is A
The DATE() function is used to create a date with year, month, and day.
Syntax:
=DATE (year, month, day)
Example:
=DATE(2022,8,26) // returns Aug 26, 2022
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 function is used to trap and handle #N/A errors in Excel?
IFERROR()
ERROR()
IFNA()
IFERRORNA()
Correct answer is C
The IFNA() function is used to trap and handle #N/A errors.
Syntax:
=IFNA (value, value_if_na)
Example:
=IFNA(VLOOKUP(A5,xtable,2,0),"Error: Not found")
Which function is used to trap and handle errors in Excel?
IFERROR()
ERROR()
IFNA()
IFTRAP()
IFERRORTHENTRAP()
Correct answer is A
The IFERROR() function is used to trap and handle errors.
Syntax:
=IFERROR (value, value_if_error)
Example:
=IFERROR (A2/C2,"Please enter a value in C2")
What is the correct syntax of IF() function in Excel?
=IF (logical_test, {[value_if_true]}, {[value_if_false]})
=IF (logical_test, TRUE([value_if_true]), FALSE([value_if_false]))
=IF (logical_test: [value_if_true], [value_if_false])
=IF (logical_test, [value_if_true], [value_if_false])
Correct answer is D
The correct syntax of IF() function is:
=IF (logical_test, [value_if_true], [value_if_false])