Discuss Forum
1. Which one of the following is not a valid function in MS Excel?
- A. ABS
- B. ABS
- C. ABS
- D. ABS
Answer: Option C
Explanation:
All of the mentioned functions (ABS, ROUND, SUMPRODUCT, and AVG) are valid functions in MS Excel. These are commonly used mathematical functions:
- ABS: Returns the absolute value of a number.
- ROUND: Rounds a number to a specified number of decimal places.
- SUMPRODUCT: Calculates the sum of the products of corresponding numbers in multiple arrays.
- AVG: Calculates the average (arithmetic mean) of a range of numbers.
So, "None of these" is the correct option as all of them are valid functions in Excel.
Post your comments here: