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 275 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 201 374
November 250 321
December 184 380
January 181 389
February 170 381
March 176 325
April 247 396
May 151 349