Every row uses the first item’s price
Locking B2 as $B$2 prevents the base row from changing. Use $B2.
Fill formulas across and down with fixed references
Read-only
Step-by-step guide · read-only ·
Loading your interactive spreadsheet…
Preparing the worksheet and formulas…
Data & tools
Task requirements
Fill C2:E4 with base price × (1 + rate) + fixed fee. Use the base in column B, the rate in row 1 and the fee in G2.
Follow the highlighted cells. Switch to Your turn to edit. Answer cells: C2, D2, E2, C3, D3, E3, C4, D4, E4. Browser calculations may differ from your Excel version.
Copy one formula and compare
Choose two result cells. Copy moves an unlocked row or column by the distance between them; a dollar sign locks the part that follows it. This replaces the destination formula. The table shows applied formulas and calculated values from the current worksheet.
A1 moves both parts; $A$1 locks both; $A1 locks the column; A$1 locks the row. Try a rightward copy and a downward copy before filling the whole table. Equivalent formulas are welcome; passing practice checks the complete report against other sources.
| Cell | Applied formula | Calculated value |
|---|---|---|
| C2 | No formula | — |
| D2 | No formula | — |
| E2 | No formula | — |
| C3 | No formula | — |
| D3 | No formula | — |
| E3 | No formula | — |
| C4 | No formula | — |
| D4 | No formula | — |
| E4 | No formula | — |
Change a source value
Rates use decimals: 0.05 means 5%. Apply a numeric literal to recalculate the current formulas.
Applied value:
Selection & formula search
Practice stays on this device. No worksheet data is uploaded.
Notes & examples
About this lesson
Build a price scenario table while keeping the base-price column, rate row and fixed fee in the right places.
THE QUICK ANSWER01
The dollar sign fixes what follows it: $B keeps column B, $1 keeps row 1, and $G$2 fixes both. The unfixed parts still move when copied.
ƒx
=$B2*(1+C$1)+$G$2For the example data
C2 24D2 25E2 27C3 55.5D3 58.00000000000001E3 63C4 87D4 91E4 99
The formula uses the interactive worksheet above. Adjust ranges and criteria for your own data.
How it works
Four reference forms
A1 can move in both directions. $A$1 cannot move in either. $A1 fixes the column but allows the row to move. A$1 fixes the row but allows the column to move. Pick the form based on where the formula will be copied.
Copying is part of the task
A formula can be correct in C2 and fail after filling. Test one cell to the right and one cell below before filling a larger table. A correct scenario table changes when any base price, rate or the fixed fee is edited.
Read the input row
C1:E1 hold numeric rates even though they sit on the top row. Enter 0.05 for 5%, not 5. The fee is added once after applying the rate to the base price.
Read the full step-by-step walkthrough
- Start with one scenario
C2 uses the base price in B2, the rate in C1 and the fee in G2. Rates are decimals: 0.1 means 10%.
B2*(1+C1)+G2 - Keep the base-price column
Use $B2. Across the row, the B stays fixed; down the table, row 2 is allowed to change.
$B2 - Keep the rate row
Use C$1. Down the table, row 1 stays fixed; across the table, C can become D or E.
C$1 - Keep the one fee cell
Every scenario uses G2. Lock its column and row so neither changes during copying.
$G$2 - Fill across, then down
Copy C2 into D2:E2, then fill the row through row 4. Compare formulas as well as values. Each cell should use its own base row and rate column.
=$B2*(1+C$1)+$G$2
Things to watch
The rate moves into the result area
Lock the rate row with C$1 before filling down.
The fee drifts to a blank cell
G2 must be fully absolute: $G$2.
About this example
Published examples, formula filling and practice checks were tested in Chrome on October 13, 2026. Tests cover the supplied datasets and stated input rules, not every possible formula. These workbooks have not yet been independently recalculated in Microsoft Excel or Google Sheets.
Content version 2. Practice checks compare calculated results across different datasets; they do not certify every possible formula.