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?

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

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.

Alwayspop back and let us know the outcome - thanks

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+B1from 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...

"Your supervisor is creating a multiplication table"

I haven't got a supervisor.

Alwayspop back and let us know the outcome - thanks

Ask Your Question

Weekly Poll