USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
You didn’t select all the data when you created the chart
|
|
|
You want to switch the rows and columns in the chart
|
|
|
You want to move the chart to another worksheet
|
|
|
You added data to the worksheet after the chart was created
|
|
|
None
|
Detailed explanation-1: -Advantages of Charts A chart can create a clearer picture of a set of data values than a table with rows of numbers in it, allowing managers to incorporate this understanding into analysis and future planning.
Detailed explanation-2: -It can often be difficult to interpret Excel workbooks that contain a lot of data. Charts allow you to illustrate your workbook data graphically, which makes it easy to visualize comparisons and trends.
Detailed explanation-3: -Data labels make a chart easier to understand because they show details about a data series or its individual data points. For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales.
Detailed explanation-4: -If you have data you want to visualize, make sure you use the right charts. While your data might work with multiple chart types, it’s up to you to select the one that ensures your message is clear and accurate. Remember, data is only valuable if you know how to visualize it and give context.