Selected MCQ

Current Question
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 1
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 2
Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as ____.
  • A. Decoration
  • B. Data appearance
  • C. Functions
  • D. Charting
Correct Answer: D
Explanation:
The feature is called charting or chart creation.
Related Question 3
In MS Excel, a data series is related to ____.
  • A. Collection of Series data
  • B. Collection of formulas
  • C. Collection of metadata
  • D. All of these
Correct Answer: A
Explanation:
A data series is a collection of related data points plotted on a chart.
Related Question 4
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 5
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.