microsoft excel unit 6

Which of the following would need to be formatted as either a float or a string?

1.56

Pie charts add up to which number?

100 percent

What is the ideal range of sections for a pie chart?

2-12

Which of the following is a Boolean value?

TRUE

What is the function of plot area gridlines?

They help readers judge values that are far from the labels.

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?

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

_____ charts are horizontally aligned; ____ charts are vertically aligned.

bar:column

All ___ values can also be expressed as ____.

boolean, strings

By default, how will Excel order the slices in a pie chart?

clockwise by order in the spread sheet

Which charts can be combined with a sparkline?

column

Which two types of charts would it make sense to sometimes overlay with a line chart to show trends?

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?

column chart

Besides basic appearance, what is the major difference between line and column charts?

column charts don't require a form of progression

The difference in line-types in a line chart is largely:

cosmetic

Yvonne is creating a chart and wants Excel to completely skip all cells in her spreadsheet that are missing data. What popup does she need to access to make this change?

data source

What is an example of a possible use of Boolean values in a spreadsheet?

determining whether or not individuals cells in a range are red

Alanis has a pie chart is 80 percent filled on one section, and she wants to help the reader focus into the sections that make up the other 20 percent. What can she apply to the chart to do so?

explosion

Integers are an appropriate data type for a spreadsheet dealing with prices and currency.

false

Isolation can pull slices outside of the chart area itself.

false

SmartArt charts are tools for visualizing numerical data that function quite similarly to those found in Excel's Charts group

false

To resize a row in a chart, users can select the bar for that row and drag and drop the corner.

false

Up/Down bars work best in charts with only a few data points.

false

Users can drag and drop individual columns in a chart to change their order.

false

What refers to a sparkline that proceeds past the margins containing a range of data?

forecast

To add space between every "slice" in a pie chart at once, the user should use:

format data series

Where are the settings to alter the rotation and space between slices for a pie chart?

format data series

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

Which type of chart is created in Smart Art, not the Charts group?

funnel chart

What Excel group contains the option someone would use to create a SmartArt organization chart?

illustrations

All charts can be added into Excel through which tab?

insert

Ananda wants to pull a single "slice" (piece of data) of her pie chart out for emphasis in a slideshow. What is this called?

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

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?

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?

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?

on a separate worksheet

Most line charts contain how many lines?

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?

organizational chart

Pearl wants to set up a chart that shows the workflow of a document through her team, from various writers working on different parts, to their editors, to a copyeditor, to publisher, etc. The workflow isn't unidirectional; editors and writers often exchange work back and forth several times. Which type of chart is BEST for her purposes?

organizational chart

When a chart is selected, which symbol can be used to quickly alter the color scheme or style of the chart?

paintbrush

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?

pie chart

Which type of chart does not rely on having a horizontal and vertical axis for data?

pie chart

When a chart is selected, which symbol can be used to quickly remove elements, like a legend, label, or trendline?

plus sign

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?

quick analysis

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

Which type of chart relays information by single points of data on a grid?

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?

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?

scatter chart

Which type of chart is specifically built to compare at least two sets of values or pairs of data?

scatter chart

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 up the data by year and not quarter

Via the ____ options, users can often find an entire visual aesthetic for a chart without making manual edits.

style and color

By default, a series in a chart refers to an individual row or column of data.

true

CSV files are actually an example of a database.

true

Excel allows users to apply numerous 3D effects to multiple types of charts.

true

Line charts are best for comparisons over time, while column charts work better for comparing discrete moments in time.

true

Trendlines can be added to both bar and column charts.

true

Unscrupulous users can present data that is technically true, but misleading to the audience, by manipulating chart legends and labels.

true

Users can add as many lines as they want to a single line chart.

true

When it comes to designing a chart, the more information a user can include, the better.

true