Spreadsheets Practice Warm-Up Assignment

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!

Select two common uses of spreadsheets

1) Budgeting 2) Finance

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

1) Drag the data to the desired cell when the cursor changes to a drag hand. 2) 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.

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

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 =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?

27

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

To select nonadjoining cells in a spreadsheet, hold down the ________ key while selecting cells.

Control (Ctrl)

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

Cross-Hairs

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

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

absolute

Use the AutoSUM function if you want to quickly ________ a series of values in a spreadsheet.

add

In spreadsheets, all functions and calculations begin with

an equal sign (=).

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

black

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

cell.

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

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

present value (PV).

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

Match the part of the loan with its definition.

Amount of money (principal) originally borrowed or owed Present Value (PV) Length of loan in years Term Single payment Period Annual percentage rate (APR) of interest Rate

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

n 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 often used in budgeting, accounting, finance, grading, gambling houses, and even sports analysis.

spreadsheet

When displaying financial information, the accepted practice is that ________ indicates negative values.

red

Sports analysts often use ________ to keep track of statistics, times, and scores of nearly every sporting event.

spreadsheets