Spreadsheets SmartBook
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? - #DIV/0 - #VALUE! - #REF! - #####
#VALUE!
Which of the following are the common uses of spreadsheets? - Budgeting - Finance - Word processing - Photo processing
- Budgeting - Finance
Spreadsheets are used for - budgeting - counting, adding, and subtracting - corporate financials - all of the above
all of the above
In spreadsheets all functions and calculations begin with __. - an equals sign (=) - a plus sign (+) - a value - a cell (A3, for example)
an equals sign (=)
Sheets
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 ______. - identifier. - value. - label. - nominal.
label.
In the image, if the user right-clicks and selects Insert, a blank column will be inserted to the ___ of column D.
left
The descriptions of the two lines shown at the bottom of this chart are a chart element known as a ___.
legend
Most commonly used to compare changes over time, ___ graphs can be quickly created using any spreadsheet program.
line
In most spreadsheet programs, the first step in adding chart elements is to ___. - right-click the chart - select the chart - open the Insert menu - click the Chart Design tab
select the chart
To name a range of cells in Microsoft Excel and Google sheets, ___ the selected range and select the range naming option from the menu. - left-click - double-click - shift-click - right-click
right-click
Placing the cursor between row headings 3 and 4 allows you to adjust the: - column width. - cell selection. - row height. - font.
row height.
In this worksheet, what is in cell C5? - $14.67 - G.E. - Mutual fund - $18.91
$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? - $33.00 - $20.70 - $21.60 - $19.50
$20.07
If you want to find the mean of the values in cells A1, A2, and A3, what function would you place in A4? - AutoSUM - COUNT - Average - Percentage
Average
The IF function uses logical tests. A logical test is any value that can be evaluated as: - Greater than. - Less than. - Pass or Fail. - True or False.
True or False.
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
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
A popular cloud-based spreadsheet is - LibreOffice Calc - Microsoft Excel 365 - Microsoft Multiplan - Apple's Numbers
Microsoft Excel 365
In the above Calc file, the user has selected ___ D.
column
To determine how much a recurring monthly payment would be for a car loan or a mortgage, use the ___ function.
payment or PMT
Analogous Colors
provide little contrast
In OpenOffice Calc, use the Insert menu to name a range (see above).To name a range of cells in most spreadsheet programs ___ the range and select the naming option. - double-click - shift-click - right-click - left-click
right-click
Programs, such as Microsoft Excel, iWorks (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called _____ programs. - database - spreadsheet - calculation - word processing
spreadsheet
Color ___ attempts to describe how colors convey feeling. It also describes the way most people perceive messages through color.
theory
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
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. - .pdf - .xlsx - .ods - .csv
.csv
To display the highest value in a range quickly, use the ___ function.
max
Match the chart element
1. y-axis 2. title 3. x-axis 4. ledgend
If you type = 3 + 22 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell? - 42 - 15 - 135 - #VALUE!
135
The formula above multiplies the value in C5 times the value in C8. Why are there dollar signs in the C8 notation? - It is an absolute reference - It accepts approximations - It must be a positive value - It is a relative reference
It is an absolute reference
All the following are popular spreadsheet packages except - Microsoft Excel - Lotus 1-2-3 - Corel's Quattro Pro - Microsoft Access
Microsoft Access
Calc
OpenOffice (Apache)
Complementary Colors
Provide excellent contrast
Wyatt cannot understand what is going on in Cell A1 (above). You explain that the ### symbols mean that ___. - This is an error. It indicates that a label has been entered into a formula. - This is not an error. Cell A1 needs to be expanded in order to display the entire value. - This is not an error. A series of #### symbols indicates that the formula is dividing a value by zero. - This is an error. Cell A1 contains an invalid cell reference.
This is not an error. Cell A1 needs to be expanded in order to display the entire value.
An easy means of depicting different categories of items in a spreadsheet is to use different ___ to separate the categories.
colors
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. - select cell C2. - delete the contents of C2. - cut and paste the contents of C2.
copy the contents of C2.
What function would you use to display how many entries are made in column A above cell A37? - AutoSUM - Average - Percentage - COUNT
count
All of the following are true about spreadsheets except - they are limited to 255 rows and 63 columns - each cell represents an intersection of a row and a column - they are similar to paper ledgers - they can automatically compute and recompute formulas as numbers are updated
they are limited to 255 rows and 63 columns
Put the steps in order for converting an iCloud Numbers file to an Excel file. - Click the tools button - Select download a copy and choose a format - save the file - name the file
1. Click the tools button 2. Select download a copy and choose a format 3. Name the file 4. Save the file
Put the steps in order for opening Google Sheets
1. Login to your Google Account 2. Click the Apps Launcher 3. Select Google Sheets
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? - = 3.20 - 4.25 / 4.25 * 100 - = (4.25 + 3.20) / 3.20 * 100 - = (3.20 - 4.25 / 3.20) * 100 - = ((4.25 - 3.20) / 3.20) * 100
= ((4.25 - 3.20) / 3.20) * 100
Which of the following spreadsheet formula would correctly calculate the average (mean) of the following values: 4, 2, 5, and 5? - (4 + 2 + 5 + 5) * 4 = - = (4 + 2 + 5 + 5) / 4 - = 4 + 2 + 5 + 5 / 4 - 4 + 2 + 5 + 5 * 5 =
= (4 + 2 + 5 + 5) / 4
Which cell contains a value?
A2
Numbers
Apple
If you see the Apache OpenOffice icon on your desktop, you know that there probably is spreadsheet software on the computer. The spreadsheet program in OpenOffice is called ___.
Calc
In Numbers (above) 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: - View. - Insert. - Home. - Windows.
View.
Which of the following statements are true regarding labels? - Can be created by typing an apostrophe in front of a number - Interact with other cells—can be used in calculations - Usually a text or text+number combination - Remain on the left side of a cell when entered
- Can be created by typing an apostrophe in front of a number - Usually a text or text+number combination - Remain on the left side of a cell when entered
Because interest rates are advertised as annual percentage rates (APRs), when using the PMT function to determine a monthly payment it is necessary to divide the rate by: - 6 - 10 - 48 - 12
12 hoe
You made a simple spreadsheet for an online class assignment for a group project and want all group members to be able to open it regardless of what spreadsheet program they use. Which format would be the best to use? - CSV - PDF - DIF - XLSX
CSV
To create a chart in Excel, first highlight the appropriate data and then open the ___ menu.
insert
In the image, if the Enter key is pressed, what will appear in cell A3? - ##### - #DIV/0! - 0 - 27
#DIV/0!
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.50 - $85.00 - $14.00 - $7.00
$10.50
Select three reasons why many presenters use color in their spreadsheets. - Color can be used to highlight trends or outlying data. - Color can change the spreadsheet's formulas. - Color can make it easy to see different categories of data. - Color can make the data more memorable.
- Color can be used to highlight trends or outlying data. - Color can make it easy to see different categories of data. - Color can make the data more memorable.
Which of the following arguments must be entered when using the PMT function? - Nper - Rate - Term - Pv
- Nper - Rate - Pv
You need to save your OpenOffice Calc file as an Excel file so that you can then e-mail it to a coworker. Place the following steps in the correct order with the first step at the top. - Select Save As - Choose a folder and name the file - Open the File menu - Open the save as type menu - Select Excel
1. Open the File menu 2. Select Save As 3. Choose a folder and name of the file 4. Open the Save as type menu 5. Select Excel
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) - =IF(B2=60) - =IF(B2>6) - =IF(B2<60%)
=IF(B2>6)
Σ What does the above symbol represent in spreadsheets? - Average - Percentage - AutoSUM - COUNT
AutoSUM
Excel
Microsoft
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? - WACC - TVM - NPV - ROI
TVM
Green through violet (including greys)
Tend to calm, or make data recede in most viewers' perception
Red through yellow (including browns)
Tend to excite, or to make data come forward in most viewers' perception
True or False: 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
Use the AutoSUM function if you want to quickly ___ a series of values in a spreadsheet.
add
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: - a plus sign. - an equals sign. - B1. - A2.
an equals sign.
Color is often used in financial discussions. For example, a company that is making money or profitable is sometimes said to be "in the __".
black
A pivot table can quickly organize a spreadsheet's info. The pivot table creation options are located under the ___ tab. - Review - View - Data - Home
data
In the image, the 4-headed arrow on the edge of the cell allows the user to ___ the data.
drag or move
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: - copy the data down the column. - delete the data. - copy the data across the row. - drag the data to another cell.
drag the data to another cell.
You just selected the data for your chart by dragging your cursor over the desired cells. The next step in creating a chart is to open the ___ menu. - Edit - Insert - Tools - Data
insert
You just selected the data for your chart by dragging your cursor over the desired cells. The next step in creating a chart is to open the ___ menu. - Tools - Insert - Edit - Data
insert
To quickly display the highest number of boxes of cookies purchased by one buyer (column B), use the ___ function. - Max - Count - Average - Highest
max
You created a spreadsheet in Calc and wish to add chart elements. You know they are located in the Insert menu, but when you click on the menu the options to add elements are not appearing. This is because you have not: - referenced the File menu. - right-clicked the chart. - selected the chart. - opened the Insert menu.
selected the chart.
Saving a spreadsheet allows you to keep your file for future use. One difference between Microsoft Excel, Google Sheets, Apple Numbers, and Open Office Calc is that ___ saves changes automatically. - Calc - Numbers - Sheets - Excel
sheets
Holding down the ___ allows users to select a range of adjoining cells - Tab - Shift - Alt - Escape
shift
Put the steps of the information processing cycle in the correct order, with the first step at the top. - Output - Input - Process - Store
1. Input 2. Process 3. Store 4. Output
You need to add elements to your chart in Excel. Place the following steps in order with the first step at the top - Open the Add Chart Element menu - If not already open, select the Design tab - If not already open, select the Chart Tools tab - Add the desired elements - Select the chart (by clicking on it) - Open the File menu
1. Open the File menu 2. Select the chart (by clicking on it) 3. If not already open, select the Chart Tools tab 4. If not already open, select the Design tab 5. Open the Add Chart Element menu 6. Add the desired elements
If you type = 2 + 3 * 6 into a cell in a spreadsheet and then press Enter, what will appear in the cell? - 30 - #VALUE! - 20 - Error
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 - 0 - Nothing - #VALUE!
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 / 325,000 * 100 - = (280,000 + 325,000) / 325,000 * 100 - = (325,000 - 280,000 / 280,000) * 100 - = ((325,000 - 280,000) / 280,000) * 100
= ((325,000 - 280,000) / 280,000) * 100
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
Useful to showing parts of a whole, the ___ is created by highlighting the desired data and choosing from the Insert menu. - Line graph - Pie chart - Bar graph - Bar chart
pie chart
Color is often used in financial discussions. For example, a company that is losing money or deep in debt is sometimes said to be "in the ___".
red
If you are using OpenOffice Calc and wish to send your spreadsheet to a colleague who uses Microsoft Excel, use the ___ feature. - Versions - Wizards - Save As - Hyperlink
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. - Download - Save As - Convert - Transfer
save as
In the image, the user has placed the pointer between columns B and C. This will allow the user to adjusts the column ___.
size
Computer programs that allow users to easily arrange, calculate, and present numerical data are called ___ programs.
spreadsheet
The four basic functions of a computer are to: 1 - accept data input 2 - process data into information 3 - present output 4 - provide
storage
True or False? A spreadsheet created in Google Sheets can be downloaded as a Microsoft Excel file (.xlsx).
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 - nominal - percentage - average
value
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? - Highlighted column and row headings - Heavy border - Red lettering - Name box (in the upper left corner of the sheet)
- Highlighted column and row headings - Heavy border - Name box (in the upper left corner of the sheet)
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? - If using Excel, type F4 after B2 in the calculation - Make B2 an absolute reference in the calculation - Replace =C4*B2 with =C4*$B$2 - Change =C4*B2 to =C4*B3
- If using Excel, type F4 after B2 in the calculation - Make B2 an absolute reference in the calculation - Replace =C4*B2 with =C4*$B$2
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 - Double-click the cell and then drag the data to the desired cell - Click on the cell then choose the move data option from the Data menu - 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 - Drag the data to the desired cell since the drag-hand is already showing
Which of the following are the 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 - Double-click the first cell in the range and enter the last cell in the range - Right-click the first cell in the range and enter the last cell in the range
- 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
Place the steps for saving a spreadsheet file in Excel, Numbers, and Calc in correct order, placing the first step at the top. - Name the file - determine where the file shall be stored - open the file menu - select save (or save as)
1. Open the file menu 2. Name the file 3. Determine where the file shall be stored 4. Select Save (or save as)
Place the following steps in order to create a VLookup. - Enter the necessary arguments - Click OK - Select and name the range of cell for the VLookup to search - Search for and select the VLookup function - Click the Insert function button
1. Select and name the range of cell for the VLookup to search 2. Click the Insert function button 3. Search for and select the VLookup function 4. Enter the necessary arguments 5. Click OK
To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) ___ reference.
absolute
The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n) ___. - reference - address - blank - cell
cell
Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ___ tab to create a pivot table.
data
In the above chart, the elements circled in red are called: - legends. - axis titles. - data labels. - grid lines.
data labels.
To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the ___ function.
if
To hide column D, first click on the column heading and then ___ to open the menu and select Hide. - double-click - right-click - shift-click - left-click
right-click
To insert a column to the left of column D, select column D and then ___ and select insert. - double-click - left-click - right-click - shift-click
right-click
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. - database - spreadsheet - word processor - presentation
spreadsheets
Sports analysts often use ___ to keep track of statistics, times, and scores of nearly every sporting event. - calculators - spreadsheets - databases - word Processors
spreadsheets
The small black cross in the lower right corner of the cell containing 27 is called the ___ handle.
fill