Excel for Marketing Managers

Multiplication Tables

Multiplication

Tables

Multiplication Tables

Opportunity..................................................................................................................................

Bill Jelen’s classic example for demonstrating the various types of mixed
references is to create a multiplication table. Although you probably have
access to a multiplication table that you can photocopy, this exercise will
demonstrate both the AutoFill option and how to use mixed cell references.

Solution and Overview

You will use some efficient tools to create the multiplication table. AutoFill lets
you type the first few cells in a series and then extend the series. Transpose
lets you turn a range on its side. Finally, you will build one formula that
handles the entire multiplication table.

Creating the Solution

This process involves two operations:

¾ Extending a series using the fill handle

¾ Transposing a range by copying it on its side