Spreadsheets CGSC1060

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!

The stylist just did a great job and your hair is going to look good for weeks. The stylist charged $70 and you decide to add a 15% cash tip. How big is the tip?

$10.5

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

In this worksheet, what is in cell C5?

$14.67

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

Put the steps in order for opening Google Sheets. 1. Login to you Google Account 2. Click the Apps Launcher 3. Select Google Sheets

1. Login to you Google Account 2. Click the Apps Launcher 3. Select Google Sheets

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

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

You are tired of paying rent but the cost of a house keeps increasing. At this time last year the average price was $280,000 and now it is $325,000. Which of the following spreadsheet formulas correctly calculates the percentage change?

= ((325,000 - 280,000) / 280,000) * 100

Every time you go to the gas station you are 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

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

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

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

AutoSUM

What does the above symbol represent in spreadsheets?

AutoSUM

If you want to find the mean of the values in cells A1, A2, and A3, what function would you place in A4?

Average

In this worksheet, what cell is active?

B7

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

COUNT

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

COUNT

What is the purpose of using color in spreadsheets?

Color makes data easier to read

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

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

In the Home tab and the Formula tab in Excel, where is a button for Average found?

In the AutoSUM dropdown menu

You have just highlighted the data you wish to depict with a chart. Which tab should you open next to create the chart?

Insert

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

PMT

When you used the fill handle to copy the formula in cell D4 down the column, you received an error message. How could you fix this?

Replace =C4*B2 with =C4*$B$2 If using Excel, type F4 after B2 in the calculation Make B2 an absolute reference in the calculation

Wyatt cannot understand what is going on in Cell A1 (above). You explain that the ### symbols mean that ___.

This is not an error. Cell A1 needs to be expanded in order to display the entire value.

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

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

In most spreadsheet programs the active cell is shown with a thick black border. In Google Sheets (as shown above), the active cell has a thin ___________ colored border.

blue

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 .cvs format only saves the

cell values

In the above Calc file, the user has selected _________ D.

column

In the file above the small black cross in the lower right corner of cell C2 allows the user to:

copy the contents of C2

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

count

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

ctrl

Placing the cursor between row headings 2 and 3 and then ___ allows you to auto-adjust the row height.

double-clicking

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

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

equal

The small black cross in the lower right corner of the cell containing 27 is called the ________ handle.

fill

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

freeze

The Rule of 72 states that dividing 72 by the interest rate approximates the time for the investment to double. This calculates the ________ of the investment.

future value (FV)

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

heavy border; highlighted column and row headings; name box (in the upper left corner of the sheet)

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

To create a chart in Excel, first highlight the appropriate data and then open the ________ menu.

insert

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

label

In the spreadsheet above, the entry in cell A1 (Patient), does not interact with other cells and cannot be used in a calculation. In this case, the entry in cell A1 is a:

label

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

plus sign

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

To delete column D, ________ -click and then select Delete from the menu.

right

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

right

___ clicking the row heading for row 3 and then selecting Hide will hide row 3.

right

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 delete column D, first click on the column heading and then ___ to open the menu and select Delete.

right-click

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

right-click

In a spreadsheet, a horizontal line of cells is called a

row

In a spreadsheet, a horizontal line of cells is called a _____.

row

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

row height

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

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

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

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called

spreadsheets

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

spreadsheets

If you have Excel on your Windows computer but you do not see it on your desktop or toolbar, you can click the ___ button to navigate to Microsoft Office and Excel.

start

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

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

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 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 the image, the user has placed the pointer between columns B and C. This will allow the user to adjusts the column __

width

In the Apple Numbers file above, if you wanted to copy the active cell's contents down, you would click on the ___ and drag down.

yellow dot in lower center of the cell