Show:
Interface
Features
Cell References
Functions
Finance
100
This tab allows you to add a chart.
What is the insert tab?
100

A collection of rows and columns that can be used in calculations.

What is a spreadsheet?

100

The default cell reference for excel.

What is a Relative Cell Reference?

100
This function will find the total of a range of cells.
What is the Sum function?
100

The amount borrowed.

What is the Principal?

200
Columns in excel are identified by these.
What are letters?
200
The quickest way to copy a formula to adjacent cells is to use this tool.
What is the fill handle?
200

This cell reference has one dollar sign.

What is a Mixed Cell Reference?

200

All functions and formulas begin with this character.

What is the equal sign?

200

The cost of a loan expressed as a percentage.

What is the Interest Rate?

300
The first cell in Excel.
What is A1?
300

Need your chart to include non-adjacent columns, just hold down this button.

What is ctrl?

300

This key (on the keyboard) toggles between the different cell references.

What is F4?

300

This function is used to find the lowest number in a range of numbers.

What is MIN?

300

The amount you can initially give before using loan money.

What is a Down Payment?

400
This color plus sign is used for selection.
What is white?
400

This feature allows excel to change the format of a range based on a specific criteria.

What is conditional formatting?

400

The ________ is constant in this cell reference $G7.

What is the Column?

400

A mathematical expression

What is a formula?

400

A measure of one's ability to repay a loan.

What is a Credit Score?

500
This button will first combine cells and then center the text within them?
What is merge and center?
500

This feature is a function that gives the current date and time?

What is the NOW function?

500

The formula $A10 * B$10 will say this if it is copied into the next column

What is $A10 * C$10?

500

This function sets a value based on a condition.

What is the IF function?

500

This function is good for calculating the monthly payment of a loan.

What is the PMT function?