Excel unit 3
What is one of the most common types of hyperlinks that would automatically appear for a data type entered into an Excel spreadsheet?
email addresses
What term refers to the text in a cell being in bold or italics?
formatting
Bar charts are most commonly used to show differences without any particular order.
true
Using Cut makes the data look like it's disappeared, but the information is actually still saved in a temporary location.
true
By default, what will Excel turn the following data into: November 12, 1952.
12-Nov-52
What is the symbol that represents the Links command in Excel?
2 conjoined ovals
Johanne wants to create a function using the text bar; what symbol tells Excel that the cell should contain a function?
=
What is the limitation of a business moving away from local files to cloud-based alternatives?
A network connection is necessary to access cloud-based files.
Reginald has a spreadsheet of book title names, many of which are quite long. He sees a mistake in the data for a particularly long title—the last word is misspelled. What is the fastest way he can fix this error?
Click on the faulty cell, then change the misspelled word using the Formula Bar.
Cynthia wants to tell Excel to perform a function on the first 15 rows of column E. What should she enter into the Number box for the Function Arguments pop up?
E1:E15
Kieran is trying to create a hyperlink between data in one part of his spreadsheet and another blank workbook he has just created, but he's having trouble doing so. What is the likely mistake here?
He didn't save both workbooks before creating the link
Gerald has copied a 2x5 data set and is trying to paste it into Excel but selected a 1x4 data range in the middle of an existing data set. What risk is he running?
He'll replace existing data on the original spreadsheet.
What's one major advantage of an ePortfolio being online, compared to hard copies?
It can easily and instantly be shown to someone far away.
Dylan has entered a date in a cell and Excel has automatically shortened it, but Dylan wants the cell to display the data as he originally entered it. How can Dylan fix this problem?
Right click the cell and select Format Cells to "Text"
What is an example of the default text displayed when, with an empty cell selected, creating a hyperlink to another spreadsheet?
Sheet2!G5
What's a relatively easy way to protect the content hosted on an ePortfolio?
Tag work with a watermark or signature.
Jocelyn wants to break down how many homework assignments she has for each week of the school year so far to see which weeks had the most work (and how close they were to exam dates). What kind of chart would be BEST suited to this task?
a bar chart
Which of the following is the best visualization for comparing different amounts of one data point?
a bar chart
What is a common example of a combo chart?
a bar chart with a trendline over the rows
Gene is designing his ePortfolio and is trying to decide what the very first thing the user should see when they "open" the portfolio. What is the MOST important thing he should include?
a brief biography and information about the type of content hosted on the site
What's an example of something appropriate for an ePortfolio?
a certificate for courses someone has passed
Terry wants to show how he's gotten taller over the last 10 years, looking especially for spikes in growth. What kind of chart is especially suited to this task?
a line chart
Which type of chart looks like a heart monitor snapshot or a visualization of a sound wave?
a line chart
Len is trying to find the icon for Format Painter. What symbol should he look for?
a paintbrush
What is the simplest available function in Excel?
addition
What symbol represents the menu option to open the Insert Function pop up in Excel?
an italicized fx
What Excel feature helps users by learning common words or number sets in a spreadsheet and automatically suggesting data to fill in the rest of the information as the user types?
autofill
Which two charts are visually identical except for the orientation of the data?
bar and column charts
Therese has entered 10 rows of data into her spreadsheet and realized she made a mistake in a cell in the first row: it has a "10" instead of a "25." What's the fastest way for her to fix this error?
click on the faulty cell and type the correct data
What is a major risk associated with hosting a publicly-available ePortfolio?
content is easily stolen or copied
What is the main purpose of an ePortfolio?
creating a "gallery" that showcases the creator's abilities
Elise wants to move data from one spreadsheet to another, leaving nothing behind. What commands should she use?
cut and paste
What command allows users to apply copied formatting to multiple places in the document without clicking on Format Painter over and over?
double click format painter
While the actual look of a ePortfolio website is up to the creator, what is an important part of the design?
easy to navigate
It's unethical to include work produced for a class in an ePortfolio.
false
Pie charts can represent any total percentage of data, from 1 to 100 percent.
false
Setting a number as a hyperlink will interfere with any calculations or formulas relying on the data in that cell.
false
Sparklines can be created from multiple columns and rows at once, e.g. B1 to G3.
false
The most common type of sparkline is a pie chart showing the ratio of data in the previous cells.
false
Chidi has a cell formatted in an elaborate way and wants to apply that same format to other cells. What Excel tool will allow him to quickly and easily do this?
format painter
What ribbon tab contains the command to open the Insert Function pop up?
formulas
What is an example of a free provider for ePortfolio hosting appropriate for a student who doesn't want to do a lot of research into hosting services?
What is the general term referring to a visual representation of at least two data points?
graph
Since humans are visual creatures, _____ are a way to turn _____ into something more easily understood.
graphs;raw data
Sierra is looking for the Format Painter tool. What tab will she find it in?
home
Pat wants to add a sparkline to his spreadsheet. What tab should he open?
insert
Elian wants to create a header row for a spreadsheet that has the single title, "Siblings," over multiple columns of data. What tool can he use to quickly create a single cell with that title in it?
merge and center
All of these are sparkline options EXCEPT:
pie chart
Melanie wants to use a chart to show, at a glance, what percent of her budget goes to groceries, how much goes to entertainment, how much goes to rent and utilities, etc. What kind of data visualization tool is especially suited to this task?
pie chart
Melia wants to create a hyperlink between a cell in one spreadsheet and a cell in another spreadsheet in the same workbook. What option should she use in the Link menu?
place in this document
Besides the ribbon menu, how can a user quickly access the Format Cells menu?
right click the cell
What command bring ups the option to Cut data?
right clicking
What are sparklines MOST useful for?
showing an up/down trend in data
What is used to create a subtotal in Excel?
the Addition function
When using a SUM command, what will happen if a normal text string (e.g., "one hundred") is included in the cell range the function will be applied to?
the cell with text will be ignored
Combo charts are any chart that combines more than one type of chart together.
true
Data collected on the clipboard from other applications can be pasted into Excel.
true
Excel allows for both pre-made functions and user-created functions.
true
Format Painter saves all the formatting applied to a selection of cells, rows, or columns and applies that look to other content.
true
If a user wants to paste copied data into a specific area of a spreadsheet, they need to ensure that the data will fit into the selected cell range.
true
In the Function Arguments pop up, users can select individual cells, cell ranges, or even numbers.
true
Many colleges and universities ask students to create an ePortfolio, so they aren't just used in job application processes.
true
Once a function has been applied to a set of cells in Excel, changing the value in any of the cells will dynamically change the result.
true
