Absolute References

Part of the Formulas and Data Analysis section of Coddy's Excel journey. Lesson 2 of 28.

Dollar signs lock a reference when a formula is copied. $E$2 keeps both column E and row 2 fixed. Use an absolute reference for a shared rate or constant stored in a cell.

B2 contains 80, E2 contains 0.1.

Example: =B2*$E$2.

The shared rate is ten percent, so 80 * 0.1 is 8.

An absolute reference such as $E$2 keeps both its row and column fixed during copying.

The practice sheet highlights cells where you should enter formulas. The same formulas must work when the tests replace the input data.

Challenge

Easy

Amounts are in B2:B4 and a shared fee rate is in E2. Calculate each fee in C2:C4, using an absolute reference to the rate. Rates are stored as decimal fractions.

Enter formulas in the highlighted output cells: C2, C3, C4. Keep the supplied data and headings. Tests change input values, so use cell references instead of typing the sample answers. Use English function names and commas between arguments.

Try it yourself

Sheet1