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