Chapter 6 Spreadsheets

View

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.

row

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

=

In spreadsheets, all functions and calculations begin with

future value (FV)

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.

interest

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

Plus sign with arrows either diagonal or vertical

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

red

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

right-click

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.

= (10 - 8) / 8 * 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?

Spreadsheet

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

Period

Each loan payment is referred to as a(n)

black

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

Data

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

spreadsheets

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

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

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

PMT

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

IF

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.

COUNT

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

Color makes data easier to read

What is the purpose of using color in spreadsheets?

this is not an error. The cell needs to be expanded in order to display the entire value

You see ###### in a cell. This means that