Excel: Module 6
SmartArt charts are tools for visualizing numerical data that function quite similarly to those found in Excel's Charts group. True False
False
To resize a row in a chart, users can select the bar for that row and drag and drop the corner. True False
False
Trendlines can be added to both bar and column charts. True False
True
Which type of line setting will create a curvy line rather than a straight one? linear forecast moving average exponential
exponential
Which of these is an integer? 1/2 -22 1.45 0.05
-22
Which of the following would need to be formatted as either a float or a string? X/Y Twelve TRUE 1.56
1.56
Pie charts add up to which number? 360 100 percent 10 units It depends on the chart.
100 percent
What is the ideal range of sections for a pie chart? 1-5 2-12 6-20 10 or more
2-12
Irene has selected a bar in a column chart and pressed the Delete key. What will happen? That category/bar will be deleted The data for that bar will be deleted. All bars in that series will be deleted. The entire chart will be deleted.
All bars in that series will be deleted.
_____ charts are horizontally aligned; ____ charts are vertically aligned. Pie; line Line; bar Bar; column Column; bar
Bar; column
All ___ values can also be expressed as ____. Boolean; strings strings; floats floats; Boolean floats; integers
Boolean; strings
Besides basic appearance, what is the major difference between line and column charts? Column charts don't require a form of progression. Column charts can't show change over time. Column charts can't be used for forecasting. Column charts are considered more professional.
Column charts don't require a form of progression.
Gap width is used to determine how big a gap Excel will leave for cells that are missing data. True False
False
Integers are an appropriate data type for a spreadsheet dealing with prices and currency. True False
False
Pie charts are excellent tools to show the effects of change over time. True False
False
Up/Down bars work best in charts with only a few data points. True False
False
Where are the settings to alter the rotation and space between slices for a pie chart? Text Options Format Chart Area Format Plot Area Format Data Series
Format Data Series
To add space between every "slice" in a pie chart at once, the user should use: Format Data Point. Format Data Series. Format Plot Area. Format Chart Area.
Format Data Series.
What Excel group contains the option someone would use to create a SmartArt organization chart? Charts Font Tables Illustrations
Illustrations
All charts can be added into Excel through which tab? Insert Data Formulas Home
Insert
All charts can be added into Excel through which tab? Insert Data Formulas Home
Insert
Genevieve has a complex set of numerical data that she wants to create an illustration for, but she doesn't have a good idea which type of chart will be best. What can she use to generate preview charts to try to help figure it out? Test Illustration SmartArt Quick Analysis Sparklines
Quick Analysis
Valerie needs to make a case for investors that her company is growing reliably. On average, it has, but there's a large decrease in sales every summer as students in her community go home for summer break. How can Valeria organize her data visually to show the growth, but not the volatility? She can break the data up by year, not quarters. She can expand the physical size of the chart. She can use a bar chart instead of a line chart. She can show the data in smaller increments (e.g., individual weeks).
She can break the data up by year, not quarters.
Via the ____ options, users can often find an entire visual aesthetic for a chart without making manual edits. Style and Color Smart Art Format and Theme Recommended Charts
Style and Color
What is the function of plot area gridlines? They make outliers obvious. They define the outer range of the chart. They help readers judge values that are far from the labels. They help users predict future trends based on existing data.
They help readers judge values that are far from the labels.
A pie chart would be suitable for showing the relative market share of various soda manufacturers, but not for comparing their net profits. True False
True
By default, a series in a chart refers to an individual row or column of data. True False
True
CSV files are actually an example of a database. True False
True
Line charts are best for comparisons over time, while column charts work better for comparing discrete moments in time. True False
True
Thickening or thinning a line in a line chart can help emphasize a specific series of data. True False
True
Unscrupulous users can present data that is technically true, but misleading to the audience, by manipulating chart legends and labels. True False
True
Users can add as many lines as they want to a single line chart. True False
True
When it comes to designing a chart, the more information a user can include, the better. True False
True
Lars converted a range with a missing value to a chart with a bottom range of 5 and Excel's default settings for handling missing data. What will the value be turned into? an error message a gap a clear/transparent column a column set to "0"
a gap
Dolores wants to "turn" the entire pie chart so that the slice that's at 3 o'clock is closer to 10 o'clock. What does she need to alter? angle explosion isolation implosion
angle
By default, how will Excel order the slices in a pie chart? clockwise from largest to smallest clockwise from smallest to largest clockwise by order in the spreadsheet It depends on the type of data included in the chart.
clockwise by order in the spreadsheet
Which charts can be combined with a sparkline? pie bar line column
column
Which two types of charts would it make sense to sometimes overlay with a line chart to show trends? column and scatter chart bar and pie chart pie and organization chart pie and column chart
column and scatter chart
Greg wants to create a chart which shows the profits and costs for each of the last three months. What chart is best for this? line chart scatter chart column chart pie chart
column chart
What is an example of a possible use of Boolean values in a spreadsheet? counting the number of different colors in the cells in a range determining whether or not individuals cells in a range are red counting the difference between all positive and negative numbers in a range determining how large a range is
determining whether or not individuals cells in a range are red
What refers to a sparkline that proceeds past the margins containing a range of data? explosion isolation forecast exponential
forecast
When a chart is selected, which symbol can be used to quickly add or remove series or categories of data (e.g., hide individual columns in a column chart)? funnel plus sign paintbrush small circle
funnel
Francis is organizing a Smash Bros elimination-style tournament and wants to create a template to use to track who fights who each round. What chart is best for her? pie chart bar chart funnel chart line chart
funnel chart
Which type of chart is created in Smart Art, not the Charts group? row chart line chart pie chart funnel chart
funnel chart
Ananda wants to pull a single "slice" (piece of data) of her pie chart out for emphasis in a slideshow. What is this called? explosion implosion isolation extrusion
isolation
Deborah's pie chart shows which percent of her monthly budget is spent on various categories. She wants the slices to show the exact amounts she spent rather than the percentage. What can she add or change to make this happen? labels legend explosion isolation
labels
What part of a chart explains what each data set means? compass legend index slide rule
legend
Historians often show how certain elements of society change over time, for example tracking disease rates in a city from the 1900s to the present. What kind of chart would a historian likely use for this data? scatter chart funnel chart pie chart line chart
line chart
Marseilles is putting together a sales report for the last 15 months of sales to project how much more inventory her business should purchase for the next month (sales have risen steadily and consistently over the last 10 months). Which type of chart is ideal for this purpose? pie chart scatter chart line chart column chart
line chart
Giovanni wants to add a chart to his workbook. He wants the chart to be legible, easily printable, and he wants to be able to manipulate the chart without having to worry about accidentally changing the original data. What is the BEST location for the chart? above the data in the middle of the data below the data on a separate worksheet
on a separate worksheet
Most line charts contain how many lines? 1 or 2 5 or 6 10 to 20 one for each cell of data
one for each cell of data
Julio wants to create a chart that gives an overview of hierarchy of his school council. What type of chart is best? pie chart organization chart column chart line chart
organization chart
Which chart is used to create a visualization of something that is otherwise abstract and doesn't rely on numerical data? pie chart organization chart column chart line chart
organization chart
Eileen wants to create a chart that shows what proportion of students in her school have red, blonde, or black hair. What chart is she MOST likely to use? scatter chart line chart bar chart pie chart
pie chart
Which type of chart does not rely on having a horizontal and vertical axis for data? line chart scatter chart pie chart All charts use both axes.
pie chart
Linus wants to compare his favorite sports team's win/loss ratio for their current year, last year, the first year they were formed, their best year ever, and their worst year ever. What kind of chart is BEST for this task? row chart line chart pie chart funnel chart
row chart
Which type of chart relays information by single points of data on a grid? pie funnel bar scatter
scatter
Glenda has a data set that marks the height and weight of a group of 100 people. She wants to see how their weight changes as they become taller. What kind of chart is BEST for this task? pie chart organization chart column chart scatter chart
scatter chart
Naomi has a large data set and she wants to quickly create a chart that will show outliers. What kind of chart is BEST for this task? scatter chart flowchart pie chart bar chart
scatter chart
Social scientists often examine how collectively changing one variable in a situation, such as demographic information (age, race, sex), can change other variables in a situation, such as whether they know how to type on a keyboard without looking at it. What kind of chart do social scientists use for this data? pie chart bar chart funnel chart scatter chart
scatter chart
Which type of chart is specifically built to compare at least two sets of values or pairs of data? pie charts organization charts line charts scatter charts
scatter charts
A password for a website would be a ___, but a Personal Identification Number used for a debit card would be a ____. float; integer string; integer float; Boolean Boolean; integer
string; integer
