Q71. Which function is used to rounds a number down to a given number of digits?
a) ROUND
b) ROUNDDOWN
c) ROUNDUP
d) RAND
Answer – [B]
72. Which function is used to rounds a number up to a given number of digits?
a) ROUND
b) ROUNDDOWN
c) ROUNDUP
d) RAND
Answer – [C]
73. Which function is used to returns the interest rate per period of a loan or an investment?
a) INTEREST
b) RATE
c) PMT
d) IPMT
Answer – [B]
74. Which function is used to returns the present value of an investment?
a) INTEREST
b) FV
c) PV
d) RATE
Answer – [C]
75. Which function is used to calculates the payment for a loan based on constant payments and a constant interest rate?
a) INTEREST
b) PMT
c) IPMT
d) RATE
Answer – [B]
76. Which function is used to returns the net present value of an investment?
a) NPV
b) PV
c) IPMT
d) NPER
Answer – [A]
77. Which function is used to returns the number of periods for an investment?
a) NPV
b) PMT
c) IPMT
d) NPER
Answer – [D]
78. Which function is used to returns the factorial of a given number?
a) FACT
b) FACTORIAL
c) MODE
d) MEAN
Answer – [A]
79. Which function is used to returns the double factorial of a given number?
a) FACT
b) FACTORIAL
c) FACTDOUBLE
d) DOUBLEFACTORIAL
Answer – [C]
80. Which function is used to truncates a number to an integer by removing the decimal, or fractional part of the number?
a) INTEGER
b) DECIMAL
c) TRUNCATES
d) TRUNC
Answer – [D]