Q51. Which function is used to returns the number of areas in a given reference?
a) DATA
b) NUMBER
c) AREA
d) AREAS
Answer – [D]
Q52. Which function is used to returns the address for a cell based on a given row and column number?
a) CELL
b) INFO
c) ADDRESS
d) INFORMATION
Answer – [C]
Q53. Which function is used to removes all spaces from a text string except for single spaces between words?
a) TEXT
b) TEXTJOIN
c) CUT
d) TRIM
Answer – [D]
Q54. Which function is used to return the serial number of the last day of the month before or after a specified number of months?
a) MONTH
b) EOMONTH
c) DAY
d) NETWORKDAYS
Answer – [B]
Q55. Which function is used to returns an aggregate in a list or database?
a) AVERAGE
b) AGGREGATE
c) MEAN
d) MODE
Answer – [B]
Q56. Which function is used to converts all letters in a text string to lowercase?
a) TEXT
b) UPPER
c) PROPER
d) LOWER
Answer – [D]
Q57. Which function is used to converts all letters in a text string to uppercase?
a) TEXT
b) UPPER
c) PROPER
d) LOWER
Answer – [B]
Q58. Which function is used to capitalizes each word in a given text string?
a) TEXT
b) UPPER
c) PROPER
d) LOWER
Answer – [C]
Q59. Which function is used to counts the number of blank cells in the given range?
a) COUNTBLANK
b) COUNT
c) COUNTA
d) COUNTIF
Answer – [A]
Q60. Which function is used to finds the maximum value in the data set, ignore logical value and text?
a) MIN
b) MAX
c) MINA
d) MAXA
Answer – [B]