Week 9 : Spreadsheets IS

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

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

= (25 + 50 + 75) / 3

Select the two spreadsheet programs.

Apple Keynotes OpenOffice WriterBottom of Form

Σ What does the above symbol (upper-case Sigma) represent in spreadsheets?

Auto Sum

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

Control (Ctrl)

When you enter a calculation into a spreadsheet, you start by entering a(n) ________ sign.

Equal

Select the two spreadsheet programs.

Microsoft Access Google Slides

A function that looks for a value in the leftmost column of a table, and then returns a value located in the same row as the first value, is called a

VLookup.

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

add

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

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

Each loan payment is referred to as a(n)

period

When adjusting the width of a column or the height of a row, which pointer(s) is/are used?

pic

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

pic

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

present value (PV)

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

red

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

In 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 commonly used in nearly every business setting.

spreadsheet

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

Comma-separated format (.cvs) files are commonly used by those who are sending data but do not know what spreadsheet the recipient uses.

true

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