Selected MCQ

Current Question
In Excel, the error message “#Value!” typically means:
  • A. Invalid Input
  • B. Calculation Error
  • C. Data Corruption
  • D. Low Memory
Correct Answer: B
Explanation:
#VALUE! indicates a problem with the data type used in the formula.
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
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 4
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.
Related Question 5
In MS Excel, to delete duplicate values, which menu is used?
  • A. File
  • B. Data
  • C. Edit
  • D. View
Correct Answer: B
Explanation:
The Remove Duplicates command is located under the Data tab.