Excel for Marketing Managers

Multiplication Tables

Multiplication

Tables

Using the Application.................................................................................................................

Print the sheet out and allow your students to study from it.

Excel Details................................................................................................................................

Simplifying Dollar Sign Entry in Absolute and Mixed References

The process of entering the dollar signs in a reference can be simplified by
using the F4 key. As you are entering the formula, pressing F4 immediately
after typing the reference will change the reference from relative to absolute;
that is, A2 would change to $A$2. Press F4 again to change to a mixed
reference where only the row is held constant – A$2. Press F4 again to change
to a reference where only the column is fixed – $A2. Press F4 once more to
toggle back to the relative reference of A2.

Thus, the shortcut for entering the formula in B2 is as follows.

1. Type an equals sign.


2. Type the Up-arrow to move to B1.

Figure 74

Mixed references