INFO 360 Quiz 4

The number 27 in the cell depicted above is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right?

27

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

= (25 + 50 + 75) / 3

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

cell

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.

Saving a spreadsheet file in .csv format only saves the

cell values

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

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

principal

Because they make it easy to arrange, display, and calculate numerical data, ________ programs are commonly used in nearly every business setting.

spreadsheet

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