Question: Exercise 2 c Complete the Multiplication Table with One Formula An absolute cell reference, e . g . $C$ 7 , is really fixing the
Exercise c
Complete the "Multiplication Table" with One Formula
An absolute cell reference, eg $C$ is really fixing the column to C and the Row to There are mixed references: $C fixing the column to C but letting the rows change as the reference is copied and C$ fixing the row to but allowing the column to change as the reference is copied.
Come up with a single formula in B 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
