Which of the following is not a function in Excel?

In Microsoft Excel, there is no built-in function named ADDITION(). This option does not exist and will result in a #NAME? error if used in a formula.
Here’s why the others are valid:


SUM() – A fundamental Excel function to add up... Read More

1 MS OFFICE MCQS

Which of the following is not a function in Excel?

  • SUM()
  • ADDITION()
  • AVERAGE()
  • IF()
Correct Answer: B. ADDITION()

Detailed Explanation

In Microsoft Excel, there is no built-in function named ADDITION(). This option does not exist and will result in a #NAME? error if used in a formula.


Here’s why the others are valid:




  • SUM() – A fundamental Excel function to add up values from a range or individual cells AVERAGE() – Used to calculate the average (arithmetic mean) of numbers in a specified range




  • IF() – A core logical function that returns one value if a condition is true and another if it is false .




Since ADDITION() does not exist as a function in Excel, it's the only option that is not valid

Discussion

No comments yet. Be the first to share your thoughts!

Leave a Comment

More from MS Office MCQs