DATABASE FUNDAMENTALS
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: -Under Chart Tools, on the Design tab, in the Data group, click Edit Data. Microsoft Excel opens in a new window and displays the worksheet for the selected chart. In the Excel worksheet, click the cell that contains the title or the data that you want to change, and then enter the new information.
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.