Dear Friends,

I apologise for not updating the group from last week due to some medical issue at home.

Thank you

In Microsoft Excel, a range is a collection of cells. A range can be 2 or more cells and those cells don't necessarily have to be adjacent to each other.

*IMPORTANCE OF MS EXCEL IN OUR DAILY AND BUSINESS LIVES:*

1. Easy Arithmetic Solutions.
2. Formatting Options.
3. Charts for Analysis.
4. Bring all the data in one place.
5. Human Resource Planning.
6. Multiple formulas.
7. Multiple functions.

Question:-
What is Formula in Excel?
Answer:-
A formula is an expression which calculates the value of a cell.
For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1.

Question:-
How to enter the formula?

Answer:-
Execute the following steps to enter a formula:-

1. Select a cell.

2. To let Excel know that you want to enter a formula, type an equal sign (=).

3. For example, type the formula A1+A2.

4. Change the value of cell A1 to 3. Excel automatically recalculates the value of cell A3. This is one of Excel's most powerful feature.

Question:-
How to Edit a Formula?

Answer:-
When you select a cell, Excel shows the value or formula of the cell in the formula bar.

Step 1
To edit a formula, click in the formula bar and change the formula.

Step 2
Press Enter

Dear Friends,
In continuation of the series which we have started to discuss the basics of Excel. Please see above steps to enter and edit the formula with picture examples.
Please go through the steps and ask your doubts.

Thanks and regards

Dear Friends,
Please share this chennal with your friends and family members so that they can also learn new things and get benefit.

Please share your valuable suggestions which help us to improve our chennal.

Thanks and regards