Question: Exercise 2 c Complete the Multiplication Table with One Formula An absolute cell reference, e . g . $C$ 7 , is really fixing the

Exercise 2c
Complete the "Multiplication Table" with One Formula
An absolute cell reference, e.g. $C$7, is really fixing the column to C and the Row to 7. There are mixed references: $C7 fixing the column to C but letting the rows change as the reference is copied and C$7 fixing the row to 7 but allowing the column to change as the reference is copied.
Come up with a single formula in B5 that you can copy to the remainder of the table, completing the Multiplication Table. Hint: it takes a "mixed" reference - that is, either the column or the row should be held constant and the other allowed to vary as it is copied.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!