Create formulas across worksheets

• Open the Frog Farm workbook.

Click the Revenue tab.

In cell A1, type:

Revenue

Make this text Arial, 12 point, bold:

In cell B3, type:

January
Fill in the cells from C3 to M3 with the months of the year.

In cell A4, type:

Gross Sales

TIP: Adjust the width of column A so all the text shows.
In cell B4, type:

=

Click the Numbers Per-Frog tab.
In the Numbers Per-Frog sheet, click cell E8.

Type:

*

Click the Sales tab.

In the Sales sheet, click cell A4.

Press ENTER.

On the Revenue sheet, January's gross sales should be $30.00:

The price of a frog

times

The number of frogs sold in January.

Click cell B4.

In the Formula Bar is the formula that expresses this:

='Numbers Per-Frog'!E8*Sales!A4

Note the sheets are listed before the cell coordinates.

On the Revenue sheet, type:

Net Revenue

in cell A5.
In cell B5, create a formula that multiplies the profit-per-frog by the number of frogs sold in January.

When you're done, the Net Revenue in January should be $6.80: