Which option enables to select a new set of data to be graphed?
Data set
source data
Data series
Data range
Which option allows for placing the chart on a new chart sheet?
New chart sheet
New sheet
New location
As new sheet
What is the proper way to filter data in MS Excel?
view→ filter→ advanced filter
Data → filter→ auto filter option
View → filter→ auto filter option
Insert → filter→ advanced filter option
Which arrow indicates that the ‘Auto Filter is ON’?
Up arrow
Drop down arrow
Bottom up arrow
Bottom arrow
Which of the following is not a part of a chart?
Plot area
Chart title
Grid data
Chart legend
Which tab shows a preview of the chart selected?
Data range tab
Data series tab
Data standard
Data labels