Employ AutoFill


Click the Sales tab.

In cell A1, type:

Frog Sales

Make this text Arial, 12 point, bold:

In cell A3, type:

January

In cell B3, type:

February

In cell C3, type:

March

Highlight cells A3 through C3.

Place the cursor on the Fill Handle.

It should turn into a black cross:

Drag the cursor to cell L3.

  1. Release the mouse button.

    The months should fill in consecutively:

In cell A4, type:

10

In cell B4, type:

20

Highlight cells A4 and B4, then place the cursor on the Fill Handle.

Drag it to cell L4.

The numbers should fill in, in increments of 10:

In cell N3, type:

Total

Click cell N4, then click the icon.

Drag over all the cells with numbers in them.

They should be surrounded by "marching ants":

Press ENTER.

The yearly total of 780 frogs sold should appear:

Save the workbook.