Questions from Microsoft Excel and Access for Accounting

Q: What is the purpose of a depreciation summary?

What is the purpose of a depreciation summary?

Q: What other depreciation functions are built into Excel?

What other depreciation functions are built into Excel?

Q: What additional argument is added for these depreciation functions?

What additional argument is added for these depreciation functions?

Q: How do you add a new series of data to an existing

How do you add a new series of data to an existing chart?

Q: Explain the difference between a loan and a bond.

Explain the difference between a loan and a bond.

Q: Describe the Scenario Manager.

Describe the Scenario Manager.

Q: What function is used to calculate a loan payment?

What function is used to calculate a loan payment?

Q: What arguments does the loan payment function take?

What arguments does the loan payment function take?

Q: Why does the payment function result in a negative number?

Why does the payment function result in a negative number?

Q: What does a loan amortization schedule do?

What does a loan amortization schedule do?