Selected MCQ

Current Question
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 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
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
Which type of chart is for categorical data ____.
  • A. Pie chart
  • B. Histogram
  • C. Maps
  • D. Vertical bar
Correct Answer: D
Explanation:
Vertical bar (column) charts are best suited for comparing categorical data.
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
Which of these terms refers to the sharpness or clarity of an image?
  • A. Width
  • B. Resolution
  • C. Dot pitch
  • D. Depth
Correct Answer: B
Explanation:
Resolution determines the sharpness and clarity of an image.