DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
How do you change the orientation of the rows and columns in a chart?
|
|
Go to the Design tab, then Switch Row/Column button.
|
|
|
Go to the Insert tab, then Switch Row/Column button.
|
|
|
Go to the Page Layout tab, then Effects.
|
|
|
Go to the Format tab, then Quick Styles.
|
Explanation:
Detailed explanation-1: -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-2: -Select the worksheet with your chart for printing. Go to the Page Layout tab and click on the arrow under the Orientation icon. Pick the Landscape option.
Detailed explanation-3: -Switch the rows and columns in the chart, so the data points are grouped into data series by PO Month. Click the Chart Tools Design tab, in the Data group, click the Switch Row/Column button. Insert a 3-D pie chart based on the selected data. Click the Insert tab.
There is 1 question to complete.