Excel Lesson 8
The chart element called ______ is a grid that displays the data plotted in the chart.
DATA TABLE
T or F? All chart types are interchangeable. For example, data suitable for a pie chart will also always work asa scatter chart.
FALSE
T or F? You can delete a selected chart by pressing the F2 key.
FALSE
T or F? A PIE chart is similar to the column chart, but columns are replaced by points connected by a line.
FALSE - LINE
T or F? A SCATTER chart shows the relationship of a part to a whole.
FALSE - PIE
T or F? A BAR chart, sometimes called an XY chart, shows the relationship between 2 categories of data.
FALSE - SCATTER
A chart _____ specifies which elements are included in a chart and where they are placed.
LAYOUT
A _____ chart shows the relationship of a part to a whole.
PIE
The chart element called _____ is the graphical representation of all of the data series.
PLOT AREA
You can rename a chart sheet like any other worksheet. Right-click its sheet tab, and then click _____ on the shortcut menu
RENAME
A selected chart element is surrounded by a ______.
SELECTION BOX
You switch between a chart sheet and a worksheet by clicking the appropriate _____.
SHEET TAB
Each part is shown as a ______ of the pie chart.
SLICE
A chart, whether embedded in a worksheet or on a chart sheet, is considered a part of a _____.
WORKBOOK.
What specifies which elements are included in a chart and where they are placed?
CHART LAYOUT
What is a separate sheet in the workbook that store a chart?
CHART SHEET
You can choose to move the chart to a _______, which is a separate sheet in the workbook that stores a chart.
CHART SHEET
What formats the chart based on the colors, fonts, and effects associates with the workbook's theme?
CHART STYLE
A ______ chart uses bars of varying heights to illustrate values in a worksheet.
COLUMN
The quickest way to select a chart element is to ______.
Click it with the pointer
What is the entire chart and all other elements?
CHART AREA
A ______ is a graphical representation of data.
CHART
What is graphical representation of data?
CHART
T or F? Embedded charts are useful when you want to print a chart next to the data the chart illustration.
TRUE
T or F? When you select the data source for a chart, you should also include the text you want to use a labels in the chart.
TRUE
T or F? You can keep a chart's height and width in the same proportion by pressing the SHIFT key as you drag a corner and sizing handle.
TRUE
T or F? You can quickly change the look of any chart you created by applying a layout and a style.
TRUE
