Microsoft Excel is a powerful tool for working with tables, providing almost endless possibilities for collecting and analyzing all kinds of data, building charts, and creating reports. However, it can also be used as a regular calculator.
To learn how to count in excel, open the program and follow these simple tasks in sequence:
- In any cell, enter = 2 + 2. The result of the calculation will appear in the cell - the number 4. Note that if you just write 2 + 2 in the cell, this text will be visible. In order for excel to understand that the user wants to perform operations, and not just write them down, it is necessary to put the = sign in front of the formula.
- The rules for performing calculations in Excel are the same as in the usual school arithmetic. For example, the calculation results = (5 + 5) * 2 and = 5 + 5 * 2 will be completely different. Use parentheses to define the order of computation you want.
- The ability to read with excel would not be so useful if the program did not allow using the contents of cells as data for calculations. Enter in any cell the number 10, in any other - the number 2. In another cell, enter the = sign, then left-click on the first cell, enter the sign - and left-click on the second cell. A formula similar to = I9-G8 will appear, and after pressing Enter, you will see the result of subtraction - number 8. Try entering other numbers in the first two cells - you will see that the value in the third changes automatically, immediately after correcting the data in the first cells.
- Excel has formulas to handle entire arrays of cells. Select multiple cells in a vertical column and enter any numbers in them. Place the cursor on the cell below the bottom cell with a number. Enter = sum (and then select the column with numbers with the mouse. Type the closing parenthesis and press Enter. As a result, a number equal to the sum will appear under the column of numbers. Excel has many much more complex formulas that allow you to perform various and complex mathematical, statistical and other calculations.
As you can see, calculating in excel is very simple and convenient. To familiarize yourself with other functions of this useful program, use the help system (to open it, press the F1 key).
