91. Which function is used to returns TRUE if a cell contains a number, and FALSE if not?
a) ISNONTEXT
b) ISERROR
c) ISNUMBER
d) ISTEXT
Answer – [C]
92. Which function is used to returns TRUE if a cell contains a text value, and FALSE if not?
a) ISNONTEXT
b) ISERROR
c) ISNUMBER
d) ISTEXT
Answer – [D]
93. Which function is used to returns a subtotal in a list or database?
a) SUBTOTAL
b) TOTAL
c) SUM
d) AVG
Answer – [A]
94. Which function is used to returns the greatest common divisor of two or more integer?
a) GCD
b) LCM
c) MOD
d) INTEGER
Answer – [A]
95. Which function is used to returns the least common divisor of two or more integer?
a) GCD
b) LCM
c) MOD
d) INTEGER
Answer – [B]
96. Which function is used to returns the remainder of two numbers after division?
a) GCD
b) LCM
c) MOD
d) INTEGER
Answer – [C]
97. Which function is used to returns a number raised to a given power?
a) POWER
b) SQRT
c) CUBE
d) ROUND
Answer – [A]
98. Which function is used to returns the integer portion of division without the remainder?
a) POWER
b) DIVISION
c) INTEGER
d) QUOTIENT
Answer – [D]
99. Which function is used to converts a number to a roman numeral as text?
a) CONVERT
b) ROMAN
c) TEXT
d) NUMBER
Answer – [B]
100. Which function is used to returns the date before or after a specified number of workdays
a) DAYS
b) WEEKDAY
c) WORKDAY
d) WEEKNUM
Answer – [C]
More Topics
- C program to convert Kilogram to Gram
- C program to convert Meters to Kilometers
- C program to convert Miles to Kilometers
- C program to convert Feet to Meters
- C Programming Viva Question Answer
- C Number Pattern Program
- C Star Pattern Program
- C Alphabets Pattern Program
- Computer Networking Interview Question Answer