Selected MCQ

Current Question
Which of the following is a valid cell address?
  • A. A6
  • B. 6A
  • C. A-6
  • D. None of these
Correct Answer: A
Explanation:
Cell addresses follow the column-letter + row-number format.
Related Question 1
Which of the following is not a valid data type in MS Access?
  • A. Text
  • B. Picture
  • C. Numeric
  • D. Time
Correct Answer: B
Explanation:
“Picture” is not a native data type in MS Access (use OLE Object or Attachment instead).
Related Question 2
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 3
When adding two cells in a spreadsheet, which of the following represents the correct formula?
  • A. #REF?
  • B. = A1 + A2
  • C. (A1 + A2)
  • D. SUM(A1,A2)
Correct Answer: B
Explanation:
=A1+A2 is the correct basic addition formula.
Related Question 4
Which of the following is not the correct method of editing the cell content?
  • A. F2
  • B. Double-press the cell
  • C. Click the formula bar
  • D. Pressing the Alt key
Correct Answer: D
Explanation:
Alt does not activate edit mode for cell content.
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.