Correct option is A
In Microsoft Excel, formulas always begin with an
equals sign (=). This indicates to Excel that the input is a formula and not plain text or a value.
Example: To calculate the sum of two cells (A1 and B1), you would write: =A1 + B1
Important Key Points:
1. The
equals sign (=) is mandatory to initiate formulas in Excel.
2. Excel formulas can include functions, operators, cell references, and constants.
3. Formulas are evaluated dynamically, updating results when referenced cells change.
Knowledge Booster:
1. Typing = immediately activates formula mode in the active cell.
2. Other symbols like + or - are sometimes used but automatically convert to = when starting a formula.
3. The formula bar displays the full formula for the selected cell.