Spreadsheets week 5 computers

In an Excel file, if a label (such as the word "panda") is used in a formula, what will appear in the cell when the Enter key is pressed?

#VALUE!

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

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

Select the two spreadsheet programs.

1.Apple Keynotes 2.OpenOffice Writer 3.Google Sheets

Select two methods of selecting a range of adjoining cells in Excel.

1.Double-click on the first cell in the range and enter the last cell in the range. 2.Right-click on the first cell in the range and enter the last cell in the range.

In Google Sheets, what are two methods that allow a user to move data from one cell to another cell?

1.Double-click the cell and then drag the data to the desired cell. 2.Click on the cell then choose the move data option from the Data menu.

Which three of the following refer to the amount of money owed on a loan when it is first borrowed (excluding any origination fees).

1.Interest (APR) 2.Balance

Select three true statements regarding labels.

1.interact with other cells—can be used in calculations 2.remain on the left side of a cell when entered

The active cell in a spreadsheet is the cell into which the user can input data. In most spreadsheet programs the active cell can be identified by which three items?

1.red lettering 2.name box (in the upper left corner of the sheet)

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

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

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: 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

If you want to find the mean of the values in cells above A37 in the above spreadsheet, what function would you place in A37?

Average

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

COUNT

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

Freeze

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

Hide.

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

Insert

Single payment

Period

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

Placing your pointer between two column or row headings allows you to adjust the width or height.

Amount of money (principal) originally borrowed or owed

Present Value (PV)

Annual percentage rate (APR) of interest

Rate

Length of loan in years

Term

When you enter a calculation into a spreadsheet, you start by entering a(n) ________ sign.

The equal sign (=) is the most important symbol in a spreadsheet. It indicates that the cell contains a formula or a function.

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

The fill handle is located in the lower right corner of the cell in most spreadsheet programs.

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

The initial value of a loan is called the principal of the loan. A loan payment typically consists of two parts, principal and interest.

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.

View

When money is borrowed, the ________ value of the loan (the principal) is the initial amount of money borrowed.

When money is borrowed, the PV of the loan is the initial amount of money borrowed.

Advertised as an annual percentage rate (APR), the amount of money a lender charges for a loan is the loan's ________.

Your credit rating often influences the interest rate the lender will charge on a loan.

A traditional 30-year mortgage has 12 monthly payments per year. This means the loan has a total of 360 ________.

a loan payment is called a period. Most loans, such as student or car loans, have monthly payments. This means the loan has 12 periods per year.

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

absolute

In spreadsheets, all functions and calculations begin with

an equal sign (=).

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

black

Saving a spreadsheet file in .cvs format only saves the

cell values.

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

cell.

Computer programs that allow users to easily arrange, calculate, and present numerical data are called ________.

examples of spreadsheets include Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, OpenOffice Calc, Lotus Symphony, and many others.

In financial institutions, the color red represents positive values.

false

The CSV format saves the cell values and formulas.

false

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.

future value (FV)

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

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

interest.

Each loan payment is referred to as a(n)

period.

What are the two most common spreadsheet charts?

pie charts

Which two of the following refer to the amount of money a lender charges for borrowing money (excluding any origination fees)?

principal

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.

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

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 see ###### in a cell. This means that

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

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

Comma-separated format (.cvs) files are commonly used by those who are sending data but do not know what spreadsheet the recipient uses.

true

Select two common uses of spreadsheets.

word processing