DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
In order to change the orientation of the chart data and make it more understandable, what button can you use?
|
|
switch rows/columns
|
|
|
switch lanes/rows
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -If you are not happy with the way your worksheet rows and columns are plotted by default, you can easily swap the vertical and horizontal axes. To do this, select the chart, go to the Design tab and click the Switch Row/Column button.
Detailed explanation-2: -Click anywhere in the chart that contains the data series that you want to plot on different axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Switch Row/Column.
Detailed explanation-3: -You can do this by clicking the Switch Row/Column button under the Chart Tools > Design tab OR by right clicking on your graph, choosing Select Data, and then clicking Switch Row/Column.
There is 1 question to complete.