FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What part of your chart is used to explain what the colors in a chart mean?
A
Columns
B
Plot area
C
Legend
D
Title
Explanation: 

Detailed explanation-1: -A legend in Excel matches data within a table or chart with what it represents, which can help prevent confusion when readers analyze a chart or graph. You can use a legend to show the same data differently, or it can clarify what the various axes, colors or labels on a chart mean.

Detailed explanation-2: -The legend of a graph reflects the data displayed in the graph’s Y-axis, also called the graph series. This is the data that comes from the columns of the corresponding grid report, and usually represents metrics. A graph legend generally appears as a box to the right or left of your graph.

Detailed explanation-3: -Most charts use some kind of a legend to help readers understand the charted data. Whenever you create a chart in Excel, a legend for the chart is automatically generated at the same time. A chart can be missing a legend if it has been manually removed from the chart, but you can retrieve the missing legend.

Detailed explanation-4: -Legend. The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different salespeople in the chart.

Detailed explanation-5: -A chart’s legend shows what kind of data is represented in the chart. By default, the text that appears in the legend is taken from the chart’s data range.

There is 1 question to complete.