Task 1 of 5
In C2:C5, calculate how many liters of paint are needed (area × the rate in H1), rounded to one decimal place.
Lesson theory
You are renovating an apartment: working out the paint, the number of cans and the painter's pay. Practice ROUND, ROUNDUP, ROUNDDOWN, MROUND, QUOTIENT and MOD.
Tip: when you buy something in whole units (cans, boxes), round up. The store will not sell you half a can.
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