To make a calculation always refer to a specific cell when copying it using the fill
handle, make the cell a(n) ________ reference. - answer absolute
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. -
answer right-click
The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's -
answer interest.
What function would you use to display how many entries are made in Column A above
Cell A37? - answer COUNT
Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and
OpenOffice Calc, that allow users to arrange numerical data are called - answer
spreadsheets.
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? - answer
$10.50
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? - answer
27
Select the spreadsheet formula that would correctly calculate the average (mean) of the
following values: 3, 2, 6, and 8. - answer = (3 + 2 + 6 + 8) / 4
Pivot tables provide a quick way to organize information. In most spreadsheet
programs, click the ________ tab to create a pivot table. - answer Insert
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. - answer IF
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? - answer = (10 - 8) /
8 * 100