Microsoft Excel Question?

Question

I haven't used excel in years so I've forgotten how all the formulas work. I was wondering if there is a way to take the product of many rows without having to enter in the same formula over and over, but with different numbers. Like for example right now I have =PRODUCT(B1,C1) and =PRODUCT(B2,C3), etc. Is there a special way to just make it take the product of all B and C rows with the same number so I don't have to keep entering the same thing over and over?

Answer 1

Yes there is. It is called an array formula and it's pretty easy to use.

Let's say you want to enter the products for all of the rows into column D. Here's what you'd do:

1.) Select Column D
2.) Type in an equals sign (the formula should appear in cell D1)

3.) Select Column B
4.) Type an asterisk
5.) Select Column C
6.) Press Ctrl + Shift + Enter

All of the cells in Column D will have the formula below when you are done.

{=B:B*C:C}

Pressing Ctrl + Shift + Enter defines the formula as an array. The formula is then surrounded by brackets to state that it is an array.

This way you have one formula instead of tons of formulas and there is no copying or pasting or filling down the rows needed.

Answer 2

Lemme wager, you're in a working laptop or pc Literacy class... perhaps with the paintings Institute??? because of the fact whats humorous is that's the precise question of this weeks first project. extraordinary. "Week 3: Week 3 - W3: project a million communicate communicate question 3 evaluate Microsoft observe, Microsoft Excel, and Microsoft PowerPoint. whilst do you ought to use each and each of those applications? whilst are you able to apply those applications interchangeably? provide examples and reasons to assist your answer."

Answer 3

You can copy and paste your existing formulas into other cells where you want the same result. Excel is smart enough to know that if you go two rows over, or two columns over, it will change/update your formula. I'm an excel guru, so send me any questions you have; happy to help.

good luck.

Answer 4

after you created the formula for the first cell, =product (b1,c1), click the column header (the thing with the letters) to highlight the whole column. then from the menu, click Edit>Fill>Down.


hope that helps...

Answer 5

Make the formula first in one cell. Then once done, Right click the cell and copy. Then highlight all cells that you want the formula to apply to and click "Paste"

Easy.. :-)

Answer 6

Copy and Paste
place your cursor on the cell you want to copy
Select Copy
put your cursor in the cell to paste to and drag highlite all cells
press enter or paste

good luck :)

Answer 7

mabe these will help http://www.exceltip.com/

http://office.microsoft.com/training/training.aspx?AssetID=RC061079311033

http://spreadsheets.about.com/od/excelformulas/ss/formula_begin.htm