Spreadsheets IS

You just had a great lunch at a nice restaurant and decide to leave a 15% tip on your $18 meal. What will be the total charge on your debit card?

$20.70

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

17

If you type =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

27

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 4, 2, 5, and 5.

= (4 + 2 + 5 + 5) / 4

What does the above symbol (upper-case Sigma) represent in spreadsheets?

AutoSUM

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. Click on the cell then choose the move data option from the Data menu.

The CSV format saves the cell values and formulas. Group starts

False

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

PMT

A traditional 30-year mortgage has 12 monthly payments per year. this mean the loan has a total of 360 _______________

Payments

Single payment

Period

Amount of money (principal) originally borrowed or owed

Present Value (PV)

Which three of the following refer to the amount of money owed on a loan when it is first borrowed (excluding any origination fees).

Present Value (PV) Balance PrincipalPrincipal

Length of loan in years

Term

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

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

absolute

In the financial world, which color represents credits or profits?

black

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

equal

The active cell in a spreadsheet is the cell into which the user can input data. In most spreadsheet programs the active cell can be identified by which three items?

heavy border highlighted column and row headings

The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's

interest

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

present

Bankers and other lenders refer to the initial amount of the loan (the principal) as the loan's

present value (PV).

Annual percentage rate (APR) of interest

rate

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.

spreadsheet

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.

spreadsheet

Select three true statements regarding labels.

usually a text or text+number combination can be created by typing an apostrophe in front of a number