Excel Ch. 3 Creating and Editing Charts

The chart feature that allows you to specify which data is shown and which is hidden is the: a. filter b. select data source tool c. range detector d. show/hide button e. data sorter

a. filter

To apply changes to your chart's shape fill, shape outline, or shape effects separately, use: a. format tab b. element pane c. workart d. chart type e. character tab

a. format tab

In a histogram chart, the category labels are shown: a. on the horizontal axis b. on the vertical axis c. in the chart legend d. in the chart title e. on both axes

a. on the horizontal axis

A miniature chart that is displayed in a cell or cell range next to your data to illustrate a pattern or trend is called a/an: a. sparkline b. forecast point c. preidctor d. minichart e. conditional chart

a. sparkline

The type of chart that shows percentages of a whole and has no axes is: a. a line graph b. a pie chart c. a percentage chart d. a bar graph e. a sheet chart

b. a pie chart

When you want to visually represent the numeric data in a worksheet, excel helps you create an appropriate: a. report b. chart c. timeline d. data layout e. slide

b. chart

The background color for a chart element is called the: a. shading b. shape fill c. screen d. background e. design

b. shape fill

An excel chart that is displayed on its own sheet in the workbook is called: a. a standalone b. a graphic element c. a chart sheet d. a diagram e. a schematic

c. a chart sheet

The text label that describes each data series in a chart is called the: a. chart object b. field name c. category label d. selectable component e. source label

c. category label

A variegated blend of colors in a chart element is called a: a. shadow b. tint c. gradient d. blended fill e. saturation

c. gradient

This chart type displays the frequency of multiple data series relative to a center point with an axis for each category: a. round b. target c. radar d. combo e. surface

c. radar

The excel chat element that displays averages in your data and can be used to forecast data by plotting future approximate averages is the: a. legend b. tick mark c. trendline d. gridline e. chart analyzer

c. trendline

A chart that included two chart types such as a line chart and a column chart is referred to as a: a. mixed display b. dual data display c. radar chart d. combination chart e. custom chart

d. combination chart

When you change the preset group of elements in an excel chart, you are changing: a. the diagram b. the scheme c. the selections d. the layout e. the orientation

d. the layout

Chart styles are based on: a. wordart b. defaults c. orientation d. number of columns e. workbook themes

e. workbook themes