Show:
PRT's
What do I stand for
What if?
It's all relative
Money
100
P * R * T
What is the formula to calculate interest
100
P
What is Principal
100
If statement begins with this
What is = sign
100
Use this to copy a formula to adjacent cells
What is fill handle
100
The fee that banks charge when you borrow money.
What is interest
200
APR
What is Annual Percentage Rate
200
R
What is interest rate
200
IF statement is based on this
What is a conditional test
200
This character keeps a cell reference from changing with a formula is copied to another location
What is $ sign
200
This is what your money earns in a jar in your backyard.
What is ZERO
300
NPER
What is the expression for time
300
T
What is time
300
Logical tests are answered in this fashion.
What is True or False (Yes or No)
300
This cell reference type: $B$5
What is absolute cell reference
300
You can divide the amount you repay a loan over a time into these.
What are payments
400
PV
What is Present Value
400
PMT
What is payment
400
What separates each part of the IF statement
What is a comma
400
This kind of cell reference: A$5
What is mixed cell reference
400
How much interest would be the result of this: $100 at 5% for 1 year.
What is $5.00 (100 x .05 x 1)
500
Divide by 12
What is the process to make the interest rate match the monthly term
500
FV
What is future value
500
Formulas can be enclosed in these to indicate priority
What are parenthesis
500
What do you type to lock the cell C2 in the formula no matter where it is copied.
What is $C$2
500
How much would you repay if you borrowed $100 at 6% for 1 year?
What is $106.00 (100 x .06)=6 + 100 = 106