Xtea - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1	DATEVALUE	IF	AVERAGEA		WORKDAY			MIN	TEXTJOIN		TRIM		LOWER		MAXIFS		DAYS360
2	ISBLANK		ABS		RAND			INT					FORMULATEXT	ISERR	MATCH	TIMEVALUE	CHOOSE
3	VLOOKUP		MATCH	DATEDIF		RAND	CONCATENATE		LEN		HLOOKUP			MAXA	SORT	WEEKDAY			DATEDIF
4	WELCOME TO XTEA #facebook.com/Xtea.vn													WEEKDAY		TEXTJOIN			CHOOSE
5	HƯỚNG DẪN TRUY CẬP BÀI TẬP MẪU					DAYS	LEN	MEDIAN		FILTER	MID		COUNTBLANK	VLOOKUP				WORKDAY
6	Mỗi bài tập có một mã gid là một dãy số #gid=xxxxxxxxxx Bạn thêm mã này vào đường link của Xtea http://excel.xtea.vn#gid=xxxxxxxxxx					INT	DAYS360		FORMULATEXT		MINUTE				RANDBETWEEN
7	NOT		MATCH					AND		TRIM	INT			PRODUCT				LEFT
8			IF				AVERAGEIFS	WEEKDAY			IF	TIMEVALUE		DATEDIF	IFERROR	AVERAGE			TODAY
9	INDEX	VALUETOTEXT		PROPER		DAYS360	REPT	LEFT	ISNUMBER		LOWER	DAYS360	MINIFS		FIND	ROUND		DATEVALUE	DATEVALUE
10	TRUE	WEEKDAY	MAXIF	MAX						MEDIAN		MOD	MAXIFS	PRODUCT	IFNA	MINIFS	MAX	IFNA	SUMPRODUCT
11	xteavn@gmail.com				WEEKNUM		WEEKDAY				MIN	WORKDAY	WEEKNUM		TIMEVALUE		MAX	MINUTE	SUM
12	ISERR		VALUE		AVERAGEIFS			IFERROR		WEEKNUM	CONCAT		MATCH	DATE					ROUND
13								SUMIFS	IFS				ISERR		ISERROR		LEFT	VALUETOTEXT	WEEKDAY
14	CHAR	IF	SUM	LEFT			ISERR			VLOOKUP		PROPER	AVERAGEIFS					COUNT	IF
15	DAYS		WORKDAY		AVERAGEA	NOT	FORMULATEXT		DAYS			VALUE			CHITEST	CHOOSE		CONCATENATE
16			ISNUMBER		VALUETOTEXT	ISERR			PRODUCT	IFERROR			WEEKDAY	SUMIFS			AND		VLOOKUP
17	VALUE	COUNTBLANK		VALUE	MID	SORT			DATEDIF	DATEDIF	ISERROR	CHAR			ROUND		AVERAGEIFS	ISFORMULA
18	DAYS360	LEN				FIND	ISNUMBER	LEN					VLOOKUP			SUM		COUNT
19									SUMIFS	COUNTIF		DAY	IFERROR			DATEVALUE		PROPER	FORMULATEXT
20		WORKDAY	PROPER			MAXA				COUNTA				ISERROR				COUNTA
21				DAYS				FILTER	MATCH	AVERAGEIF		MOD			AVERAGEIF		VALUETOTEXT		COUNTBLANK
22			VALUETOTEXT	AVERAGEIFS	LEN	VLOOKUP	DAYS360	MID	DAYS		COUNT			CHITEST		CONCAT
23		AVERAGEIF		PROPER	COUNT	TEXTJOIN	SUMPRODUCT		LOOKUP	DAYS360				ISFORMULA			INT	FIND	TEXT
24	CONCATENATE	WORKDAY		INT	ISFORMULA					TEXTJOIN	FILTER	SUM						MIN
25			FILTER		IFERROR	FORMULATEXT			LOWER	MINA				AVERAGEIF		DATEDIF		ROUND	MIN
26				TEXT		PROPER			SUMPRODUCT						IFNA	VLOOKUP		CHOOSE
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