Q21. Which function is used to returns information about a cell in a worksheet?
a) ADDRESS
b) CELL
c) INFO
d) INFORMATION
Answer – [B]
Q22. Which function is used to get information about current environment?
a) ADDRESS
b) CELL
c) INFO
d) INFORMATION
Answer – [C]
Q23. Which function is used to returns TRUE if all the conditions are TRUE, and returns FALSE if one of the conditions is FALSE?
a) OR
b) NOT
c) XOR
d) AND
Answer – [D]
Q24. Which function is used to changes TRUE to FALSE, and FALSE to TRUE?
a) OR
b) NOT
c) XOR
d) AND
Answer – [B]
Q25. Which function is used to returns TRUE if any of the conditions are TRUE, and returns FALSE if all the conditions are FALSE?
a) OR
b) NOT
c) XOR
d) AND
Answer – [A]
Q26. Which function is used to returns a logical ‘Exclusive OR’ of all arguments?
a) OR
b) NOT
c) XOR
d) AND
Answer – [C]
Q27. Which function is used to returns a value from a list of values, based on position number?
a) LIST
b) POSITION
c) CHOOSE
d) REPT
Answer – [C]
Q28. Which function is used to finds and retrieve a value from data in a horizontal table?
a) HLOOKUP
b) VLOOKUP
c) SEARCH
d) FIND
Answer – [A]
Q29. Which function is used to create a clickable link in Excel?
a) SEARCH
b) LINK
c) TRIM
d) HYPERLINK
Answer – [D]
Q30. Which function is used to returns the value at a given location in a range or array?
a) LOCATION
b) INDEX
c) RANGE
d) FIND
Answer – [B]