Spreadsheets Quiz

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: 4, 2, 5, and 5.

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

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

Insert

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

absolute

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

cell.

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

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

red

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

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