Advice 1: How to multiply in Excel

The multiplication operation is one of the most used in any field and table editor Excel – one of the most frequently used tools to calculate the tables. To understand the whole process enough rassmotretjvopros actions when multiplying two or more values in the Excel editor.
How to multiply in Excel
You will need
  • Table editor Excel 2007
Instruction
1
If you want single action - multiply two numbers – the sequence of actions should be:

- click in the blank cell, Excel spreadsheet (by using the navigation arrow keys and by clicking the desired cell with the mouse);

- press the "=". Excel interpreterpath this action as the beginning of the input formula;

- now print the desired mathematical operation using as a multiplication sign, the asterisk (*). Signs of mathematical operations called "operators". For example, if you multiply 2 by 3, then the cell you need to type "=2*3, where the equal sign is left from the previous step, re-print it is not necessary. If you want to multiply, not two, but more numbers - nothing changes in the rules print more. For example, =2*3*4*7*12;

- when you enter press Enter. Excel will calculate the result and show it in the same cell.

Instead of the usual write math using the multiplication operator (*), you can use the function with name PRODUCED. In this case, the content of a table cell, carrying out the multiplication of the five numbers will look like this: =K(2;3;4;7;12).
2
If it is necessary to organize a permanent form of multiple cells to one of them to print the multiplicand in the other the multiplier, and the third to see the result of the multiplication:

- in the first empty cell type the number (multiplicand) and press Enter;

in the second empty cell, type the second number (multiplier) and press Enter;

in the third cell, press "=" and using the navigation keys (arrows) move to the first cell (containing multiplicand). Alternatively, you can just click the cell with the mouse. Having done this, press the asterisk (multiplication operator). The cursor will return to the third cell, but you need by using the same navigation keys or mouse to move to the second cell containing the multiplier. After that, the contents of the cell with the formula should look like this: =A1*A2. Having done all that, hit Enter to finish entering the formula in the third cell you will see the result of the multiplication.

You have built a mini-calculator - now you can change the number mnogiego and multiplier, and Excel in the third cell to display their work.

And here multiply numbers does not necessarily have to be only two acting exactly the same way you can organize the desired number of multiplies of cells with numbers. But in this case it is more convenient to use the operator * and the function. Then you won't have to specify each cell number individually, you can specify a range of cells. For example, if you put multiplies the numbers in cells starting with A1 and ending with the A8, then the contents of the cell showing the result of multiplying them all should be: =K(A1:A8). The cell range can be entered in the function "manually", and you can select with the mouse and Excel will enter the desired value itself.
3
If you need a single multiply the value of each cell in the column (or row) of the table on some index:

- in any blank cell, type this number is the coefficient;

- then select that cell, on the Home tab, in the very first group ("Clipboard"), click "Copy";

- now select the range of cells that you want to multiply by the ratio. This can be done as a mouse and use the arrows while pressing the CTRL key.

- in the same group of "Clipboard" below "Insert", there is a small arrow which opens the additional insert - click it and select the item called "paste Special";

- in the group of switches "Operation" select "Multiply";

- click "OK" and Excel will Peremoga each allocated cell at a coefficient value you copied to the clipboard.
Note
Multiplication. In contrast to the signs of addition (+) and subtraction (-) key with the sign of the multiplication keyboard. Almost all programming languages for multiplication is the asterisk (*). Division. The division sign on the keyboard also no. A colon (:) cannot be used. It was decided to use the division slash (/).
Useful advice
For some characters (unfortunately not all) you can set the hotkeys, for example for sign § this will be Alt+0167: Only numbers you need to dial on the keypad and after the releasing the Alt key the character appears in any program or browser. Alt+0215 × multiplication sign ( works for me with the English layout keyboard).

Advice 2: How to multiply large numbers

The ability to multiply large numbers required daily. Sometimes you have to consider the cost of several items in the store. Sometimes the child asks for help with homework. There are several ways to find the product of two large numbers without using a calculator. Consider the example of multiplication of 42 and 21.
How to multiply large numbers
You will need
  • - a sheet of paper;
  • - handle.
Instruction
1
One of the easiest ways to find the product of two numbers is to multiply them in a column. This is taught in elementary school, but if you have forgotten how to do it, is to refresh their knowledge.Write the two numbers one below the other and slide the bottom horizontal line. Perform multiplication of the first number to the second unit and record the result. Multiply the first number by the tens of the second (the result of multiplying the in this case, you should write a little shifting it to the left). Do another horizontal line and calculate the sum of the numbers obtained. This will be the product of 42 and 21. Similarly, you can multiply and three-digit and five-digit numbers.
2
If you do not have a sheet of paper, you can multiply numbers in mind. For this you need to submit one of the multipliers in the form of tens and ones. Thus, 42х21=42х(20+1). Multiplying the round number is done by multiplying the first multiplier by 10, followed by multiplying the resulting works are in the tens of the second multiplier. To multiply by 10, not necessarily to perform complex mathematical calculations, it is sufficient to ascribe to the right by the number zero. So when you multiply 42 20 42 you need to first multiply by 10 and then doubling the resulting product. 42х20=42х10х2=420х2=840. This number should be kept in memory.The second stage of multiplication in mind is to multiply the first number on the second unit, in this case 42х1=42.Then need to add the numberresulting from the first and second actions. Their sum will be the product of 42 and 21. 840+42=882Данный method to multiply two-digit numbers. Someone can find the three-digit product. Numbers with a large number of bits to be multiplied is unlikely to succeed.
3
There is another unusual way of multiplying numbers. Draw on a sheet of paper a graphic diagram of the first multiplier. Imagine it in the form of parallel horizontal lines indicating the number of tens and ones. Between the first and second discharge shows a schematic representation of the number Express the distance of five inches.In the same way, draw a graphical diagram of a second multiplier, only the parallel lines must be vertical and cross the line first number.Now count the number of points at which intersect the line. The number of points in the upper left intersection will indicate the number of hundreds. Points in the lower right crossing - the number of units. The sum of the points located on the diagonal (lower-left and upper-right intersection), the number of tens. Write down the result, this is the product of 42 and 21.This way you can multiply any multi-digit number. Only need to pay more attention to the counting of intersection points in different diagonals.
How to multiply large <strong></strong>
Search
Is the advice useful?