Task 1 of 6
In D2:D7, calculate the total for each item: price × quantity.
Lesson theory
A school is ordering stationery. Let's review arithmetic, percentages, and the SUM, AVERAGE, MIN, MAX, COUNT and COUNTA functions.
Tip: write the formula for the first row once, then drag it down by the handle in the corner of the frame.
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