Spreadsheets

In an Excel file, if a label (such as the word "panda") is used in a formula, what will appear in the cell when the Enter key is pressed?

#VALUE!

The stylist just did a great job and your hair is going to look good for weeks. The stylist charged $70 and you decide to add a 15% cash tip. How big is the tip?

$10.50

If you type =8 / 2 * 4 + 1 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

17

The number 27 in the cell depicted above is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right?

27

To determine how much a recurring monthly payment would be for a car loan or a mortgage, use the ________ function.

PMT

In Google Sheets, what are two methods that allow a user to move data from one cell to another cell?

drag the data to the desired cell when the cursor changes to a drag hand right click the cell then cut and paste the data into the desired cell

When you enter a calculation into a spreadsheet, you start by entering a(n) ________ sign.

equal

The CSV format saves the cell values and formulas.

false; CSV saves only the cell values

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)

The total amount of money (principal + interest) that lender receives from a borrower at the end of the loan is referred to as the loan's

future value(FV)

Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ________ tab to create a pivot table.

insert

select the two spreadsheet programs

openoffice calc and apple numbers

A traditional 30-year mortgage has 12 monthly payments per year. This means the loan has a total of 360 ________.

payments

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 is often referred to as the loan's balance or the _______________ of the loan

principal

When displaying financial information, the accepted practice is that ________ indicates negative values.

red

Because they make it easy to arrange, display, and calculate numerical data, ________ programs are commonly used in nearly every business setting.

spreadsheets

Because they make it easy to arrange, display, and calculate numerical data, ________ programs are often used in budgeting, accounting, finance, grading, gambling houses, and even sports analysis.

spreadsheets

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called

spreadsheets

Sports analysts often use ________ to keep track of statistics, times, and scores of nearly every sporting event.

spreadsheets

Which two of the following refer to the amount of money a lender charges for borrowing money (excluding any origination fees)?

the APR (annual percentage rate) and interest rate

You see ###### in a cell. This means that

this is not an error. the cell needs to be expanded in order to display the entire value

What is the purpose of saving an Excel file as a .cvs (comma-separated format) file?

to share data with other spreadsheet users regardless of which spreadsheet program is being used

Comma-separated format (.cvs) files are commonly used by those who are sending data but do not know what spreadsheet the recipient uses.

true