Selected MCQ

Current Question
In Excel, the chart wizard ____.
  • A. Can place a chart on a new sheet or on any sheet in the workbook
  • B. Can only place a chart on a new blank worksheet
  • C. Can only be used to create embedded charts
  • D. None of these (but document marks A)
Correct Answer: A
Explanation:
The Chart Wizard (or Insert Chart) allows placing the chart either embedded on the current sheet or on a separate new sheet.
Related Question 1
In MS Excel, chart wizard term data series refers to _____.
  • A. A chart legend
  • B. A collection of chart data markers
  • C. A set of values you plot
  • D. A data label
Correct Answer: B
Explanation:
A data series is the set of related data points (markers) plotted on the chart.
Related Question 2
To insert a chart in MS Excel, which shortcut key is used?
  • A. Alt+F1
  • B. F2
  • C. F3
  • D. F4
Correct Answer: A
Explanation:
Alt+F1 creates a chart from the selected data in Excel.
Related Question 3
What is the first step in creating a Pivot Chart in Excel?
  • A. Insert a Pivot
  • B. Prepare your data
  • C. Customize the chart
  • D. Add fields to the Pivot Table
Correct Answer: B
Explanation:
Data must be prepared (organized in a table) before creating a PivotChart.
Related Question 4
The chart wizard term data categories refers to ____.
  • A. A chart plot area
  • B. A horizontal axis
  • C. The organization of the individual values with a chart’s data series
  • D. The data range that supplies chart data
Correct Answer: B
Explanation:
Data categories in Excel charts refer to the labels along the horizontal (category) axis.
Related Question 5
Which shortcut in Excel is used to create a chart?
  • A. F1
  • B. F5
  • C. F11
  • D. F12
Correct Answer: C
Explanation:
F11 instantly creates a chart from selected data.