Skip to main content

Week 4: Working with patterns and formulas

Completion requirements

This is a screenshot of a spreadsheet used for a monthly budget. It consists of the following table: A B 1 Amount (£) 2 Monthly Income 3 Salary 1700.56 4 Other Income 51.34 5 Total Income 1751.90 6 7 Monthly Expenses 8 Rent 819.82 9 Food 233.14 10 Transportation 174.40 11 Regular Bills 221.12 12 Other 136.70 13 Total Expenses 1585.18 14 15 Balance 166.72 An arrow points to and labels row 11 and column B. Cell B11, containing the number 221.12, is also labeled.

 1 Your formulas: using a spreadsheet