HLOOKUP & VLOOKUP
Selasa, 09 Agustus 2016
cara membuat envelopes
1. pastikan komputer lau hidup, kalo kaga ya kaga bisa bikin undangannya lahh....
2. buka ms. word kalo udah klik page layout terus ubah oriantation kertasnya jadi landscape
3. klik mailings terus klik start mail merge, pilih envelopes
4. pilih select recipients kalo udah pilih type new list
5. kalo udah pilih customize columns, delete addres list nya kalo udah klik add baru tulis nama sama alamat yg di tuju
6. bikin desain dah tuh tulisan undangannya sesuka hati lau.
pilih tempat yang ingin dimasukan formatnya, klik insert merge field, plih format yang akan dimasukan .
jika sudah pilih preview result pilih finish & merge lalu klik individual document
nih contohnya :
TUGAS
Asia-Pacific regional rice strategy
R
|
ice is the the most
important stapel food of the Asia-Pasific region and some 90 percent of the
world’s rice is grown in teh region . Its production
dominates the agricultural landscape and is an important base of economies, the
environment, culture and livelihoods for hundreds of miliion of farmers.
However, the rice
economy is suffering from resource scarcity, notably water and, while rice
farming is also blamed for greenhouse gas emissons and degrading natural
resources. Rice cunsumption per person is declining as household incomes grow
and diets change.
In
2012, at the 31st FAO Regional Conference for Asia and
the Pacific in Hanoi, Viet Nam, FAO member countries asked the Organization to
coordinate the developmet of a regional rice strategy.
In response, FAO
established the External Rice Advisory
Group (ERAG)to formulate a region-wide rice strategy. Professor M S
Swaminathan, one of the pioneers of
India’s green revolution , agreed to chair the ERAG working with the
group’s tam leader, R B Singh, a former
FAO Assistant Director
General and Regional Representative for
Asia and the Pacific.
ERAG is composed of
executives and rice expets from the following organization: International Food
Policy Research Institute (IFPRI), International Rice Research Institute
(IRRI), Inernational Water Management Institute (IWMI), International Fund for
Agricultural Development (IFAD), Asian Development Bank (ADB), M S Swaminathan Research Foundation (MSSRF),
The World Bank (TWB), Farmer and Nature Net (FNN), Asian Farmers Association
for Sustainable Rural Development (AFA), an advisor to Thailand’s Minister for
Agricultureand Cooperatives, and a distinguished Harvard Professor of
development studies.
STATISTIK DAN DATA KELOMPOK
|
NO
|
NAMA
|
NILAI
|
||
|
1
|
AAN
|
70
|
||
|
2
|
IIM
|
75
|
||
|
3
|
AAM
|
76
|
||
|
4
|
UNI
|
78
|
||
|
5
|
IIN
|
75
|
||
|
6
|
INA
|
80
|
||
|
7
|
ANI
|
81
|
||
|
8
|
NIA
|
83
|
||
|
9
|
UMI
|
79
|
JUMLAH
|
1188,4
|
|
10
|
IMA
|
88
|
RATA-RATA
|
79,23
|
|
11
|
AMI
|
90
|
MODUS
|
75
|
|
12
|
UCI
|
86
|
MEDIAN
|
78,9
|
|
13
|
UCA
|
74
|
KUARTIL
|
90
|
|
14
|
ICIH
|
78,9
|
|
75
|
|
15
|
EDOH
|
74,5
|
VARIASI
|
31,3921
|
|
76
|
71
|
|
|
87
|
56
|
80
|
|
89
|
54
|
50
|
|
75
|
|
|
|
74
|
82
|
70
|
|
87
|
55
|
60
|
|
84
|
67
|
61
|
|
|
69
|
|
|
88
|
53
|
|
|
81
|
99
|
97
|
|
|
77
|
94
|
|
90
|
|
47
|
|
92
|
|
44
|
|
95
|
|
65
|
|
96
|
45
|
68
|
|
JANGKAUAN
|
55
|
|
|
BANYAK KELAS
|
6,1
|
|
|
PANJANG KELAS
|
9,02
|
TUGAS APLIKASI KOMPUTER
"IF & ROUND"
|
NO
|
NAMA
|
JK
|
NILAI
|
KETERANGAN TUNGGAL
|
KETERNGAN
|
|
1
|
EDOH
|
W
|
78
|
REMIDI
|
REMEDI
|
|
2
|
ICIH
|
W
|
77
|
REMIDI
|
REMEDI
|
|
3
|
MUS
|
L
|
76
|
REMIDI
|
REMEDI
|
|
4
|
PIPIT
|
L
|
79
|
LULUS
|
LULUS
|
|
5
|
PIRMAN
|
L
|
70
|
REMIDI
|
REMEDI
|
|
6
|
UJANG
|
L
|
88
|
LULUS
|
LULUS
|
|
7
|
IMAS
|
W
|
87
|
LULUS
|
LULUS
|
|
8
|
KINANTI
|
W
|
86
|
LULUS
|
LULUS
|
|
9
|
KINASIH
|
W
|
89
|
LULUS
|
LULUS
|
|
10
|
JAMAL
|
L
|
80
|
LULUS
|
LULUS
|
|
11
|
MURAD
|
L
|
68
|
REMIDI
|
REMEDI
|
|
12
|
AAM
|
W
|
64
|
REMIDI
|
REMEDI
|
|
13
|
EDI
|
L
|
90
|
LULUS
|
LULUS
|
|
14
|
JOKO
|
L
|
85
|
LULUS
|
LULUS
|
|
15
|
OJAN
|
L
|
66
|
REMIDI
|
REMEDI
|
|
RATA"
|
78,87
|
||||
|
R.L
|
78
|
||||
|
R.W
|
80,17
|
|
NO
|
NAMA
|
NILAI APLIKOM
|
NILAI AKUNTANSI
|
NILAI BISNIS
|
NILAI RATA"
|
PERINGKAT
|
|
1
|
EDOH
|
74
|
86
|
84
|
81,33
|
3
|
|
2
|
ICIH
|
75
|
78
|
83
|
78,67
|
11
|
|
3
|
MUS
|
76
|
82
|
82
|
80
|
8
|
|
4
|
PIPIT
|
82
|
83
|
81
|
82
|
2
|
|
5
|
PIRMAN
|
81
|
74
|
78
|
77,67
|
12
|
|
6
|
UJANG
|
90
|
84
|
70
|
81,33
|
3
|
|
7
|
IMAS
|
80
|
75
|
78
|
77,67
|
12
|
|
8
|
KINANTI
|
88
|
78
|
76
|
80,67
|
6
|
|
9
|
KINASIH
|
87
|
79
|
75
|
80,33
|
7
|
|
10
|
JAMAL
|
78
|
76
|
89
|
81
|
5
|
|
11
|
MURAD
|
79
|
87
|
72
|
79,33
|
10
|
|
12
|
AAM
|
85
|
89
|
74
|
82,67
|
1
|
|
13
|
EDI
|
70
|
88
|
81
|
79,67
|
9
|
|
14
|
JOKO
|
77
|
81
|
73
|
77
|
15
|
|
15
|
OJAN
|
83
|
80
|
70
|
77,67
|
12
|
|
80,33
|
||||||
|
RATA" ALL
|
79,8
|
Langganan:
Komentar (Atom)