###
__Read Microsoft Excel Formulas in English__

Microsoft Excel Formulas |

Hello friends, welcome to this series to know

**about MS office**. Today, we will talk

**about the formulas of Microsoft Excel**. Before that we had

**MS Excel**and had to know about some of its basics. If you have to know this, then you have to click on this link. Let's

**know what Microsoft Excel Formulas**are and

**how it works.**

### MS Excel Formulas

Friends, as you all know,

**MS Excel is a software**to create an**electronic spreadsheet**that contains**various types of data**such as**records, salary info,**or even more**account books**etc.
But on this data we sometimes get some operations like

**adding, subtracting, multiplying, extracting the average**and sometimes we have a**lot of data.**
Manually can not perform all these operations.

For such things,

**Microsoft Excel offers**us**some formulas or functions,**so that we can do many such big things in jokes.### How do Excel use Formulas?

It is very easy to

**use formulas in Excel**, for that you first have to select an empty cell that contains the**output of that formula**.
Do not type

**formula in the formula bar**in the cell itself. Every**formula starts with equals '=' sign**.
After writing

**formula and giving value,**you have to press enter for the output.
Values or

**inputs in formula**are always given inside the parenthesis '()' i.e. small brackets.**Read More....**

**Recycle Bin for Android**

###
__Microsoft Excel Formulas in English__

### SUM

**SUM formula**is used to add two or more digits to

**SUM**. Whenever we need to add a line of elements or elements in a

**worksheet**, we can use this

**function or formula of excel**. This is a

**basic formula**that we need to know. It takes us a lot of time if we add elements given in the cell without it.

**Syntax**

**In Excel we can use SUM in two ways.**

1.

**Using the first AutoSum**
For this, first of all, you have to select an empty cell
under the

**row to be Sum.**
Now you have to click on

**FORMULAS in the Menu bar,**after which you have to**click on the AutoSum option**appearing in the**Ribbon**. Your entire row will be**sum assured and Auto fill**in selected sell.
2.

**Using the second = sum (elements) formula**.
If you have to sum the selected cells then you have to

**use formula**in this way.
First, select an empty cell.

After that, in the

**formula bar**, by typing =**sum ()**, the**parenthesis '()'**contains the name of the cell whose sum is to be entered.
Like -

**= sum (c1, d2, c3, a2)**
The name of the cell is something like the 2 cell of the C
column and the name of the cell c2.

If you have problems understanding the name of the cell then
you can select the cell and name it in the name box in the left side of the

**formula bar.**
If you want to sum the whole row, then you

**use the formula**to do something like this.
First, select an empty cell.

After that, type the

**sum of the cell**in the parenthesis '()' in the**formula bar**and then type the name of the cell followed by the colon ':' followed by the name of the last cell and then press enter.
Like - = sum (e2: e7)

**Read More...**

#
**How to Control Laptop or Desktop from Mobile?**

**Example**

**Example of AutoSum**

First, select an empty cell at the bottom of the row.

After that, select the

**FORMULAS**from the menu.
Then select

**AutoSum from the ribbon.**Microsoft Excel Formulas |

Example for selected elements or cells

Firstly select an empty cell.

Then put the

**formula into the formula bar.**
=

**sum**(e1, e2, e3)
After that, insert cell names in parenthesis

Then press enter

**Example for whole row**

Firstly select an empty cell.

Then put the

**formula into the formula bar**.
= sum (e1: e5)

Microsoft Excel Formulas |

Then press enter.

### AVERAGE

Using this formula, we can extract

**average of any selected numbers in excel**. Let's know about it.**Syntax**

The

**average**can also be removed from two ways.
1.

**Remove the First Auto Average**
For this you have to select one cell at the bottom of the row
below (which is to be removed).

After that, select the

**FORMULAS from the menu bar.**
After that, selecting

**AutoSum**in the**ribbon**is to select the**average**.
The

**average of your row**will go out.
2.

**With the help of second = average () formula**
To remove the

**average of selected elements**or cells.
First, select an empty cell.

Then type =

**average ()**in the formula bar and write between the parenthesis '()' in the name of all the cells whose**average**is to be removed.
Then press enter.

Get the

**average of the full row**
Select an empty cell.

After that, in the

**formula bar type = average (),**in the parenthesis '()', type the name of the cell before the row, after which the colon ':' is to be set, then there is to write the name of the last cell and then press enter.**Read More...**

**How to Project or Mirror Android Mobile in PC?**

**Example**

**Example of Auto Average**

First, select an empty cell at the bottom of the row.

After that, select the

**FORMULAS**from the menu.
Then select the

**Auto average from the ribbon**.
Example for selected elements or cells

Firstly select an empty cell.

Then put the

**formula into the formula bar.**
=

**sum**(e1, e2, e3)Microsoft Excel Formulas |

After that, insert cell names in parenthesis

Then press enter

Example for whole row

Firstly select an empty cell.

Then put the

**formula into the formula bar.**
=

**average**(e1: e5)Microsoft Excel Formulas |

Then press enter.

###
**PRODUCT**

Using this

**formula**, we can multiply the product of numbers in excel.**Syntax**

**To remove the selected cell product -**

First, select an empty cell.

Then type =

**product ()**in the**formula bar and type**the name of all the cells in the parenthesis '()' that is, between the small brackets that the product wants to remove.
And press the enter button.

To get the product of full row -

Select an empty cell.

After that, type the name of the cell in the parenthesis '()'
in the

**formula bar,**followed by the colon ':' followed by the name of the last cell and then press enter.**Example**

example for selected cell

First of all select an empty cell.

Then put =

**product**(e1, e2, e3, d1) in the**formula bar**.Microsoft Excel Formulas |

Then press enter.

Found product in selected cell

Example for whole row

Firstly, an empty cell is selected.

After that the

**formula entered**into the**formula bar = product****(e1: e5).**Microsoft Excel Formulas |

And after pressing enter, the result is found in the selected
cell.

###
**MIN & MAX**

Using these two

**formulas**, we can find the largest number of the selected numbers or any number of row, that is, the largest and the least number.**Syntax**

min and max use for selected cells -

First, select an empty cell.

Then type = min () in the

**formula bar**and type the name of your cells between the parenthesis. (If to find the minimum value).
Or

Type =

**max ()**in the**formula bar**and type the name of the cell in the parenthesis (if the maximum value is to be found).
Then press enter.

For all the cells of the row max and min -

First, select an empty cell.

Then enter =

**min (value1: value2)**in the**formula bar**(if the minimum value is to be removed).**Or**

=

**max (value1: value2)**(if the**maximum value**is removed)
You can

**use auto min and auto max**in the same way as we did**auto sum and average**.**Read More....**

**What is Aperture? Digital Camera Photography**

**Example**

**Example of min and max**for selected cells

=

**min (e1, e2, d5, d6)**Microsoft Excel Formulas |

Or

=

**max (e1, e2, d5, d6)**Microsoft Excel Formulas |

**Example of min and max**for all cells in row

=

**min (e1: e5)**Microsoft Excel Formulas |

Or

=

**max (e1: e5)**Microsoft Excel Formulas |

### UPPER

This

**formula is not for numbers**like the formulas, but we use this**formula**to do the words or naamo written in**lowercase**to**uppercase**.**syntax**

Its use is quite simple.

For this, first of all have to select an empty cell.

After that, you will have to type your

**formula = upper (cell name)**in the**formula bar**and write the name of the cell in place of the cell name in which your text is present.**Example**

**example upper () formula**

First select a cell.

Then put

**your formula****= upper (a10)**

Microsoft Excel Formulas |

### LEN

Using this

**formula**, you can find out how many words are in the selected text or name.
It is also very simple to use it.

**Syntax**

All you have to do is select an empty cell and write your

**formula = len (text)**in the**formula bar.**Instead of text, write the name of the cell of your text.**Example**

**= len (a1)**

Microsoft Excel Formulas |

So far we have learned a lot

**about Microsoft Excel Formulas (in English)**, we will learn more**about some formulas in more detail**.### Benefits of Excel Formulas

The

**formulas of MS Excel formulas**have helped us a lot because due to them, you do not have to manually or part with the help of**calculator**, to do all this, just by writing a few words, we have to tell the**excel only which calculations**They used to take hours in**calculator**too, we solve them in jokes with the**help of excel formulas.**In addition, there are**many functions or formulas**given in excel, using which we can use large spreadsheet problems Can finish in.**Read More...**

**What is Unicode? Unicode in English**

Friends, in this post, we have learned a lot

**about Microsoft Excel Formulas English,**as well as you have learned**about some basic things of Excel Formula.**
If you liked this post, then do not forget to share it with
your friends. This information may be of any use to them.

And if you have any question or suggestion in your mind, then
by telling me in the comment I will know how good it is.

**Tag**-

**Microsoft excel formulas, ms excel formulas in English, ms excel Microsoft excel, excel in English, learn excel formulas in English, Ms office.**

###
__THANKS__

__THANKS__