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 270 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 190 322
November 244 341
December 202 389
January 197 369
February 235 309
March 216 336
April 231 399
May 179 327