Spreadsheets

What function would you use to display how many entries are made in Column A above Cell A37?

COUNT

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

black

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

interest.

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

red

A common method to delete a column or row in most spreadsheet programs is to ________ on the column or row heading, and then select Delete from the menu.

right-click

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

row.

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

-Rate -Term -Present Value (PV) -Period

- Annual percentage rate (APR) of interest - Length of loan in years - Amount of money (principal) originally borrowed or owed - Single payment

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

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

AutoSUM

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)

If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ________ options.

Freeze

A function that looks for a value in the leftmost column of a table, and then returns a value located in the same row as the first value, is called a

VLookup.

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

absolute

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

cross but with arrows

Which pointer allows a user to adjust the width of a column or the height of a row in a spreadsheet?

cross but with arrows

Each loan payment is referred to as a(n)

period

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

plus sing, looking...

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

present value (PV).

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

principal

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

spreadsheets

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

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: 3, 2, 6, and 8.

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

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.

IF

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

Insert

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

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

spreadsheets.

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