BeginnerFormulas
Calculate line totals with multiplication
Multiply quantity by unit price to get a line total.
3 min10 points
What does the dollar sign actually do?
The situation
Someone on your team has started adding dollar signs to every reference in the model on the grounds that it makes formulas safer. It is worth being clear about what they actually change before that becomes a house style.
Who this is for
Recommended next
Related exercises
- AdvancedLookup & Reference
Lock ranges so a lookup survives fill-down
Use absolute references so a lookup does not break when copied down a column.
XLOOKUP
12 min40 points - IntermediateKeyboard Shortcuts
Add the dollar signs without typing them
Cycle a reference through its absolute and relative forms while editing.
4 min20 points - BeginnerFormulas
Calculate line totals with multiplication
Multiply quantity by unit price to get a line total.
3 min10 points