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

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

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

27

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? https://o.quizlet.com/ryJLSRB97SAQQQaMyX-EEA.png

27

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

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 75.

= (25 + 50 + 75) / 3

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

= (3 + 2 + 6 + 8) / 4

Present Value (PV)

Amount of money (principal) originally borrowed or owed

Rate

Annual percentage rate (APR) of interest

What function would you use to display how many entries are made in Column A above Cell A37? https://o.quizlet.com/yvFHaOkSRpAXAFiPh4XQGA.png

COUNT

What is the purpose of using color in spreadsheets?

Color makes data easier to read.

To select nonadjoining cells in a spreadsheet, hold down the ________ key while selecting cells.

Control (Ctrl)

In financial institutions, the color red represents positive values.

False

The CSV format saves the cell values and formulas.

False

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

Hide.

To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the ________ function. https://o.quizlet.com/6VO825TDDGgxBRomtIJwpw.png

IF

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

Insert

Term

Length of loan in years

Select the two spreadsheet programs.

Microsoft Excel Google Sheets

Select the two spreadsheet programs. (2nd)

OpenOffice Calc Apple Numbers

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

PMT

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

Present

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) Principal Balance

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.

Period

Single payment

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

True

In Apple iWork's Numbers the freeze options are located under the Table tab. In Microsoft Excel and Google sheets the freeze cells or panes options are found in the ________ menu.

View

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

absolute

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

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

black

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

black cross

The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n)

cell

Saving a spreadsheet file in .csv format only saves the

cell values.

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

cross with arrows

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

equal

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)

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.

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

periods

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

present value (PV)

To Insert a Column to the left of Column D in an OpenOffic Calc file, select Column D and then ________ and select Insert.

right-click

In a spreadsheet, a horizontal line of cells is called a

row

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

spreadsheet

Computer programs that allow users to easily arrange, calculate, and present numerical data are called ________.

spreadsheets

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

spreadsheets

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

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

principal

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

principal

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

red

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

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) the 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