Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
6. Exercise 5


That was a good one! Here comes the last exercise.


There are five sheets in the file: February, March, April, May, and June.

Load the spendings.xlsx file. Each worksheet has the same structure:

date spendings
<date> <spendings>

We have to correct some mistakes:

  • Remove the row for the 30th day in April (row number 31).
  • Deduct 2.00 from every value spent in March that was greater than 50.00.
  • Add 2.00 to every value spent in May that was smaller than 30.00.
  • Save the workbook to the corrected_workbook.xlsx file.

The number of rows in each sheet is the number of days in a month plus one.