TSU TSU Computer technology control

Computer technology TSU control
Setting to section 2.1.
Suppose that information is available on sales of goods of the firm:
Number Order Date Company That bunks Quantity Price Summa Tax Delivery Date
1 31/05/98 Arsenal Pentium 200 2600 1200 240 06.06.98
2 23/08/98 Arsenal Pentium 233 4650 2600 520
3 01/11/98 Master Pentium 200 1600600120 01/17/98
7.3.99 Master Pentium 4 300 3 900 2 700 540 13.03.99
5 25.09.98 VIST Pentium 200 4600 2400 480
6 05.07.98 VIST Printer Hp 6P 2400800160 07/12/98
7 04/01/98 Arsenal Pentium 233 3650 1950 390 01.20.98
8 11/02/98 Master Pentium 200 1600600120
9 28/10/98 Arsenal Pentium 300 4900 3600 720 11.13.98
10 09/08/98 VIST Printer Hp 6L 2300600120 08/15/98
11 6.2.98 Master Pentium 300 3900 2700 540
12 11/30/98 VIST printer HP6L 4300 1200 240 12.12.98
13 22.03.98 VIST Pentium 200 1600600120 03/28/98
14 1.2.99 Master Pentium 200 600 2400 480
15 13/09/98 Arsenal Pentium 300 2900 1800 360 29.09.98
16 11/03/98 Arsenal 6P Printer HP 3400 1200 240
17 05/06/98 VIST Pentium 300 4900 3600 720 11.06.98
18 04/13/98 Arsenal Pentium 233 3650 1950 390
19 16/05/98 VIST printer NR6R 3400 1200 240 05.28.98
20 08.01.98 Arsenal Printer HP 6L 4300 1200 240
21 10/18/98 Master Printer HP6L 2300600120 03.11.98
22 06/18/98 Master Printer HP 6L 3300900180
23 12/03/98 Master Pentium 233 4650 2600 520 03.24.96
24 07/21/98 VIST Pentium 233 3650 1950 390
25 15/01/98 VIST Pentium 300 4900 3600 720
26 26/04/98 Mr. printer HP6L 1300300 60 02/05/98
27 22/11/98 VIST Printer HP 6P 2400800160
28 01/18/98 Arsenal Pentium 200 4600 2400 480 01.28.98
29 27/12/98 Arsenal Printer HP 6P 2400800160
30 01/31/99 VIST printer HP6L 2300600120 16.02.99

Task:
1. Create a book MS Excel, on the first sheet post iskhod¬nuyu information. Assign the name of the sheet P1. Check out the data as a list.
2. Make a copy of the list to the sheets A2, A3, A4, A5.
3. On a sheet of A2 to sort the data on goods fir¬mam, quantity.
4. On a sheet LZ for companies to take stock of the number, amount and tax.
5. On a sheet of A4 display data only for completed za¬kazam, sort the data by company, date of delivery.
6. On a sheet of A5 to display information about computers ordered in II quarter of 1998, sort the list by company.
7. On sheets T1, T2, TK, T4, T5 build spreadsheets.