Selected MCQ

Current Question
Which command is used to add data in Excel?
  • A. ADD
  • B. COUNT
  • C. SUM
  • D. None of these
Correct Answer: C
Explanation:
The SUM function is the standard command to add numerical data.
Related Question 1
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 2
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 3
Which is used for fractions, so data in MS-Excel doesn’t read it as a date?
  • A. S
  • B. @
  • C. /
  • D. Space
Correct Answer: D
Explanation:
Prefixing a fraction with a space prevents Excel from interpreting it as a date.
Related Question 4
In MS Excel, which bar is used for formula and data writing?
  • A. Menu bar
  • B. Title bar
  • C. Formula bar
  • D. None of these
Correct Answer: C
Explanation:
The Formula Bar is where you view and edit formulas and cell data.
Related Question 5
Which of the following methods cannot be used to enter data in an MS Excel cell?
  • A. Pressing the Esc key
  • B. Clicking the formula bar
  • C. Pressing an arrow key
  • D. Pressing the Tab key
Correct Answer: A
Explanation:
Esc cancels editing; the other keys confirm or move after entry.