In MS Excel, which of the following formulas is INVALID?

Correct option is C

The correct answer is =SUM(A1;A10) because it uses a semicolon (;) instead of a colon (:) to define a range of cells. In MS Excel, a colon (:) is used to specify a continuous range, such as A1:A10. The semicolon is generally used as a separator for arguments in certain regional settings, but it cannot define a range between two cells. Therefore, this formula becomes invalid in standard Excel syntax. The other formulas correctly follow Excel’s syntax rules and perform valid operations.

Important Key Points:

1. Colon (:) is used to define a range of cells in Excel.
2. SUM, AVERAGE, and MAX are built-in functions used for calculations.
3. A valid formula must follow proper syntax rules, including correct separators.
4. Incorrect use of symbols leads to formula errors in Excel.

Knowledge Booster :

1. (a) =SUM(A1:A10) is correct because it properly uses colon to define a range.
2. (b) =AVERAGE(B1:B5) is valid as it correctly calculates the average of a range.
3. (d) =MAX(C1:C10) is correct and returns the maximum value from the range.
4. (e) None of the above is incorrect because option (c) is clearly invalid.