Selected MCQ

Current Question
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 1
Which function is used to find the related data in MS Excel?
  • A. VLOOKUP
  • B. FLOOKUP
  • C. RLOOKUP
  • D. HLOOKUP
Correct Answer: A
Explanation:
VLOOKUP searches vertically for related data.
Related Question 2
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 3
Which Excel tool allows you to set specific conditions for data entry, ensuring accuracy and consistency in your analysis?
  • A. Scenario Manager
  • B. Goal Seek
  • C. Data Validation
  • D. Pivot Table
Correct Answer: C
Explanation:
Data Validation enforces rules on data entry.
Related Question 4
In Excel, you can sort data in ____.
  • A. Ascending order
  • B. Descending order
  • C. Both A & B
  • D. None of these
Correct Answer: C
Explanation:
Excel supports both ascending and descending sorts.
Related Question 5
In MS Excel data can be arranged by ____.
  • A. Data Menu
  • B. Data Sort
  • C. Data View
  • D. None of these
Correct Answer: B
Explanation:
Data Sort is the feature for rearranging data.