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

Thank you for your comment! Our admin will review it soon.
No comments yet. Be the first to comment!

Leave a Comment