Microsoft Excel is a spreadsheet processor capable of performing a wide variety of operations. For example, Excel is subject to any operations with numbers - find the amount, calculate the percentage of a number, etc. To learn how to count in this program, it is enough to know a couple of simple rules.
What is Excel?
For most users, Excel is a program that can work with tables and into which you can put the relevant information in a tabular form. As a rule, few people know all the features of this program, and hardly anyone thought about it a lot. And Excel is capable of performing a large number of operations, and one of them is counting numbers.
Simple operations in MS Excel
A super-modern calculator with a large number of functions and capabilities is built into the Microsoft Excel program.
So, the first thing to know: all calculations in Excel are called formulas and they all begin with an equal sign (=). For example, you need to calculate the amount 5 + 5. If you select any cell and write 5 + 5 inside it, and then press the Enter button, the program will not calculate anything - the cell will simply say "5 + 5". But if you put an equal sign (= 5 + 5) in front of this expression, then Excel will give us the result, that is, 10.
You also need to know the basic arithmetic operators to work in Excel. These are standard functions: addition, subtraction, multiplication, and division. Excel also offers exponentiation and percentage. With the first four functions, everything is clear. Exponentiation is written as ^ (Shift + 6). For example, 5 ^ 2 would be five squared or five to the second power.
As for the percentage, if you put a% sign after any number, it will be divisible by 100. For example, if you write 12%, you get 0, 12. Using this sign, it is easy to calculate percentages. For example, if you need to calculate 7 percent of 50, then the formula will look like this: = 50 * 7%.
One of the popular operations that is often done in Excel is the calculation of the amount. Let's say there is a table with the fields "Name", "Quantity", "Price" and "Amount". They are all filled in, only the "Amount" field is empty. To calculate the amount and fill in a free column automatically, you first need to select the cell where you want to write the formula and put an equal sign. Then click on the desired number in the "Quantity" field, type the multiplication sign, then click on the number in the "Price" field and press Enter. The program will calculate this expression. If you click on the cell of the sum, then you can see something like this formula: = B2 * C2. This means that not any specific numbers were counted, but the numbers that were in these cells. If you write other numbers in the same cells, Excel will automatically recalculate the formula - and the value of the sum will change.
If, for example, you need to count the number of all goods that are recorded in the table, you can do this by selecting the auto sum icon in the toolbar (it looks like the letter E). After that, you will need to specify the range of cells that you want to count (in this case, all the numbers in the "Quantity" field), press Enter - and the program will display the resulting value. You can also do it manually by alternately specifying all the cells of the "Quantity" field and putting an addition sign between them. (= A1 + A2 +… A10). The result will be the same.
