First formulas practice exercises
A formula is how a spreadsheet does the math for you. Write your first ones here, add, multiply and click cells into a formula, with each idea explained before you try it.
- 1Add two cellsIn B4, write a formula that adds the price of the coffee and the cake.
- 2Multiply quantity by priceIn D2, multiply the number of units by the price.
- 3Click cells into a formulaIn B5, add up the visitors for the three weeks by clicking the cells into your formula.
- 4Parentheses change the orderIn E2, work out the total: the units plus the bonus units, all times the price. Put the addition in parentheses so it happens first, (B2+C2)*D2.