Q61. Which function is used to finds the maximum value in the data set, but does not ignore logical value and text?
a) MIN
b) MAX
c) MINA
d) MAXA
Answer – [D]
Q62. Which function is used to finds the minimum value in the data set, ignore logical value and text?
a) MIN
b) MAX
c) MINA
d) MAXA
Answer – [A]
Q63. Which function is used to finds the minimum value in the data set, but does not ignore logical value and text?
a) MIN
b) MAX
c) MINA
d) MAXA
Answer – [C]
Q64. Which function is used to converts a roman number to Arabic?
a) ARABIC
b) ROMAN
c) CONVERT
d) NUMBER
Answer – [A]
Q65. Which function is used to converts a number in a given base into its decimal number equivalent?
a) BASE
b) DECIMAL
c) CONVERT
d) NUMBER
Answer – [B]
Q66. Which function is used to rounds a positive number up to the nearest even integer?
a) POSITIVE
b) NUMBER
c) EVEN
d) ODD
Answer – [C]
Q67. Which function is used to rounds a positive number up to the nearest odd integer?
a) POSITIVE
b) NUMBER
c) EVEN
d) ODD
Answer – [D]
Q68. Which function is used to generates a random decimal number between 0 and 1?
a) DECIMAL
b) NUMBER
c) ROUND
d) RAND
Answer – [D]
Q69. Which function is used to adds all the number in a range of cells?
a) ADD
b) SUM
c) TOTAL
d) AVG
Answer – [B]
Q70. Which function is used to rounds a number to a specified number of digits?
a) ROUND
b) ROUNDDOWN
c) ROUNDUP
d) RAND
Answer – [A]