Spreadsheets

Term

length of loan in years

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

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

Every time you go to the gas station you're amazed by how much prices have increased. At this time last year, the price was $3.20 per gallon and now the price is $4.25 per gallon. Which of the following spreadsheet formulas correctly calculates the percentage change?

=((4.25-3.20)/3.20)*100

Period

Single payment

Select three true statements regarding labels a. usually a text or text&number combination b. interact with other cells - can be used in calculations c. can be created by typing an apostrophe in front of a number d. remain on the left side of a cell when entered

a. c. d.

In Google Sheets, what are two methods that allow a user to move data from one cell to another cell? a. drag the data to the desired cell when the cursor changes to a drag hand b. double click the cell and then drag the data to the desired cell c. click on the cell then choose the move data option form the Data menu d. right click the cell and then cut and paste the data into the desired cell

a. d.

If you type = 3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell? a. 27 b. #VALUE! c. 42 d. 15

a. 27

To determine how much a recurring monthly payment would be for a car loan or a mortgage, use the ____ function. a. PMT b. Average c. AutoSUM d. COUNT

a. PMT

If you want to find the mean of the values in a spreadsheet, what function would you place in selected cell? a. average b. count c. percentage d. autosum

a. average

What are the two most common spreadsheet charts? a. bar graphs b. line graphs c. pie charts d. pie graphs

a. bar graphs b. line graphs

If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ___ options. a. freeze b. stay c. search d. still

a. freeze

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? a. heavy border b. red lettering c. highlighted column and row headings d. name box, in the upper left corner of the sheet

a. heavy border c. highlighted column and row headings d. name box

The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's a. interest b. period c. term d. principal

a. interest

Bankers and other lenders refer to the initial amount of the loan (the principal) as the loan's a. present value (PV) b. future value (FV) c. interest (APR) d. term

a. present value (PV)

The amount of money borrowed in a loan is often referred to as the loan's balance or the ____ of the loan. a. principal b. period c. interest d. term

a. principal

To insert a Column to the left of another column in an OpenOffice Calc file, elect Column D and then ___ and select insert. a. right-click b. left-click c. double-click d. shift-click

a. right-click

Present Value

amount of money (principal) originally borrowed or owed

Rate

annual percentage rate (APR) of interest

What function would you use to display how many entries are made in a column above a selected cell? a. average b. count c. percentage d. autosum

b. count

Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ___ tab to create a pivot table. a. data b. insert c. file d. style

b. insert

Sports analysts often use ___ to keep track of statistics, times, and the scored of nearly every sporting event. a. presentation software b. spreadsheets c. calculators d. word processors

b. spreadsheet

Which of the following refer to the amount of money a lender charges for borrowing money (excluding origination fees)? a. principal b. the APR c. the interest rate d. term

b. the APR c. the interest rate

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? a. #### b. #REF! c. #VALUE! d. 0

c. #VALUE!

In the financial world, which color represents credits or profits? a. red b. white c. black

c. black

What is the purpose of using color in spreadsheets? a. color makes the spreadsheet less memorable b. color helps the color-blind c. color makes data easier to read.

c. color makes the data easier to read.

To select non-adjoining cells in a spreadsheet, hold down the ___ key while selecting cells. a. alternate (alt) b. shift c. control (ctrl) d. enter

c. control (ctrl)

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. a. interest (APR) b. term c. future value (FV) d. present value (PV)

c. future value (FV)

What is the purpose of saving an Excel file as a .cvs (comma-separated format) file? a. to share data with other PPT users b. to share data with other Microsoft Word users c. to share data with other spreadsheet users regardless of which spreadsheet program is being used d. to share data with other Outlook users

c. to share data with other spreadsheet users regardless of which spreadsheet program is being used.

The number in a cell depicted is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right? a. 0 b. #VALUE! c. nothing d. 27

d. 27

Saving a spreadsheet file in .cvs format only saves the a. cell styles b. cell formulas c. text cells d. cell values

d. cell values

The total amount of money (principal+interest) that lender receives from a borrower at the end of the loan is referred to as the loans a. principal b. term (in years) c. interest (APR) d. future value (FV)

d. future value (FV)

In a spreadsheet, a horizontal line of cells is called a a. column b. cell c. field d. row

d. row