Exam 13: Excel: Customize, Analyze, and Summarize Query Data

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

The Chart Tools Layout tab enables you to enhance your charts by selecting specific chart elements, inserting objects, displaying or removing chart elements, customizing the axes, formatting the background, and including analysis.

(True/False)
4.8/5
(41)

A ________ label is text that describes a collection of data points in a chart.

(Short Answer)
5.0/5
(36)

The value axis

(Multiple Choice)
4.9/5
(33)

Excel creates charts on the same worksheet as the original data set, but you can move the chart to its own chart sheet in the workbook.

(True/False)
4.8/5
(41)

A column chart

(Multiple Choice)
4.9/5
(33)

A data point

(Multiple Choice)
4.9/5
(32)

If you embedded a chart on the same sheet as the data source, you cannot print the chart only.

(True/False)
4.9/5
(39)

Axes titles are labels that describe the category and value axes. If the names on the category axis are not self-explanatory, you can add a label to describe it.

(True/False)
4.8/5
(24)

A gridline is a horizontal or vertical line that extends from the horizontal or vertical axis through the plot area.

(True/False)
4.8/5
(27)

A data label

(Multiple Choice)
4.9/5
(32)

A data point is a letter or word that describes a single value on a chart.

(True/False)
4.9/5
(34)

A chart is composed of only the chart area and labels. You cannot change it, only re-do it after it is created.

(True/False)
4.8/5
(41)

Preview the chart in ________ view before you print to ensure a balanced printout.

(Short Answer)
4.8/5
(31)

The X-axis

(Multiple Choice)
4.9/5
(34)

An area chart

(Multiple Choice)
4.9/5
(37)

After creating a chart you can change the chart type by using Format tab / Change Chart Type button.

(True/False)
4.9/5
(35)

A bar chart

(Multiple Choice)
4.8/5
(28)

A clustered column chart

(Multiple Choice)
4.9/5
(35)

Before creating the chart, you must first define the starting, incremental, and stopping values that display on the value axis.

(True/False)
4.9/5
(41)

A surface chart

(Multiple Choice)
4.7/5
(34)
Showing 61 - 80 of 90
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)