Chapter 4— Spreadsheets

To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) _____________ reference.

Absolute

You made a simple spreadsheet for an online class assignment for a group project and want all group members to be able to open it regardless of what spreadsheet program they use. Which format would be the best to use?

CSV

In the spreadsheet above the word Uber is found in B6. B6 is called a ___________ reference.

Cell

What does CSV stand for?

Comma separated values

When you invest money the ___________ value of the your investment is how much you will have after a certain amount of time.

Future

The rule of 72 states that dividing 72 by the interest rate approximates the time for the investment to double. This calculates the ___________ of the investment

Future Value (FV)

When money is borrowed, the __________ value of the loan (the principal) is the initial amount of money borrowed.

Present

The amount of money borrowed in a loan, sometimes referred to as the PV or the loan balance is the loan's:

principal