SOB 114 [Threshold]


The following table shows a student's income in pounds from a part-time job and monthly expenses over the course of an academic year. She also receives 225 pounds each month as a student loan. Enter the data into an Excel table and use the built-in functions to calculate the amount she has left each months, and the total amount she saves over the year.


Monthly savings
Month Income Expenses Remainder
October 195 395
November 231 335
December 230 372
January 211 304
February 207 380
March 250 383
April 212 349
May 207 369