Selected MCQ

Current Question
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.
Related Question 1
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.
Related Question 2
Which key is used to edit the selected cell in Excel?
  • A. F4
  • B. F10
  • C. F2
  • D. Edit
Correct Answer: C
Explanation:
The F2 key activates edit mode for the selected cell in Excel.
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 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.