Spreadsheet work

Firstly I added filters to the data by going to data and auto filter.



I then reduced the data down to vacuum cleaners which were 4 star and with accessory packs.

I then reduced it to maxpull branded vacuum cleaners and ones which were valued as less than £75.


I then arranged them so that all the models cost more than £80 and then ordered them in order of contract offer.


I then organised them into groups of 3 star rated vacuum cleaners and then showed the cleaners with less than 4 in stock.