Question

A valid formula in Excel begins with: (i) + (ii) – (iii) # (iv) =

Answer 1

Answer:

= sign is the right answer

Answer 2

A valid formula in Excel begins with ‘=’.

Explanation:

Formulas in Excel are used for performing calculations. They are referred as mathematical equations, used for establishing relationship between two or more cells.

Here the formula should begin with ‘=’ sign. Otherwise, it will be treated as normal text entry.

Whenever a cell value is changed it automatically recalculates the values and displays the result in that respective cell.

Usually, the formula contains the coordinates of the cell as operators along with functions.