LATIHAN INF XI

	A	B	C	D	E	F	G	H	I	J
1	No	Customer Code	Customer Name	Tax	Qty Box	Total Weight	Price Total Qty Box	Price Total Weight	Tax Amount	Total Amount
2	1	CTR0102065
3	2	CTR0100278
4	3	CTR0200584
5	4	CTR0200405
6	5	CTR0200227
7	6	CTR0200752
8	7	CTR0200471
9	8	CTR0200870
10	9	AAMB-20
11	10	DOPL-01
12	11	CTR0600122
13	12	AAMB-115
14	13	AAMB-89
15	14	ACPB-11
16	15	BTA-0053
17
18		Instructions						Price Table
19	1	Use the VLOOKUP function in column C (Customer Name) and column D (Tax)						Price per Qty Box	Rp 250,000
20	2	Use the SUMIF function in column E (Qty Box) and column F (Total Weight)						Price per Weight	Rp 1,500,000
21	3	Use the Basic Multiplication function in the G and H columns referring to the price data records
22	4	Use the IF function in column I, with the criteria if the Tax column is PKP then it is 10% & if PTKP it is 0%
23	5	Use the Basic Addition function in column J with reference to columns G, H and I
24	6	Use the data sheet to make a Report Qty Box and Total Weight per Area and per Customer by using a Pivot Table
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100