Microsoft Excel Questions... 9 pages of questions.

Name ____________________________ Date ___________________

Excel 2010: Chapter 4 – Short Answer

Instructions: Fill in the best answer.

1. _______________ portions of a worksheet lets you show only parts of the workbook that the user needs to see.

2. _______________ ensures that users do not change values inadvertently that are critical to the worksheet.

3. A cell _______________ often is created from column and row titles.

4. A(n) _______________ function returns the future value of an investment based on periodic, constant payments, and a constant interest rate.

5. A(n) _______________ function calculates the payment for a loan based on the loan amount, constant payments, and a constant interest rate.

6. With a(n) _______________ data table, you can vary the value in one cell in a worksheet.

7. _______________ have one purpose: to organize the answers to what-if questions.

8. A(n) _______________ shows the beginning and ending balances of a loan and the amount of payment that applies to the principal and interest for each year over the life of the loan.

9. A(n) _______________ is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.

10. _______________ are cells that you cannot change.