CIS-110 - Chapter 16 Definitions

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

How do you update a chart after editing the chart data?

A chart is automatically updated when its data source is edited.

What is a column chart, and how is a bar chart different?

A column chart displays values in different categories as columns; the height of each column is based on its value. A bar chart is a column chart turned on its side so that the length of each bar is based on its value.

You can add or remove a chart title using the _____.​

Chart Elements button

Which of the following is an advantage of overlaying chart elements?​

It makes more space for the plot area.

Which of the following is a disadvantage of an embedded chart?​

It might cover worksheet cells that hide data and formulas.

What are major units and minor units?

Major units identify the main intervals on a chart axis. Minor units identify smaller intervals between the major units.

What does it mean to overlay a chart title or legend?

Overlaying a chart title or legend means they are placed on top of the chart in the chart area.

When does the Chart Tools tab appear?​

When you create a graph

Which of the following is a true statement about charts in Excel?​

You can create custom chart types based on the built-in charts.

In what two locations can you place a chart?

You can place a chart in a worksheet as an embedded chart or you can place a chart into a chart sheet, which contains only the chart and no worksheet cells.

When should you use a line chart instead of a column chart?

You should use a line chart instead of a column chart when the data consists of values drawn from categories that follow a sequential order at evenly spaced intervals, as with historical data in which the data values are recorded periodically such as monthly, quarterly, or yearly.

Why would you change the scale of a chart axis?

You would change the scale of a chart axis to make the chart easier to read.

pie chart

a chart in the shape of a circle divided into slices like a pie that shows the data values as a percentage of the whole

combination chart

a chart that combines two or more chart types in a single graph, such as a column chart and a line chart

column chart

a chart that displays values in different categories as columns so that the height of each column is based on its value

line chart

a chart that displays values using a connected line rather than columns or bars

embedded chart

a chart that is an object in a worksheet

chart (graph)

a visual representation of a set of data values

chart element

an individual part of a chart

data marker

an object in a chart that represents a value in a data series, such as a pie slice or column

chart layout

an option for displaying and arranging chart elements

Which of the following is a function of chart layouts?​

They specify which chart elements are displayed and how they are formatted.

How do you add a data series to an already existing chart?

To add a data series to an existing chart, select the chart, click the Select Data button in the Data group on the Chart Tools Design tab, click the Add button in the Select Data Source dialog box, click in the Series name box in the Edit Series dialog box, select the range with the new data series. Click OK in each dialog box.

data bar

conditional formatting that adds a horizontal bar to a cell's background that is proportional

Which of the following is an accurate statement about overlaying chart elements?​

​It allows you to drag a chart element to a new location.

In Microsoft Excel, which of the following is true of a chart legend?​

​It identifies each data series in a chart.

Identify a true statement about data source of pie charts.​

​It should not include the row or column totals.

Column and bar charts differ from pie charts in that bar charts:​

​apply to a wider range of data.

In Microsoft Excel 2016, charts are used to:​

​illustrate numbers.

data label

text for an individual data marker

plot area

the part of the chart that contains the graphical representation of the data series

scale

the range of values along an axis

data source

the range that contains the data to display in a chart

category values

the row or column of a data source that provides the descriptive labels for each data series

What is a combination chart? Describe how to create a combination chart.

A combination chart combines two or more chart types in a single graph, such as a column chart and a line chart. To create a combination chart, first select the data series in an existing chart that you want to appear as another chart type. Then, on the Chart Tools Design tab, in the Type group, click the Change Chart Type button, click the chart type you want to apply to the selected series, and then click OK.

What are data bars?

A data bar is conditional formatting that adds a horizontal bar to the background of a cell containing a number.

If a data series contains values divided into 10 categories, would this data be better displayed as a pie chart or a column chart? Why?

A data series that contains values divided into 10 categories would be better displayed as a column chart because a pie chart is more effective with six or fewer categories.

What is the difference between a data source and a data series?

A data source is the range that contains the data being displayed in a chart. A data source is a collection of one or more data series, which is a range of values that is plotted as a single unit on a chart.

What are sparklines? Describe the three types of sparklines.

A sparkline is a graph that is displayed within a cell. The three types of sparklines are line sparklines, column sparklines, and win/loss sparklines.

Which of the following is a method to move a chart from one worksheet to another in a Microsoft Excel workbook?​

Cutting and pasting a chart to a new location in the workbook

How do data bars differ from sparklines?

Data bars differ from sparklines in that the bars are always placed in the cells containing the value they represent and each cell represents only a single bar from the bar chart. By contrast, a column sparkline can be inserted anywhere within the workbook and can represent data from several rows or columns.

Which of the following is a true statement about chart elements in Microsoft Excel?​

Excel allows you to edit or replace the default chart title.

Which of the following describes a pie chart?​

It compares relative values of different categories to the whole.

Which of the following describes a line chart?​

It compares values from different categories.

Which of the following is true of a plot area in the chart?​

It decreases its size to make room for the chart title when the chart area is small.

What is the difference between the chart area and the plot area?

The chart area contains the chart and all of the other chart elements. The plot area is the part of the chart that contains the graphical representation of the data series.

sparkline

a graph that is displayed entirely within a cell

In Microsoft Excel charts, which of the following is a function of leader lines?​

They connect each data label to its corresponding data marker.

Which of the following is a difference between column charts and pie charts?​

Unlike pie charts, column charts can represent more than one data series.

bar chart

a column chart that is turned on its side so that the length of each bar is based on its value

chart title

a descriptive label or name for the chart

exploded pie chart

a pie-chart where one slice is moved away from the pie

legend

a rectangular area that identifies the data markers associated with the data series

data series

a set of values represented in a chart

category

a set of values that represent data for one item in a chart

chart sheet

a sheet in a workbook that contains only a chart and no worksheet cells

chart style

a style that formats an entire chart at one time

gridlines

in a chart, lines that extend the values of the major or minor units across the plot area of a chart

In a pie chart, each pie slice always represents _____.​

one data series value

data series values

the actual numbers plotted on a chart

chart area

the area that contains the chart and all of the other chart elements

horizontal (category) axis

the axis along the bottom of the chart that shows the category values from each data series

vertical (value) axis

the axis along the side of the chart that shows the range of values from all of the data series plotted on the chart


Ensembles d'études connexes

Module 9 Knowledge Check (second attempt)

View Set

Patofiza practicni, pitanja moodle

View Set

Macroeconomics Study Guide (Ch. 9,10,12,13)

View Set

FCE : Keyword Transformation Use of English

View Set

MicroEconomics chapter 7 Study Guide

View Set

Quiz Chapter 12 - Nervous Tissue

View Set