Question

In: Finance

which of the following statements is TRUE about excel? A. We can lock in cells by...

which of the following statements is TRUE about excel?

A. We can lock in cells by placing an exclamation point in front of the cells column and row

B.The first symbol to enter when entering a formula is the division sign

C. Bond prices are to be entered with a negative sign while par values are to be entered with a positive sign

D.The "PMT" function can be used to find the price of a bond

Solutions

Expert Solution

TRUE statements about excel is bond prices are to be entered with a negative sign while par values are to be entered with a positive sign

Therefore correct answer is option: Bond prices are to be entered with a negative sign while par values are to be entered with a positive sign

Generally the cash inflow is entered with positive sign and cash outflow entered with negative sign as bond prices is considered as cash out flow therefore it is to be entered with a negative sign while par values are the maturity amount received as cash inflow therefore to be entered with a positive sign.

Other statements are not true about excel -

· We can lock in cells by placing an $ sign in front of the cells column and row not exclamation point

· The first symbol to enter when entering a formula is the equal to (=) sign not division sign

· The "PV" function can be used to find the price of a bond and “PMT” function can be used to find the coupon payment amount of a bond


Related Solutions

which of the following statements is TRUE about excel? A. We can lock in cells by...
which of the following statements is TRUE about excel? A. We can lock in cells by placing an exclamation point in front of the cells column and row B.The first symbol to enter when entering a formula is the division sign C. Bond prices are to be entered with a negative sign while par values are to be entered with a positive sign D.The "PMT" function can be used to find the price of a bond
question 18. Which of the following statements is not true? A. Cells from malignant tumors can...
question 18. Which of the following statements is not true? A. Cells from malignant tumors can invade and damage nearby tissues and organs B. Solid malignant tumors often release growth factors to promote blood vessel growth C. Secondary or metastasized tumors often can be removed and usually do not grow back. D. Cells from benign tumors invade the tissues around them or spread to other parts of the body E. Generally benign tumors can be removed and usually do not...
1. Which of the following statements is NOT true about cell size? Larger cells require more...
1. Which of the following statements is NOT true about cell size? Larger cells require more materials to survive. Material needs are tied to Volume. Maximum cell size is limited by the surface area to volume ratio When cell volume is doubled, the surface area is also doubled. As a cell increases in size, the volume increases faster than its surface area The amount of surface area of a cell determines how much material can be absorbed through the membrane...
Which of the following statements is TRUE? A. We can sometimes know the exact location and...
Which of the following statements is TRUE? A. We can sometimes know the exact location and speed of an electron at the same time. B. All orbitals in a given atom are roughly the same size. C. Since electrons have mass, we must always consider them to have particle properties and never wavelike properties. D. Atoms are roughly spherical because when all of the four different shaped orbitals are overlapped, they take on a spherical shape. E. All of the...
Which of the following statements is true?    Select one: a. We can only find the...
Which of the following statements is true?    Select one: a. We can only find the opening balance of Capital on the 10-column worksheet when there is no owner’s drawings. b. We can always find the opening balance of Capital on the 10-column worksheet. c. We can never find the opening balance of Capital on the 10-column worksheet. d. We can only find the opening balance of Capital on the 10-column worksheet when there is no owner’s contribution.
Which of the following statements about RFID is/are not true? (MULTIPLE ANSWERS) A. Can be used...
Which of the following statements about RFID is/are not true? (MULTIPLE ANSWERS) A. Can be used in inventory management B. Tolltag is an RFID transmitter C. Sending device requires power to be applied in order to transmit. D. Requires a reader device which receives radio signals produced by a sending device E. Used to identify and display radio station and media playing on radio.
Which of the following statements about correlation are true?
4. Correlation basics Which of the following statements about correlation are true? Check all that apply Correlation is a numerical value between 1.1 and 2. The sign of the correlation indicates the strength or consistency of the linear relationship between two variables. A negative correlation means that two variables tend to change in opposite directions The correlation indicates the strength and the direction of the linear relationship between two variables If the correlation between two variables is 0, there is no clear linear relationship between the...
Which of the following statements about genetics is TRUE?
Which of the following statements about genetics is TRUE?  a. A mutation is any change in DNA that is harmful to an organism. b. Genetic disorders are always caused by the inheritance of recessive alleles. c. The red queen hypothesis proposes that asexual reproduction evolved in organisms to increase genetic variation, and therefore, improve resilience in ever-changing environments. d. Natural selection acts directly on the phenotype and indirectly on the genotype.
Which of the following statements are true and which are false? (a) Assume that we are...
Which of the following statements are true and which are false? (a) Assume that we are implementing AES or a similar system on an RFID tag. When calculating the ASIC cost, one of the things we need to take into account is the key. (b) Assume that we are implementing AES or a similar system on an RFID tag. When calculating the ASIC cost, one of the things we need to take into account is the internal state. (c) Assume...
Which of the following statements are true and which arefalse?(a) Assume that we are...
Which of the following statements are true and which are false?(a) Assume that we are implementing AES or a similar system on an RFID tag. When calculating the ASIC cost, one of the things we need to take into account is the key.(b) Assume that we are implementing AES or a similar system on an RFID tag. When calculating the ASIC cost, one of the things we need to take into account is the internal state. (c) Assume that we...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT