Status Bar
The status bar in Excel can do the math for you.
1. Select the range A1:A3.

2. Look at the status bar to see the average, count and sum of these cells.

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