Mixed References

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

A mixed reference locks just one direction. $A2 keeps column A fixed but allows the row to move. B$1 keeps row 1 fixed but allows the column to move. Together they build a formula that copies across a grid.

A2 contains 6, B1 contains 4.

Example: =$A2*B$1.

The formula combines the row value 6 with the column heading 4, giving 24.

Use $A2 for a fixed input column and B$1 for a fixed input row.

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

Challenge

Easy

Row quantities are in A2:A3; column unit prices are in B1:C1. Fill B2:C3 with quantity times price. Use mixed references so one pattern works throughout the grid.

Enter formulas in the highlighted output cells: B2, B3, C2, C3. 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