Q41. Which function is used to returns the absolute value of a number?
a) ABS
b) VALUE
c) ABSOLUTE
d) AVERAGE
Answer – [A]
Q42. Which function is used to returns a numeric code for a given character?
a) UNICHAR
b) CODE
c) UNICODE
d) TEXT
Answer – [B]
Q43. Which function is used to returns TRUE when a cell is empty, and FALSE when a cell is not empty?
a) EMPTY
b) ISBLANK
c) COUNTBLANK
d) BLANK
Answer – [B]
Q44. Which function is used to extracts text from the left side of the text string?
a) LEFT
b) RIGHT
c) MID
d) STRING
Answer – [A]
Q45. Which function is used to extracts text from the right side of the text string?
a) LEFT
b) RIGHT
c) MID
d) STRING
Answer – [B]
Q46. Which function is used to returns TRUE for any error type?
a) ISFORMULA
b) ISBLANK
c) ISERR
d) ISERROR
Answer – [D]
Q47. Which function is used to returns TRUE for any error type except the #NA error?
a) ISFORMULA
b) ISBLANK
c) ISERR
d) ISERROR
Answer – [C]
Q48. Which function is used to returns the logical value TRUE?
a) TRUE
b) FALSE
c) NOT
d) OR
Answer – [A]
Q49. Which function is used to returns the logical value FALSE?
a) TRUE
b) FALSE
c) NOT
d) OR
Answer – [B]
Q50. Which function is used to extracts data stored in a PivotTabel?
a) GETPIVOTDATA
b) PIVOTDATA
c) TABLE
d) PIVOTTABLE
Answer – [A]