Which one of the following can be updated automatically when changing the work sheet data?
Chart
Filter data
Shapes
None of these
Which option allows for placing the chart on a new chart sheet?
New chart sheet
New sheet
New location
As new sheet
Which arrow indicates that the ‘Auto Filter is ON’?
Up arrow
Drop down arrow
Bottom up arrow
Bottom arrow
Which option enables to select a new set of data to be graphed?
Data set
source data
Data series
Data range
Which of the following is not a part of a chart?
Plot area
Chart title
Grid data
Chart legend
