nerdexam
Microsoft

77-427 · Question #47

You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial calculations. You…

The correct answer is C. PRICEMAT function. See the full explanation below for the reasoning.

Question

You work as a Finance Manager for Blue Well Inc. The company has a Windows-based network. You are using Excel spreadsheet for maintaining the financial budget and other financial calculations. You want to return the price per $100 face value of a security that pays interest at maturity. Which of the following financial functions will you use to accomplish the task?

Options

  • APRICE function
  • BPPMT function
  • CPRICEMAT function
  • DPRICEDISC function

How the community answered

(65 responses)
  • A
    2% (1)
  • B
    9% (6)
  • C
    83% (54)
  • D
    6% (4)

Community Discussion

No community discussion yet for this question.

Full 77-427 Practice