Spreadsheets

Which of the following are the common uses of spreadsheets?

Budgeting Finance

In the image, the user has placed the pointer between columns B and C. This will allow the user to adjusts the column __

Width

If you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the ___ options.

freeze

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

spreadsheets

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

In the image, if the Enter key is pressed, what will appear in cell A3?

#DIV/0!

In the Excel image, cell A3 contains a formula that subtracts A1 (Panda) from A2 (20). If the user hits the Enter key, what will appear in cell A3?

#VALUE!

You treat a classmate for a coffee and decide to leave a 20% tip on your $12 bill. What will be the total charge on your debit card?

$14.40

You just had a great lunch at a nice restaurant and decide to leave a 15% tip on your $18 meal. What will be the total charge on your debit card?

$20.70

Place the steps for saving a spreadsheet file in Excel, Numbers, and Calc in correct order, placing the first step at the top. Instructions

1. Open the file menu 2. Name the file 3. Determine where the file shall be stored 4. Select Save (or Save As)

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 = 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

Which of the following IF function logical tests would show if a student scored above 60% in the 10-point quiz results shown above?

=IF(B2>6)

Which cell contains a value?

A2 Values can interact with other cells and by default are right-justified in the cell in most spreadsheet programs. A label is used to assist users in identifying data in a spreadsheet.

What function would you use to display how many entries are made in column A above cell A37?

COUNT

If you do not see the Numbers icon on your iMac toolbar, you could go to the Launchpad to open the app. Alternatively, you could look for it through the __.

Finder

To quickly display the highest number of boxes of cookies purchased by one buyer (column B), use the ___ function.

Max

Which 3 of the following arguments are usually entered when using the PMT function?

Nper Rate Pv

Select the two spreadsheet programs.

OpenOffice Calc Apple Numbers

To determine how much a recurring monthly payment would be for a car loan or a mortgage, use the function.

PMT

___ clicking on the row heading for row 3 and selecting Insert will put a blank row above row 3.

Right

___ clicking on the row heading for row 3 and then selecting Delete will delete row 3.

Right

In the image, which of the following two methods allow a user to move the data in cell C3 to another cell?

Right-click the cell and then cut and paste the data into the desired cell Drag the data to the desired cell since the drag-hand is already showing

If you are using OpenOffice Calc and wish to send your spreadsheet to a colleague who uses Microsoft Excel, use the ___ feature.

Save As

You created a spreadsheet in Calc and wish to send the data to a friend who only uses Excel. You can do this by using the ___ feature.

Save As

You need to add elements to your chart in Excel. Place the following steps in order with the first step at the top. Instructions

Select the chart If not already open, select design tab open the add chart element menu add the desired elements

Select two methods of selecting a range of adjoining cells in Excel.

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

There are various pointer functions included with most spreadsheet programs. It is important to check on the style of the pointer to ensure you are executing the correct command.

True

The IF function uses logical tests. A logical test is any value that can be evaluated as:

True or False.

In the spreadsheet above, if you wanted to make cell B2 show the sum of cells A2 and B1 you would first click on cell B2 and then enter:

an equals sign.

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

colored border.

blue

In the above Calc file, the user has selected D

column

The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's

interest

Advertised as an annual percentage rate (APR), the amount of money a lender charges for a loan is the loan's ________.

interest rate

Placing the cursor between row headings 3 and 4 allows you to adjust the:

row height.

Computer programs that allow users to easily arrange, calculate, and present numerical data are called ________.

spreadsheets

Computer programs that allow users to easily arrange, calculate, and present numerical data are called programs.

spreadsheets

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

spreadsheets

Select three true statements regarding labels.

usually a text or text+number combination can be created by typing an apostrophe in front of a number remain on the left side of a cell when entered

You created a simple spreadsheet in Google Sheets and wish to send the data to a friend. If you do not know what spreadsheet program your friend uses you should send it as a ___ file since it can be opened in any spreadsheet program.

.csv

A pivot table can quickly organize a spreadsheet's info.The pivot table creation options are located under the ___ tab.

Insert

Pivot tables provide a quick way to organize information.In most spreadsheet programs, click the __ tab to create a pivot table.

Insert

To display the smallest value in a selected range quickly, you could use the ___ function.

Min

To retain a row or column, but remove it from view, right-click on the row or column heading and select

hide

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

principal

To delete column D, first click on the column heading and then ___ to open the menu and select Delete.

right-click

Many businesses send data such as product, customer, and orders information between different offices. Since these data do not include any formulas or styling it is commonly sent as a CSV file. CSV stands for comma-separated

values

Put the steps in order for opening Google Sheets. Instructions

1. Login to your google account 2. Click the Apps Launcher 3. Select Google Sheets

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

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 of the following items?

Heavy border Highlighted column and row headings Name box (in the upper left corner of the sheet)

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

Right-click the cell and then cut and paste the data into the desired cell. Drag the data to the desired cell when the cursor changes to a drag hand.

Which of the following statements are true regarding labels?

Usually a text or text+number combination Can be created by typing an apostrophe in front of a number Remain on the left side of a cell when entered

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 OpenOffice Calc, the Freeze cells (panes) option is located in the Window menu. In Excel and Sheets the freeze cells or panes option is located in the menu.

View

In spreadsheets, all functions and calculations begin with

an equal sign (=).

In spreadsheets all functions and calculations begin with __.

an equals sign (=)

In the spreadsheet above the word Uber is found in B6. B6 is called a reference.

cell

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

cell

Saving a spreadsheet file in .csv format only saves the

cell values.

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

control

Column D shows the value of each sale for the day. If you want cell D37 to display the number of sales, you would use the function.

count

In the image, the user has selected a cell and then moved the pointer to the edge of the cell so that the 4-headed arrow appears. This pointer allows the user to:

drag the data to another 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)

An advantage of using Google Sheets is that any changes made are automatically

saved

In most spreadsheet programs, the first step in adding chart elements is to ___.

select the chart

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

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

spreadsheet

In the spreadsheet above, the entries in cells A1 and B2 look the same, but A1 contains a ___ while B2 contains a label.

value

In the above Calc file, cell B3 contains the text entry, Cookie Sales. In spreadsheets, this sort of entry is referred to as a(n)

label

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

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

What is the purpose of using color in spreadsheets?

Color makes data easier to read.

Which principle of finance states that a dollar in your hand today is worth more than a dollar you will receive in the future because a dollar in hand today can be invested to turn into more money in the future?

TVM

To insert a column to the left of column D, select column D and then ___ and select insert.

right-click