USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Right-click the Bar Chart and select rotate from the menu list. This will turn the bar chart vertically to display as columns.
|
|
|
Select the chart, click on the Design tab and then select the Switch Row/Column button to rotate the data so that it displays as columns.
|
|
|
Select the chart, click on the Design tab and then select the Change Chart Type button and select the Column Chart from the list.
|
|
|
None of the options listed above are correct.
|
Detailed explanation-1: -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.
Detailed explanation-2: -Select your data and then click on the Insert Tab, Column Chart, 2-D Column. Note: Make sure your labels are formatted as text or they will be added to the chart as a third set of bars. Next, right click on one of the data series and select Change Series Chart Type. Change the type to Line.
Detailed explanation-3: -In the chart, select a data series. For example, in a column chart, click a column, and all the columns of that data series become selected. Select Chart Design > Select Data. In the Select Data Source dialog box, next to Legend entries (Series), use the up and down arrows to move the series up or down in the list.
Detailed explanation-4: -To edit the data selection of a chart, right click the chart and select the Select Data option-or select the chart, go to the Design tab, and click the Select Data button from the left side of the ribbon menu.