excel 2006

1
information table Make-up 5% 7% Number of stock items Small 7 Large 5 Date Item Size Purchase Increase Sale 24/03/2006 Basic exercise bike Small 94 6.58 100.58 30/3/2006 Cross trainer Large 295 20.65 315.65 6/4/2006 Multi gym Large 449 22.45 471.45 15/04/2006 Treadmill Large 839 41.95 880.95 19/05/2006 Rowing machine Small 519 25.95 544.95 20/05/2006 Trampoline Large 349 17.45 366.45 26/05/2006 Benches Small 139 9.73 148.73 2/6/2006 Punch bags Small 258 18.06 276.06 2/6/2006 Weights Small 79 5.53 84.53 7/6/2006 Elliptical cross traiLarge 444 22.2 466.2 17/06/2006 Step trainer Small 45 3.15 48.15 22/06/2006 Press Small 88 6.16 94.16

Upload: anny

Post on 07-Dec-2015

212 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Excel 2006

information tableMake-up 5%

7%Number of stock itemsSmall 7Large 5

Date Item Size Purchase Increase Sale24/03/2006 Basic exercise bike Small 94 6.58 100.58

30/3/2006 Cross trainer Large 295 20.65 315.656/4/2006 Multi gym Large 449 22.45 471.45

15/04/2006 Treadmill Large 839 41.95 880.9519/05/2006 Rowing machine Small 519 25.95 544.9520/05/2006 Trampoline Large 349 17.45 366.4526/05/2006 Benches Small 139 9.73 148.73

2/6/2006 Punch bags Small 258 18.06 276.062/6/2006 Weights Small 79 5.53 84.537/6/2006 Elliptical cross trainers Large 444 22.2 466.2

17/06/2006 Step trainer Small 45 3.15 48.1522/06/2006 Press Small 88 6.16 94.16