Google Sheets In Pictures

Employ absolute references

1 On the Revenue sheet, click cell B4.

Notice the formula in the Formula Bar:

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

2 Place the cursor on the Fill Handle, then drag it to cell C4.

Cell C4 should contain only a zero.