Question

The formula in Lotus 1-2-3 (Spread sheets) is preceded with symbol

• A. F
• B. *
• C. (.)
• D. =

Hint:

Spreadsheet Formula Syntax: Formulas in spreadsheets begin with ‘=‘ (or ‘+‘ in classic Lotus 1-2-3).

Answer 1

The Correct Option is D

Step 1: Understanding the Concept:
Spreadsheet software syntax and mathematical formula prefixes: in spreadsheet applications (Lotus 1-2-3, Excel), formulas must begin with a formula identifier symbol (such as ‘=‘, ‘+‘, ‘-‘, or ‘@‘).
Key Formula or Approach:
\[ \text{Spreadsheet Formula Syntax: } \mathbf{=} \text{SUM(A1..A10)} \quad \text{or } \mathbf{+} \text{A1 + B1} \quad [\text{Options give } \mathbf{=}] \]

Step 2: Detailed Explanation:
In computer applications, dairy data processing, and spreadsheet software history (Lotus 1-2-3 MS Excel):
- In spreadsheet software, text entries (labels) and numeric values are entered directly into cells.
- When entering a mathematical calculation or formula, the user must prefix the expression with an operator symbol so the spreadsheet parser interprets it as an executable formula rather than text:
1. In Lotus 1-2-3, formulas could begin with ‘+‘, ‘=‘, or built-in function prefix ‘@‘ (e.g., ‘@SUM‘).
2. Among the given options (F, *, (.), =), the formula is preceded with the symbol ‘=‘ (D).

Step 3: Final Answer:
Hence, the formula is preceded with symbol '=', matching option (D).