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
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
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
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
Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ________ tab to create a pivot table.
insert
