what is the correct formula to fix using B1*A2

June 15, 2016 at 19:10:34
Specs: Windows 7
Your supervisor is creating a multiplication table that will be used as a reference for employees to ensure the accuracy of basic calculations. the final table will provide values for every possible combination of the multiplication of numbers between 1 and 14. Your supervisor knows that in order to copy a formula, he needs to fix certain Column and Row values. His initial formula is: B1 * A2
If you were to correct the required elements of the above formula to allow it to be copied to each cell within the border, how would you modify it?

See More: what is the correct formula to fix using B1*A2

Report •

#1
June 15, 2016 at 21:02:01
We do not like to answer homework questions directly because giving you the answer won't help you learn as much as you will if you figured it out yourself.

Please read the material found here:

http://www.cpearson.com/excel/relat...

message edited by DerbyDad03


Report •

#2
June 17, 2016 at 08:24:50
Remember that the purpose of study is to help your future. If someone else does your homework for you then you will learn nothing. Even if you get away with the homework there will not be others sitting beside you through life.

It is also a bit cheeky just whacking out your homework question on here and expecting others to do it for you. Why should we? Asking questions about it to help you do it yourself is quite a different matter.

Always pop back and let us know the outcome - thanks


Report •

#3
July 5, 2016 at 21:55:35
There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant no matter where they are copied.

By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. Relative references are especially convenient whenever you need to repeat the same calculation across multiple rows or columns.

Find more click below link:
http://www.gcflearnfree.org/print/e...


Report •

Related Solutions

#4
July 6, 2016 at 04:30:47
"Your supervisor is creating a multiplication table"
I haven't got a supervisor.

Always pop back and let us know the outcome - thanks


Report •

Ask Question