Selected MCQ

Current Question
Numeric key is a ____ key.
  • A. Primary
  • B. Secondary
  • C. Normal
  • D. None of these
Correct Answer: A
Explanation:
Numeric keys are primary keys on the keyboard.
Related Question 1
In MS Access, which of the following data types allows alphanumeric characters and special symbols?
  • A. Text
  • B. Memo
  • C. Auto number
  • D. None of these
Correct Answer: A
Explanation:
The Text data type (Short Text) supports alphanumeric characters and special symbols up to 255 characters.
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
If a formula references a cell that contains text instead of a numerical value, what error does Excel display?
  • A. #NUM!
  • B. #VALUE!
  • C. #REF!
  • D. #DIV/0!
Correct Answer: B
Explanation:
#VALUE! An error appears when the formula expects numbers but receives text.
Related Question 4
In MS Excel, if a numeric value starts with ____ then this value is treated as a label.
  • A. Hash
  • B. Equal Sign
  • C. Apostrophe
  • D. Title
Correct Answer: C
Explanation:
Prefixing with an apostrophe (') forces Excel to treat the entry as text/label.