|
Money Management
|
Checking Your Skills
|
|
|
|
Choose the word or words that best finish the sentence.
There are more words than there are sentences.
The same word can be used for more than one answer.
There may be more than one correct answer.
|
|
|
|
standard
|
series
|
Center Across Columns
|
FV
|
|
rename
|
Insert
|
Paste Function
|
PMT
|
|
Decrease Decimal
|
column heading separator
|
minus sign
|
|
|
absolute reference
|
Average
|
Backspace
|
|
|
|
|
1) Excel enters a list of numbers or headings in order. This is called a ______________.
2) The function that calculates the future value of money over time is ____________________.
3) The button on the standard toolbar that brings up the list of financial functions is named the ____________________________________________.
4) When you want a function to always go the same cell for a value, you make that number an ____________________________________________ by adding dollar signs.
5) If you want to give or change the name of a worksheet, you click on the worksheet tab and _______________________________ it.
6) If you want a heading to be centered over columns, you click on the ________________________________________________ button in the formatting toolbar.
7) When you see ####### in a cell that means the value in the cell is too long. You can shorten the number by clicking on the __________________________________ button.
8) When you pay money out, you show the amount with a ______________________________ in front.
|
|
|
|
Money Management
|
|
|
|
Instructions:
|
|
Circle T if the statement is true and F if the statement is false.
|
|
1. The FV function returns the future value of an investment.
|
T
|
F
|
|
2. When you see ##### in a cell that means that your answer is wrong.
|
T
|
F
|
|
3. Press the Ctrl key and the comma to view formulas.
|
T
|
F
|
|
4. Absolute references are shown by placing a $ before the column or row.
|
T
|
F
|
|
5. The PMT function is used to calculate the yearly payment for a loan.
|
T
|
F
|
|
6. The PPMT function calculates the principal paid each period.
|
T
|
F
|
|
|
|
