DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following explanations are reasons to switch the rows and columns on a chart?
|
|
To change to a different chart type
|
|
|
To check if you prefer to orient the chart differently or to correct a pie chart that is only displaying a category name
|
|
|
To move the chart to a different worksheet
|
|
|
To correct a column chart only rendering one column
|
|
|
None
|
Explanation:
Detailed explanation-1: -For example, if rows of data are displayed on the horizontal (category) axis, but you want them to be displayed on the vertical (value) axis instead, you can switch rows to columns so that the data is displayed in the chart the way that you want.
Detailed explanation-2: -Line charts are useful for showing trends over time and comparing many data series.
Detailed explanation-3: -On the Design tab, in the Type group, click Change Chart Type. In the Change Chart Type dialog box, click a chart type that you want to use. The first box shows a list of chart type categories, and the second box shows the available chart types for each chart type category.
There is 1 question to complete.