BCOR 330: chapter 5 quiz

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

If you type =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

27

In spreadsheets, all functions and calculations begin with

=

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 75.

= (25 + 50 + 75) / 3

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

Freeze

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

Right-click the cell and then cut and paste the data into the desired cell. Drag the data to the desired cell when the cursor changes to a drag hand. Right-click the cell and then cut and paste the data into the desired cell.

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

Select the first cell in the range then hold down the shift key and select the last cell in the range. Select the first cell in the range and drag down to the last cell.

What are the two most common spreadsheet charts?

bar graphs line graphs

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

cell

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

heavy border highlighted column and row headings name box (in the upper left corner of the sheet)

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

Bankers and other lenders refer to the initial amount of the loan (the principal) as the loan's

present value

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

present value principal balance

he amount of money borrowed in a loan is often referred to as the loan's balance or the ________ of the loan.

principal

To Insert a Column to the left of Column D in an OpenOffic Calc file, select Column D and then ________ and select Insert

right-click

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

row

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