Home 100 Find out the essential sources of Microsoft Excel

Find out the essential sources of Microsoft Excel

78
2
SHARE
Shortcut Keys Microsoft Excel

Many people might know these sources. For those who do not know.



Yoga formula:

The two numbers are also added along with the following formula: –

Structure: = (1 cell number + cell number in cell address) then press enter key.

If two or more numbers are also included then the following formula is added: –

Structure: = Sum (1st cell address: the last cell number) and then press the Enter key.

Substance formula:

To subtract two numbers, we need to subtract with the following formula: –

Structure: = (Number 1 cell address – number 2 cell address) then press enter key.

Multiplication

To multiply between two numbers, we need to multiply with the following formula: –

Structure: = (Number 1 cell address * Second address cell address) then press enter key.

MS-ExcelShare sources:

To divide between two numbers, we need to divide it with the following formula: –

Structure: = (cell number of 1st number / second cell address) then press enter key.

Perspectives (%) Extract formulas:

Structure: = (The number of percentages that will be extracted from the percentens *.

For example: We will remove 10% of the 5,000% of the PENC. Then the formula = 5000 cell address * 10%

Average formula:

Structure: = average (cell number in the 1st cell: the last cell number) and then press the Enter key.

For example: Due to the average of these five numbers we can see 10, 20, 30, 40 and 50, then the formula will be:

= average (cell address of 10: cell address of 50) then press enter key.

Find out the minimum number:

Structure: = min (1st cell address: the last cell number) and then press the Enter key.

The maximum number of sources is out:

Structure: = max (1st cell address: last number of cell address) then press enter key.

Formula to count the numbers:

Structure: = Count (1st number of cell address: cell number of last number) then press enter key.

Thank you for being with

2 COMMENTS

LEAVE A REPLY