Question

How can you write a formula in Excel? Write a valid formula.

Answer 1

Explanation:

Select a cell.

Type the equal sign =. Note: Formulas in Excel always begin with the equal sign.

Select a cell or type its address in the selected cell.

Enter an operator. ...

Select the next cell, or type its address in the selected cell.

Press Enter.

Answer 2

Formulas are useful in building the relationship between two or more cells. They possess cell coordinates that can be used in the formulas.

Explanation:

The formula should begin with an ‘=’ sign. Otherwise, it will be treated as ordinary text entry. Here, let us look at the steps to perform addition,

• Move the cursor to A1 (cell A1) and type 1.
• Move the cursor to A2 and type 1.
• Move to A3 and type formula =A1+A2

Here, the contents of A1 and A2 will get added and produced the result in A3. Here ‘=A1+A2’ is the formula.