Question

Also explain basic rules for applying a formula in MS excel

Answer 1

Answer:

Overview of formulas in Excel

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. For example, – for subtraction.
• Select the next cell, or type its address in the selected cell.
• Press Enter.

Answer 2

Applying formulas in excel spreadsheet,is one of it's most useful and powerful features.

• Microsoft Excel follows very simple rules for applying formulas on the values in the cells. All formulas always start with an '=' sign. This sign represents that a formula is being introduced in the selected cell.

• Suppose, the formula is for addition of values in cells A1 and A2, then the formula may be written as - = A1 + A2. After entering the formula, press enter and excel shall compute the result in the selected cell.

• The formulas thus written, can also be viewed of the formula bar. In fact any changes required in the formula, can subsequently be made from the formula bar itself.

• While computing complex expressions, the formulas are evaluated in a certain order called as Operator Precedence.Any part of the formula which is within brackets is evaluated first followed by multiplication or division and finally, rest of the formula is evaluated.

To know more about formulas in MS Excel, visit:

https://brainly.in/question/10381268