ch 4 spreadsheets info 360
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!
A friend asks if you want to go see the new Marvel movie but you say it is too expensive. "No it is 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
Most commonly used to compare changes over time, graphs can be quickly created using any spreadsheet program.
.line
Match the chart element.
1 matches Choice Y-axis 2 matches Choice Title 3 matches Choice X-axis 4 matches Choice Legend
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:
12
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
Which of the following spreadsheet formula would correctly calculate the average (mean) of the following values: 25, 50, and 75?
= (25 + 50 + 75) / 3
What does the above symbol represent in spreadsheets?
AutoSUM
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
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
Which of the following statements are true regarding labels?
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
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
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 Name box (in the upper left corner of the sheet)
Analogous colors
Provide little contrast
Which 3 of the following arguments are usually entered when using the PMT function?
Pv Nper Rate
Which of the following statements are true regarding labels?
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
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
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
In the image, the user has placed the pointer between columns B and C. This will allow the user to adjusts the column __
Width
Use the AutoSUM function if you want to quickly a series of values in a spreadsheet.
add or sum
n 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 A1, A2, and A3, what function would you place in A4?
average
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
The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n) ___.
cell
Put the steps in order for converting an iCloud Numbers file to an Excel file.
click select name save
In the above Calc file, the user has selected
column
To select nonadjoining cells in a spreadsheet, hold down the key while selecting cells.
control
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 small black cross in the lower right corner of the cell containing 27 is called the handle.
fill
To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the
if
A pivot table can quickly organize a spreadsheet's info.The pivot table creation options are located under the ___ tab.
insert
Put the steps in order for opening Google Sheets.
login click select
You need to add elements to your chart in Excel. Place the following steps in order with the first step at the top.
select if open add
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. Multiple choice question. pres
spreadsheet
Computer programs that allow users to easily arrange, calculate, and present numerical data are called programs.
spreadsheet
Sports analysts often use ___ to keep track of statistics, times, and scores of nearly every sporting event.
spreadsheets
Color attempts to describe how colors convey feeling. It also describes the way most people perceive messages through color.
theory
A spreadsheet created in Google Sheets can be downloaded as a Microsoft Excel file (.xlsx).
true
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
Pivot tables provide a quick way to organize information.In most spreadsheet programs, click the __ tab to create a pivot table.
insert
You have just highlighted the data you wish to depict with a chart. Which tab should you open next to create the chart?
insert
Complete the problem. To name a range of cells in Microsoft Excel and Google sheets, ___ the selected range and select the range naming option from the menu.
right-click
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.
right-click
To hide column D, first click on the column heading and then ___ to open the menu and select Hide.
right-click
Placing the cursor between row headings 3 and 4 allows you to adjust the:
row height.
Drag and drop the correct response into the empty box.
Complementary colors matches Choice Provide excellent contrast
Which of the following are the common uses of spreadsheets?
Finance Budgeting
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?
Make B2 an absolute reference in the calculation If using Excel, type F4 after B2 in the calculation Replace =C4*B2 with =C4*$B$2
A spreadsheet created in Google Sheets can be downloaded as a Microsoft Excel file (.xlsx).
True
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.
insert
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
In the image, if the user right-clicks and selects Insert, a blank column will be inserted to the
left
The descriptions of the two lines shown at the bottom of this chart are a chart element known as a
legend
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
Naming a range of cells is useful when creating a VLookup.To name a range of cells in Excel, select the range by dragging, then
right
To hide column D, -click and then select Hide from the menu.
right
_ clicking the row heading for row 3 and then selecting Hide will hide row 3.
right
___ 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
An advantage of using Google Sheets is that any changes made are automatically
saved
Place the following steps in order to create a VLookup.
select click search enter ok
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
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
Complete the problem. The IF function uses logical tests. A logical test is any value that can be evaluated as:
True or False.
In the image, the 4-headed arrow on the edge of the cell allows the user to __ the data.
drag
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
To display the highest value in a range quickly, use the function.
max
To display the smallest value in a selected range quickly, you could use the ___ function.
min
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
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
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
Place the steps for saving a spreadsheet file in Excel, Numbers, and Calc in correct order, placing the first step at the top.
open name determine select
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
What function would you use to display how many entries are made in column A above cell A37?
count
