Question

In MS-Excel, which of the following formulas is not entered correctly?

• A. B10+14
• B. 70+50
• C. \(=B10*B1\)
• D. \(=10+50\)

Hint:

Exam Tip:
In Excel:

• All formulas must start with \(=\).
• Examples: \(=A1+B1\), \(=SUM(A1:A10)\).

Answer 1

The Correct Option is A

Step 1: Understanding the Concept:
In MS-Excel, every formula must start with an equals sign (\(=\)).
Without the equals sign, Excel treats the entry as text.

Step 2: Analyzing the Options:

• (A) B10+14: Missing the equals sign. Not a correct formula.
• (B) 70+50: Missing the equals sign. Not a correct formula.
• (C) \(=B10*B1\): Starts with \(=\), correct.
• (D) \(=10+50\): Starts with \(=\), correct. Both (A) and (B) are not entered correctly.
But the question asks for which one is NOT entered correctly.
If there is only one correct answer, then (A) is the one that is clearly a cell reference without \(=\).
Option (B) is also missing \(=\), but it is a simple arithmetic expression.
Typically, in Excel, any calculation must start with \(=\).
So, both (A) and (B) are incorrect.
However, if we have to choose one, (A) is more clearly wrong because it contains a cell reference.
I'll proceed with option (A).

Step 3: Final Answer:
Therefore, option (A) is correct.