Functions
To add up a range of cells the user would use this function
What is =Sum
This bar shows everything the user puts into an individual cell
What is the Formula Bar
The amount the bank makes off of a loan
What is interest
Which tab on the ribbon contains Number formatting
What is the Home tab
We were good, we were gold
Kinda dream that can't be sold
We were right 'til we weren't
Built a home and watched it burn
What is Flowers
To find the highest number in a range. The user would use this function
What is =Max
This "Box" show the name of each cell or range cells when they are selected
What is the Name Box
The amount the borrower still has left to pay on the loan
What is Principal
This tab on the ribbon would be used to Define names based on selection
What is the Formulas Tab
Told you I'll be here forever
Said I'll always be your friend
Took an oath, I'ma stick it out 'til the end
What is Umbrella
The 1st argument in the IF function is
What is the Logical Test
Excel feature that looks for patterns in the data and automatically fills or formats data in remaining cells
What is a Flash Fill
The amount of cash a borrower would put down to secure a loan
What is the down payment
This tab on the ribbon would be used to protect a worksheet
What is the Review Tab
What is You got it Bad - usher
Function that has no arguments and returns the current date in the cell
What is the NOW Function
A Cell Reference that remains constant when copying a formula or function
What is an Absolute Reference
The percentage that the bank charges to borrow money
What is the interest rate
This tab would be used to add a new rule for Conditional Formatting
What is the home Tab
Add a whole top diamonds and the bottom rose gold
What is Grillz
In the PMT Function, the PV argument stands for what
What is Present Value
Schedule that shows the beginning and ending balances of a loan and the amount of payment that is applied to the principal and interest during each payment period
What is Amortization Schedule
What is the formula or mathematical equation to find the total price of a house that you are getting a loan for
What is = Loan Amount + Down Payment + Total interest
This tab is used to create What-If Analysis
What is the Data Tab
What is Set Fire to the Rain - Adele