DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
The ____ button allows you to exclude some data from a chart.
|
|
Select Chart
|
|
|
Select Area
|
|
|
Select Data
|
|
|
Select Text
|
|
|
None
|
Explanation:
Detailed explanation-1: -If you want to exclude some data from a chart after it has been created, you can do so by selecting the data that you want to exclude and then deleting it. This will remove the data from the chart, but it will still be present in the worksheet.
Detailed explanation-2: -On the Insert tab, select the chart type you want. On the Chart Design tab, select Select Data. Click in the Chart data range box, and then select the data in your worksheet.
Detailed explanation-3: -If you don’t want any title in your Excel graph, you can delete it in two ways: On the Design tab, click Add Chart Element > Chart Title > None. On the chart, right-click the chart title, and select Delete in the context menu.
There is 1 question to complete.