Module 5: Spreadsheets

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

Black

The small black cross in the lower right corner of the cell containing 27 is called the _____

Fill Handle

The formula above multiplies the value in C5 times the value in C8. Why are there dollar signs in the C8 notation?

It is an absolute reference.

In the spreadsheet above, the entry in cell A1 (Patient), does not interact with other cells and cannot be used in a calculation. In this case, the entry in cell A1 is a:

Label

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

Present Value

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

Spreadsheet Programs

If you have Excel on your Windows computer but you do not see it on your desktop or toolbar, you can click the ___ button to navigate to Microsoft Office and Excel.

Start

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

absolute

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

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

principle

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.