USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
TRUE
|
|
|
FALSE
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -What is a legend in Excel? 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-3: -Click the chart, and then click the Chart Design tab. Click Add Chart Element > Legend. To change the position of the legend, choose Right, Top, Left, or Bottom. To change the format of the legend, click More Legend Options, and then make the format changes that you want.