How in Excel to multiply a column by column and column by number

Those people who often work at a computer will sooner or later come across a program such as Excel. But the conversation in the article will not be about all the pros and cons of the program, but about its separate component “Formula”. Of course, in schools and universities at computer science lessons, pupils and students take a course on this topic, but for those who have forgotten, this is our article.

We’ll talk about how to multiply a column by a column in Excel . Detailed instructions will be provided on how to do this, with a step-by-step analysis of each item, so that everyone, even a novice student, will be able to understand this issue.

Multiply a column by a column

Excel , . , Excel . . , .

, :

1. , .
2. , " ".
3. .
4. "".

, , . , () " 1", () - " 2". , (2:6). , , .

, Excel , , .

, "", "". : " 1" " 2". " 1" , " 2", .

"" , , .

, Excel . , .

So how to multiply a column in Excel by a number? This is actually even easier. For this:

1. Select the cell where the result will be located.
2. Enter an equal sign in it.
3. Select the first value from the column with the cursor, and then select the number by which this value will be multiplied.
4. After that, hover over this number and press the F4 key.
5. Now it remains only to move the cursor to the lower right corner of the cell with the answer and drag it to the required number of points.