Home / Programming MCQs / Microsoft Excel MCQs / Question
R
Q. Which function calculates your monthly mortage payment ?
The correct answer is (1) PMT (payments). The PMT function is commonly used to calculate the monthly mortgage payment. It takes into account the interest rate, the number of periods, and the present value of the mortgage to calculate the fixed monthly payment amount. The NPER function is used to calculate the number of periods required to pay off a loan, and the PV function is used to calculate the present value or loan amount. However, in the context of calculating the monthly mortgage payment, the PMT function is the most appropriate choice.
You must be Logged in to update hint/solution
Which of the following is a popular DOS based spreadsheet package?
When you link data maintained in an excel workbook to a word document ?
Mixed cell reference in Excel is denoted by the Address parts as
Which of the following is not a valid chart type in Excel.
Which command will you choose to convert a column of data into row?
In Excel data marker on a chart are linked to data points in a worksheet, therefore,
The Paste Special command lets you copy and paste:
In Excel accounting style shows negative numbers in
In EXCEL, you can add up a wide range of data by simply selecting a button called ________?
Discusssion
Login to discuss.