Ch.4 Quiz Spreadsheets

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

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

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

Hide

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.

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

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

spreadsheets

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