81. Which function is used to generates a random decimal number between the given number?
a) ROUND
b) RANDBETWEEN
c) RAND
d) RANDOM
Answer – [B]
82. Which function is used to count the number of days between the two dates?
a) DAYS
b) DAY
c) DATE
d) COUNT
Answer – [A]
83. Which function is used to get the day of the week as a number?
a) DAYS
b) DATE
c) WEEKDAY
d) COUNT
Answer – [C]
84. Which function is used to checks whether two strings are exactly the same, and returns TRUR or FALSE?
a) FIND
b) SEARCH
c) EXACT
d) SAME
Answer – [C]
85. Which function is used to returns the number of characters in a text string?
a) LENGTH
b) SEARCH
c) EXACT
d) LEN
Answer – [D]
86. Which function is used to replace text based on location?
a) REPLACE
b) SEARCH
c) REPEAT
d) FIND
Answer – [A]
87. Which function is used to returns the characters from the middle of a text string, given a starting position and length?
a) MIDDLE
b) MID
c) TEXT
d) LENGTH
Answer – [B]
88. Which function is used to replace text based on content?
a) LEN
b) SUBSTITUTE
c) TEXT
d) REPLACE
Answer – [B]
89. Which function is used to returns TRUE if a cell contains a formula, and FALSE if not?
a) ISNONTEXT
b) ISNONFORMULA
c) ISFORMULA
d) ISTEXT
Answer – [C]
90. Which function is used to returns TRUE if a cell contains any value except text?
a) ISNONTEXT
b) ISERROR
c) ISNUMBER
d) ISTEXT
Answer – [A]