Task 1 of 3
Give cell G1 the name "FXRate".
Lesson theory
You can give a cell or a range a meaningful name and use it in formulas instead of an address: =B2*FXRate reads better than =B2*$G$1.
A name behaves like an absolute reference, so you don't need $ signs.
To create one, select the cell or range, click the Name Box to the left of the formula bar, type the name and press Enter. A name cannot contain spaces, and it cannot look like a cell address (such as A1).
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