Spreadsheet for Business

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 =2 + 3 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

20

Every time you go to the gas station you're amazed by how much prices have increased. At this time last year the price was $3.20 per gallon and now the price is $4.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?

= ((4.25 - 3.20) / 3.20) * 100

A friend asks if you want to go see the new Avengers movie but you say it's too expensive. "No it's not, tickets have only gone up $2.00 since last year," says your friend. You reply, "tickets went from $8 to $10 for a matinee. That is a large percentage increase. What formula would provide the percentage increase?

= (10 - 8) / 8 * 100

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

PMT

Match the part of the loan with its definition.

Rate- annual percentage rate (APR) of interest Period- single payment Term- length of loan in years Present Value (PV)- amount of money originally borrowed or owed

Select two methods of selecting a range of adjoining cells in Excel.

Select the first cell in the range and drag down to the last cell, Select the first cell in the range then hold down the shift key and select the last cell in the range

Use the AutoSUM function if you want to quickly ________ a series of values in a spreadsheet.

add

What are the two most common spreadsheet charts?

bar graphs, line graphs

What is the purpose of using color in spreadsheets?

color makes data easier to read

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 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, name box

To retain a row or column, but remove it from view, right-click on the row or column heading and select

hide

When adjusting the width of a column or the height of a row, which pointer(s) is/are used?

horizontal arrows or vertical arrows

Advertised as an annual percentage rate (APR), the amount of money a lender charges for a loan is the loan's ________.

interest

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

interest

Which pointer, called the fill handle, allows a user to copy a cell's data to an adjoining cell or cells?

little + or big +

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), principle, balance

The amount of money borrowed in a loan is often referred to as the loan's balance or the ________ of the loan.

principle

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

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

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, remain on the left side of a cell when entered