Build your first spreadsheet budget

A spreadsheet is a grid of cells. Columns are usually labelled with letters and rows with numbers, so A1 identifies the cell in column A, row 1. This exercise uses fictional amounts to practise the structure of a small table.

Set up the table

In a blank spreadsheet, enter Item in A1 and Amount in B1. Enter Notebook, Pen and Folder in A2 through A4. Enter the example values 100, 50 and 150 in B2 through B4. These are practice numbers, not current prices.

Calculate a total

Enter Total in A5. In B5 type =B2+B3+B4 and confirm the entry. The expected result is 300. A formula begins with an equals sign and refers to the values in other cells.

Check that it updates

Change the practice amount in B3 from 50 to 60. B5 should become 310. If it does not, check that the entry in B5 is a formula rather than the text “300”, and that the amount cells contain numbers.

Make the table readable

Make the header row bold, widen column A so its labels fit and apply the same number format to the amount cells. Formatting changes appearance; it should not replace the underlying numbers with currency text typed into every cell.

Save and verify

Save the spreadsheet in your practice folder with a descriptive name. Close and reopen it. Confirm that the labels, amounts and formula are still present.

Practice task

Add a fourth item above the total row and update the formula to include it. Check your result using a separate calculation. The goal is to understand which cells the formula uses, not simply to make a total appear.

Continue with a learning path →
Scroll to Top