FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

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.
A
Select Chart
B
Select Area
C
Select Data
D
Select Text
E
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: -Omit Missing Dates If you want Excel to omit the weekend/missing dates from the axis you can change the axis to a ‘Text Axis’. Now your chart skips the missing dates (see below). I’ve also changed the axis layout so you don’t have to turn your head to read them, which is always a nice touch.

Detailed explanation-3: -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-4: -Click the edge of chart’s frame to highlight the chart. On the Home tab, in the Editing group, click Clear > Clear All. Tip: For faster results, you can also press Delete on your keyboard.

There is 1 question to complete.
Previous
Next