Which option allows for placing the chart on a new chart sheet?
New chart sheet
New sheet
New location
As new sheet
Which keyboard key allows for creating a chart quickly?
F12
F9
F11
F10
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
What is the 3rd step to create a chart?
Select the ‘Chart type’→ ‘chart sub-type’ →Next
Enter chart title in ‘Chart title box’.
Select data source from the chart
Enter the title for x-axis and y-axis
Which option enables to select a new set of data to be graphed?
Data set
source data
Data series
Data range
Which feature of MS Excel displays only the required data and hides the unwanted data?
Hiding
Concealing
Formatting
Filtering
Which tab shows a preview of the chart selected?
Data range tab
Data series tab
Data standard
Data labels
