In MS-Excel, which formula entered in cell C1 will calculate the sum of A1 and B1 ?
A=A1+B1
BADD(A1, B1)
CSUM(A1:B1)
DBoth 1 and 3
Answer:
A. =A1+B1
Read Explanation:
Formula Syntax in MS-Excel
- In Microsoft Excel, every formula must begin with an equal sign (=). This character notifies the program that the subsequent text should be treated as a calculation rather than plain data.
- To perform a basic addition of cell references, the standard syntax is =A1+B1.
- Excel allows for various arithmetic operators:
- + (Addition)
- - (Subtraction)
- * (Multiplication)
- / (Division)
- ^ (Exponentiation)
- SUM Function: Alternatively, users can use the built-in function =SUM(A1, B1) or =SUM(A1:B1) to achieve the same result. The colon (:) indicates a range, while the comma (,) separates individual arguments.
- Auto-calculate Feature: When cells are selected, the status bar at the bottom of the Excel window automatically displays the Sum, Average, and Count of the selected numerical data without requiring a manual formula.
- Relative Referencing: Using A1+B1 represents relative referencing. If this formula is copied to cell C2, Excel will automatically adjust the formula to =A2+B2.