Which of the following statements is True regarding excel ?

a. Excels "PV" function can be used to find the price of a bond.

b. STDEV.P is the correct excel function to find the variance of a sample.

c. When using the rate function to slove for a bond YTM. if semiannual input value are used, the result must be divided by 2 in order to find the annual YTM.

d. For a 20 year, 6% annual coupon bond with a par value of $100, you would enter $60 as the "NPER" input in the "PV" function.