Selected MCQ

Current Question
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.
Related Question 1
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 2
Which function calculates the largest value in a set of numbers in Excel?
  • A. Average
  • B. Count
  • C. Minimum
  • D. Maximum
Correct Answer: D
Explanation:
The MAX function returns the largest value in a range.
Related Question 3
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 4
In MS Excel, which function automatically totals a column or row of values?
  • A. Total
  • B. ADD
  • C. SUM
  • D. AVG
Correct Answer: C
Explanation:
SUM is the dedicated function for totaling values.
Related Question 5
The ____ function in Excel returns the highest value in a set of data that you specify.
  • A. MAX
  • B. AVG
  • C. LRG
  • D. None of these
Correct Answer: A
Explanation:
MAX returns the largest value in a range.