Spreadsheets Quiz
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!
If you type =2 + 3 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
20
If you type =3+2^2*6 into a cell in a spreadsheet and then press Enter, what will appear in the cell?
27
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
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
In Google Sheets, what are two methods that allow a user to move data from one cell to another cell?
Drag the data to the desired cell when the cursor changes to a drag hand. Right-click the cell and then cut and paste the data into the desired cell.
In financial institutions, the color red represents positive values.
FALSE
If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ________ options.
Freeze
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
Single payment
Period
Amount of money (principal) originally borrowed or owed
Present Value (PV)
Which three of the following refer to the amount of money owed on a loan when it is first borrowed (excluding any origination fees).
Principal Balance Present Value (PV)
Annual percentage rate (APR) of interest
Rate
Select two methods of selecting a range of adjoining cells in Excel.
Select the first cell in the range and drag down to the last cell. Select the first cell in the range then hold down the shift key and select the last cell in the range.
A legend shows which items are being identified by the different colors, lines, bars, or pie segments.
TRUE
Comma-separated format (.cvs) files are commonly used by those who are sending data but do not know what spreadsheet the recipient uses.
TRUE
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
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
In the financial world, which color represents credits or profits?
black
Select three true statements regarding labels.
can be created by typing an apostrophe in front of a number remain on the left side of a cell when entered usually a text or text+number combination
Saving a spreadsheet file in .csv format only saves the
cell values.
Select two common uses of spreadsheets.
finance budgeting
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).
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?
highlighted column and row headings name box (in the upper left corner of the sheet) heavy border
Each loan payment is referred to as a(n)
period.
The amount of money borrowed in a loan is often referred to as the loan's balance or the ________ of the loan.
principal
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
To Insert a Column to the left of Column D in an OpenOffic Calc file, select Column D and then ________ and select Insert.
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
Sports analysts often use ________ to keep track of statistics, times, and scores of nearly every sporting event.
spreadsheets
Which two of the following refer to the amount of money a lender charges for borrowing money (excluding any origination fees)?
the APR (annual percentage rate) the interest rate
You see ###### in a cell. This means that
this is not an error. The cell needs to be expanded in order to display the entire value.
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
Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 3, 2, 6, and 8.
= (3 + 2 + 6 + 8) / 4
Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 4, 2, 5, and 5.
= (4 + 2 + 5 + 5) / 4
Length of loan in years
Term
A friend asks if you want to go see the new Avengers movie but you say it's too expensive. "No it's not, tickets have only gone up $2.00 since last year," says your friend. You reply, "tickets went from $8 to $10 for a matinee. That is a large percentage increase. What formula would provide the percentage increase?
= (10 - 8) / 8 * 100
