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
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 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 spreadsheets, all functions and calculations begin with
=
What are the two most common spreadsheet charts?
bar graphs line graphs
In a spreadsheet, a horizontal line of cells is called a
row
Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 25, 50, and 75.
= (25 + 50 + 75) / 3
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.
The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n)
cell
To retain a row or column, but remove it from view, right-click on the row or column heading and select
hide
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
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
Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ________ tab to create a pivot table.
insert
he amount of money borrowed in a loan is often referred to as the loan's balance or the ________ of the loan.
principal
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.
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)
