Selected MCQ

Current Question
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 1
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 2
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.
Related Question 3
Which is used for arranging data in ascending and descending order in MS Excel?
  • A. Data, Order
  • B. Data, all
  • C. Data, Sort
  • D. None of these
Correct Answer: C
Explanation:
The Sort command arranges data in ascending or descending order.
Related Question 4
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 5
Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument?
  • A. COUNT
  • B. AVERAGE
  • C. SUM
  • D. MAX
Correct Answer: A
Explanation:
COUNT tallies only numeric cells.