Interface
A collection of rows and columns that can be used in calculations.
What is a spreadsheet?
The default cell reference for excel.
What is a Relative Cell Reference?
The amount borrowed.
What is the Principal?
This cell reference has one dollar sign.
What is a Mixed Cell Reference?
All functions and formulas begin with this character.
What is the equal sign?
The cost of a loan expressed as a percentage.
What is the Interest Rate?
Need your chart to include non-adjacent columns, just hold down this button.
What is ctrl?
This key (on the keyboard) toggles between the different cell references.
What is F4?
This function is used to find the lowest number in a range of numbers.
What is MIN?
The amount you can initially give before using loan money.
What is a Down Payment?
This feature allows excel to change the format of a range based on a specific criteria.
What is conditional formatting?
The ________ is constant in this cell reference $G7.
What is the Column?
A mathematical expression
What is a formula?
A measure of one's ability to repay a loan.
What is a Credit Score?
This feature is a function that gives the current date and time?
What is the NOW function?
The formula $A10 * B$10 will say this if it is copied into the next column
What is $A10 * C$10?
This function sets a value based on a condition.
What is the IF function?
This function is good for calculating the monthly payment of a loan.
What is the PMT function?