Formulas in MS-Excel always start with which of the following symbols?
Show answer & explanation
Correct answer: D
Explanation
The correct answer is option 4 i.e. =.
In Microsoft Excel, formulas always start with the equal sign (=). This symbol is essential because it signals to Excel that the following text is a formula or a function, not just data. The equal sign tells Excel to perform a calculation or operation based on the instructions given after it.
For example:
- If you want to add two numbers in cells A1 and B1, you would enter the formula =A1+B1 in another cell. Excel would then calculate the sum of these two cells and display the result.
Using the equal sign is crucial for Excel to recognize and process the data correctly. Without it, Excel will treat the input as plain text or a label. Similarly, after the equal sign, you can use mathematical operators (like +, -, *, /) or functions (like SUM, AVERAGE, etc.) to perform various calculations.