Instruction
1
In order to understand the principle of operation in Excel, you should understand the following key points:
a unit of data in Excel is a value that contains one cell;
all operations performed in Excel are produced on these cells.
the coordinates of the cells are of the form: <letter><digit>, where <letter> is the letter of a column matrix, and <digit> - symbol row of the matrix (eg. A1).
Suppose we have two columns of numbers that need to be divided. Start to learn how to divide one cell into another.
a unit of data in Excel is a value that contains one cell;
all operations performed in Excel are produced on these cells.
the coordinates of the cells are of the form: <letter><digit>, where <letter> is the letter of a column matrix, and <digit> - symbol row of the matrix (eg. A1).
Suppose we have two columns of numbers that need to be divided. Start to learn how to divide one cell into another.
2
Left-click on the cell in which you want to record the result of the division.
3
Next, click with the left mouse button on the row for writing formulas.
4
In the highlighted row first of all write the character "=" . Then with the left mouse button we click on the cell that will participate in the division. In the end cell of the result is assigned the value of the cell is chosen for division.
5
Next in the line write after the value of the first cell (in our case A1), put a division sign ( / ). However, it is possible to put not only the division, but also any other arithmetic operation.
6
After the division sign, click the second cell (i.e. the one which will be division).
You can repeat these steps indefinitely, forming a composite mathematical calculations. Not necessarily limited to two cells. You can also use brackets.
You can repeat these steps indefinitely, forming a composite mathematical calculations. Not necessarily limited to two cells. You can also use brackets.
7
After dialing the required formula press Enter, then the result cell will take the value obtained during the calculation formula.
8
Now suppose we need to calculate for the entire table. Excel tools allow us to write to each cell a new value, and calculate all at once.
9
To do this, click with the left mouse button on the cell with the result. Next, move the cursor to the bottom right of the cell (the cursor should change its appearance with a white cross to a thin black). Hold down the left mouse button and "drag" the cursor to the bottom of the table, then release the button.
In the end, we crafted an entire plate, write the formula only once.
In the end, we crafted an entire plate, write the formula only once.
