Task 1 of 4
In C2:C6, calculate the student price: price × (1 − the discount in G1). Lock the discount reference.
Lesson theory
A fitness club is working out its membership prices. You will practice absolute ($G$1) and mixed ($A11, B$10) references.
Tip: before you fill a formula, ask yourself which part of the address must stay put, and lock it with F4.
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page