A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.
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])