BASIC EXCEL.xlsx

	A	B	C	D	E	F	G
1
2
3	KETERANGAN	FORMULA	DATA 1	DATA 2	DATA 3	DATA 4	HASIL

4
5
6	PENGELOMPOKAN	()	20	20	20		800
7	PANGKAT	^	4	5			1024
8	PERKALIAN	*	4	5			20
9	PEMBAGIAN	"/"	20	5			4
10	PENJUMLAHAN	"+"	20	3			23
11	PENGURANGAN	"-"	30	5			25
12	PENGGABUNGAN	&	ARIF	ADIT			ARIF ADIT
13	Fungsi	SUM	20	12	3	5	40
14		MMULT	20	12			240
15		MOD	20	3			2
16		ROUND	163.67				163.7
17		MIN	30	20	10	30	10
18		MAX	30	20	10	40	40
19		AVERAGE	30	10	10		16.66666667
20		COUNT	30	10	10	2	4
21		LEFT	Desy Ratna Sari				Desy
22		RIGHT	Desy Ratna Sari				Sari
23		MID	Desy Ratna Sari				Ratna
24		LEN	Desy Ratna Sari				15
25		LOWER	Desy Ratna Sari				desy ratna sari
26		UPPER	Desy Ratna Sari				DESY RATNA SARI
27		PROPER	desy ratna sari				Desy Ratna Sari
28		CONCATENATE	Desy	Ratna	Sari		DesyRatnaSari
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