Materi microsoft excell

1
2
3
4
5
6

eri microsoft excell

nilai mentah
No

Reg
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

F
19030194001 ADILAH
19030194002 AHMAD
19030194003 AJENG
19030194004 ALIF
19030194005 ALIFIA
19030194006 ALIS
19030194007 AMALIA
19030194008 ANGGRAENI
19030194009 ANITA
19030194010 DIANA
19030194011 ELFA
19030194012 ELVA
19030194013 FATIMAH
19030194014 HAJAR
19030194015 HIKMATUL
19030194016 INTAN
19030194017 KHINANJAR
19030194018 LAILA
19030194019 LAILATUL
19030194020 LIKAYATI
19030194021 LINA
19030194022 LUCKY
19030194023 LUTFI
19030194024 LUTHFIATU
19030194025 MONIQSA
19030194026 N.RIZKA
19030194027 NITA
19030194028 NOVIA
19030194029 NUR
19030194030 NUURONIATUS
19030194031 PUTRI
19030194032 RADIAN
19030194033 RAHMANIA
19030194034 RINDA
19030194035 RISMA
19030194036 ROCHMATUL
19030194037 SETYORINI
19030194038 SUPRIANTO
19030194039 TRESIA
19030194040 USWATUN
19030194041 VANESHA
19030194042 WAHYU

kelas
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A

PART

TUGAS1
76
83
77
83
82
82
80
83
76
78
75
84
85
80
83
81
79
78
76
82
77
84
79
78
85
85
79
79
85
79
82
76
85
85
76
85
84
83
83
79
76
81

TUGAS2
84
77
88
79
85
92
82
91
78
72
79
72
95
84
88
86
72
79
75
77
89
84
80
86
95
72
74
79
87
78
94
77
84
75
73
73
92
83
87
85
88
92

83
65
60
72
84
88
78
60
71
67
75
61
80
75
73
88
86
71
84
93
65
87
84
79
63
65
67
62
85
71
60
79
69
90
63
67
65
69
70
90
79
60

43

19030194043 WIGAR

44

19030194044 WIKE

45

19030194045 WILDHA

46

19030194046 YULYANA

47

19030194047 ZAIMATUL

48

19030194048 AFIFATUL

49

19030194049 ALIYYU

50

19030194050 ALLIFAH

51

19030194051 ANISAH

52

19030194052 ANNISAA

53

19030194053 ARIZHA

54

19030194054 BARIROH

55

19030194055 BINAR

56

19030194056 CHOIRUN

57

19030194057 CIKO

58

19030194058 CINDY

59

19030194059 CITRA

60

19030194060 DESNI

61

19030194061 DEVI

62

19030194062 ELLY

63

19030194063 ERNA

64

19030194064 ERNITA

65

19030194065 ESA

66

19030194066 EWING

67

19030194067 FIBRI

68

19030194068 FIRDA

69

19030194069 IIN

70

19030194070 IRIENE

71

19030194071 KOMANG

72

19030194072 MOCHAMAD

73

19030194073 NOVITA

74

19030194074 NURUL

75

19030194075 PROMES

76

19030194076 RATIH

77

19030194077 RENI

78

19030194078 SOPHIA

79

19030194079 SRI

80

19030194080 SYAHIRUL

81

19030194081 TARISA

82

19030194082 VANANTIA

83

19030194083 WINDHA

84

19030194084 YESSI

85

19030194085 YULIA

86

19030194086 ALIEF

87

19030194087 AMIROTUL

A
A
A
A
A
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
C
C

78
78
75
80
83
76
80
84
84
77
78
85
78
84
82
81
81
76
75
80
85
77
78
83
77
77
85
83
81
80
78
79
83
83
84
85
78
85
76
82
75
80
78
82
82

82
95
88
75
77
84
72
76
89
84
89
76
95
93
80
74
95
86
72
84
75
88
70
79
86
70
89
70
71
87
70
84
72
70
79
93
84
84
91
80
84
89
84
70
92

73
91
69
67
89
87
95
82
62
66
91
74
77
90
67
75
79
78
70
91
87
85
80
76
75
81
92
89
60
61
62
94
73
92
95
61
76
85
67
94
61
77
76
75
63

88

19030194088 APRILIA

89

19030194089 AURA

90

19030194090 BAHRUL

91

19030194091 BUNGA

92

19030194092 CITA

93

19030194093 DESIANA

94

19030194094 DHEA

95

19030194095 DWI

96

19030194096 ELSA

97

19030194097 ERY

98

19030194098 FIKRIA

99

19030194099 GRESIANA

100

19030194100 IHDA

101

19030194101 IKA

102

19030194102 ISMATUL

103

19030194103 LILIS

104

19030194104 LINDA

105

19030194105 LUKY

106

19030194106 M

107

19030194107 MEIDA

108

19030194108 NIDYA

109

19030194109 NURIKA

110

19030194110 NURMAR'ATUS

111

19030194111 RISNA

112

19030194112 SITI

113

19030194113 SOFIE

114

19030194114 TRIANI

115

19030194115 VINDHY

116

19030194116 YANTI

117

19030194117 ALFANAHDIA

118

19030194118 AMILIA

119

19030194119 ANDINA

120

19030194120 ANGGORO

121

19030194121 ANJANI

122

19030194122 ARYSTA

123

19030194123 ASTRI

124

19030194124 AUDINA

125

19030194125 AYU

126

19030194126 DATIN

127

19030194127 DEFIARI

128

19030194128 DEVON

129

19030194129 DIAH

130

19030194130 DIAN

131

19030194131 DIMAS

132

19030194132 DINI

C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

83
85
82
75
77
81
80
83
85
78
84
80
80
83
82
77
85
78
83
81
85
83
75
78
76
82
84
81
83
85
77
82
76
85
75
83
76
84
82
81
85
76
84
75
76

77
91
90
78
95
86
83
92
72
90
88
89
84
72
84
83
87
77
73
73
93
90
73
91
91
78
84
73
94
94
89
87
87
77
74
83
80
92
89
78
76
74
74
77
88

89
75
67
90
81
83
76
72
63
94
88
86
68
85
92
82
82
82
69
71
68
66
86
60
69
89
89
91
77
72
77
78
61
73
75
85
71
83
87
66
66
89
61
81
66

133

19030194133 DITTA

134

19030194134 ERLIA

135

19030194135 ERVIN

136

19030194136 ERVITA

137

19030194137 HABIBAH

138

19030194138 HIMATUL

139

19030194139 IMROATUL

140

19030194140 ISTIMATUS

141

19030194141 JUMROTUL

142

19030194142 KHOIRUL

143

19030194143 LENI

144

19030194144 MAULATY

145

19030194145 MEY

146

19030194146 NADIA

147

19030194147 NAILIS

148

19030194148 NENSA

149

19030194149 OKA

150

19030194150 PRAMITA

151

19030194151 RAFFANI

152

19030194152 REAPRILYAN

153

19030194153 REKA

154

19030194154 RIFKOTIN

155

19030194155 RINA

156

19030194156 RIZA

157

19030194157 ROCHMAH

158

19030194158 SANTOSO

159

19030194159 SYAHROTUL

160

19030194160 SYIFA

161

19030194161 ULIYA

162

19030194162 VINNA

163

19030194163 VITA

164

19030194164 VIVIN

165

19030194165 WINDA

166

19030194166 YUNIA

167

19030194167 YUNIAR

168

19030194168 YUNY

169

19030194169 ZOIMATUL

D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

84
84
84
84
81
82
81
82
82
80
84
79
76
85
84
81
78
76
84
77
78
78
77
79
75
78
85
83
75
82
80
76
83
79
78
83
85

88
89
77
94
74
95
90
73
82
93
79
86
83
82
76
92
93
78
94
83
82
95
90
92
81
71
84
85
78
92
79
75
72
87
90
90
72

72
79
63
77
72
72
67
77
89
85
80
73
72
77
79
69
89
87
91
60
80
79
87
95
89
82
72
79
81
80
78
70
75
69
74
66
60

TUGAS3

USS1
76
61
85
70
100
86
62
55
69
70
56
58
66
86
81
78
68
74
99
87
50
93
75
90
68
64
91
51
62
77
83
63
51
82
89
93
67
59
87
58
59
82

USS2
61
43
92
60
69
53
84
71
47
77
62
77
88
81
72
93
73
86
78
54
78
77
66
82
73
86
79
74
49
47
68
47
61
50
40
75
83
53
77
49
53
97

91
79
42
75
48
47
66
49
49
90
94
96
93
61
55
60
87
59
43
82
79
72
63
77
79
57
85
61
79
84
70
62
61
62
63
64
59
96
100
88
75
47

UAS
55
85
34
58
37
93
65
79
97
69
86
30
98
74
50
91
62
71
30
38
74
34
30
73
74
55
34
85
30
39
69
38
78
88
74
31
63
94
81
79
30
80

57
100
63
76
77
64
53
99
77
60
60
54
92
53
59
51
78
79
52
92
66
98
78
66
57
64
71
56
50
79
80
87
99
54
92
99
74
51
50
91
77
94
92
76
86

90
41
60
100
64
79
74
80
94
66
45
67
45
82
60
62
74
90
86
97
98
53
73
73
79
79
83
87
50
88
59
50
42
79
51
95
42
56
85
78
66
73
64
97
96

69
93
84
76
66
77
95
52
83
88
84
70
42
56
77
60
100
84
83
88
58
41
94
48
100
86
92
74
52
78
62
82
65
94
56
83
94
63
51
69
98
95
68
46
48

59
62
56
83
46
41
98
83
61
56
56
88
50
54
94
47
98
65
74
100
71
71
43
32
93
60
87
72
77
72
32
45
69
56
64
72
100
62
72
37
61
72
64
43
84

79
78
93
79
54
70
51
56
64
90
73
82
93
57
52
69
58
86
84
56
82
69
100
50
99
80
88
95
65
71
69
99
60
90
65
69
64
50
77
61
75
68
56
88
79

69
68
53
71
86
72
59
85
47
55
65
40
56
69
84
53
52
81
94
90
82
48
64
95
95
94
58
49
79
47
99
60
61
59
73
61
45
70
96
74
90
50
55
69
54

54
57
43
53
51
43
79
59
83
69
77
73
40
52
73
72
100
78
98
94
96
98
57
50
100
88
75
88
82
70
99
85
46
94
47
64
68
55
82
83
98
77
71
73
65

81
82
80
55
63
64
72
71
97
44
52
44
98
36
51
56
32
69
42
65
93
80
99
57
77
58
95
53
37
89
50
74
38
95
73
37
34
73
70
85
90
88
88
76
45

72
92
93
89
66
61
100
91
51
85
82
100
86
52
52
56
88
92
87
76
83
63
84
97
59
75
68
95
78
83
82
81
70
72
80
72
53

61
80
96
83
49
90
64
70
80
47
47
91
44
61
79
80
48
97
95
50
47
67
56
46
50
42
77
49
97
48
54
47
75
96
47
53
83

82
42
56
97
96
61
46
75
46
93
83
45
58
67
93
90
70
97
44
46
97
54
77
47
83
73
48
46
95
70
52
60
40
77
73
70
46

55
66
54
39
35
31
74
74
54
69
83
60
41
84
45
85
99
67
42
84
71
59
74
48
64
56
85
47
37
79
92
84
53
61
50
86
66

Berdasarkan data mentah, lengkapi tabel beikut dengan formula +, /, average, IF

No

Reg
Nama
1 19030194001 ADILAH
2 19030194002 AHMAD
3 19030194003 AJENG
4 19030194004 ALIF
5 19030194005 ALIFIA
6 19030194006 ALIS
7 19030194007 AMALIA
8 19030194008 ANGGRAENI
9 19030194009 ANITA
10 19030194010 DIANA
11 19030194011 ELFA
12 19030194012 ELVA
13 19030194013 FATIMAH
14 19030194014 HAJAR
15 19030194015 HIKMATUL
16 19030194016 INTAN
17 19030194017 KHINANJAR
18 19030194018 LAILA
19 19030194019 LAILATUL
20 19030194020 LIKAYATI
21 19030194021 LINA
22 19030194022 LUCKY
23 19030194023 LUTFI
24 19030194024 LUTHFIATU
25 19030194025 MONIQSA
26 19030194026 N.RIZKA
27 19030194027 NITA
28 19030194028 NOVIA
29 19030194029 NUR
30 19030194030 NUURONIATUS
31 19030194031 PUTRI
32 19030194032 RADIAN
33 19030194033 RAHMANIA
34 19030194034 RINDA
35 19030194035 RISMA
36 19030194036 ROCHMATUL
37 19030194037 SETYORINI
38 19030194038 SUPRIANTO
39 19030194039 TRESIA
40 19030194040 USWATUN

Kelas
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A

PART

TUGAS

USS

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

19030194041 VANESHA
19030194042 WAHYU
19030194043 WIGAR
19030194044 WIKE
19030194045 WILDHA
19030194046 YULYANA
19030194047 ZAIMATUL
19030194048 AFIFATUL
19030194049 ALIYYU
19030194050 ALLIFAH
19030194051 ANISAH
19030194052 ANNISAA
19030194053 ARIZHA
19030194054 BARIROH
19030194055 BINAR
19030194056 CHOIRUN
19030194057 CIKO
19030194058 CINDY
19030194059 CITRA
19030194060 DESNI
19030194061 DEVI
19030194062 ELLY
19030194063 ERNA
19030194064 ERNITA
19030194065 ESA
19030194066 EWING
19030194067 FIBRI
19030194068 FIRDA
19030194069 IIN
19030194070 IRIENE
19030194071 KOMANG
19030194072 MOCHAMAD
19030194073 NOVITA
19030194074 NURUL
19030194075 PROMES
19030194076 RATIH
19030194077 RENI
19030194078 SOPHIA
19030194079 SRI
19030194080 SYAHIRUL
19030194081 TARISA
19030194082 VANANTIA
19030194083 WINDHA
19030194084 YESSI
19030194085 YULIA

A
A
A
A
A
A
A
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B
B

86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130

19030194086 ALIEF
19030194087 AMIROTUL
19030194088 APRILIA
19030194089 AURA
19030194090 BAHRUL
19030194091 BUNGA
19030194092 CITA
19030194093 DESIANA
19030194094 DHEA
19030194095 DWI
19030194096 ELSA
19030194097 ERY
19030194098 FIKRIA
19030194099 GRESIANA
19030194100 IHDA
19030194101 IKA
19030194102 ISMATUL
19030194103 LILIS
19030194104 LINDA
19030194105 LUKY
19030194106 M
19030194107 MEIDA
19030194108 NIDYA
19030194109 NURIKA
19030194110 NURMAR'ATUS
19030194111 RISNA
19030194112 SITI
19030194113 SOFIE
19030194114 TRIANI
19030194115 VINDHY
19030194116 YANTI
19030194117 ALFANAHDIA
19030194118 AMILIA
19030194119 ANDINA
19030194120 ANGGORO
19030194121 ANJANI
19030194122 ARYSTA
19030194123 ASTRI
19030194124 AUDINA
19030194125 AYU
19030194126 DATIN
19030194127 DEFIARI
19030194128 DEVON
19030194129 DIAH
19030194130 DIAN

C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
C
D
D
D
D
D
D
D
D
D
D
D
D
D
D

131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169

19030194131 DIMAS
19030194132 DINI
19030194133 DITTA
19030194134 ERLIA
19030194135 ERVIN
19030194136 ERVITA
19030194137 HABIBAH
19030194138 HIMATUL
19030194139 IMROATUL
19030194140 ISTIMATUS
19030194141 JUMROTUL
19030194142 KHOIRUL
19030194143 LENI
19030194144 MAULATY
19030194145 MEY
19030194146 NADIA
19030194147 NAILIS
19030194148 NENSA
19030194149 OKA
19030194150 PRAMITA
19030194151 RAFFANI
19030194152 REAPRILYAN
19030194153 REKA
19030194154 RIFKOTIN
19030194155 RINA
19030194156 RIZA
19030194157 ROCHMAH
19030194158 SANTOSO
19030194159 SYAHROTUL
19030194160 SYIFA
19030194161 ULIYA
19030194162 VINNA
19030194163 VITA
19030194164 VIVIN
19030194165 WINDA
19030194166 YUNIA
19030194167 YUNIAR
19030194168 YUNY
19030194169 ZOIMATUL

D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D

US

NA

LULUS?

HURUF

KETENTUAN NA
Nilai
Lulus?
85 N 100 L
80 N < 85 L
75 N < 80 L
70 N < 75 L
65 N < 70 L
60 N < 65 TL
55 N < 60 TL
40 N < 55 TL
0 N < 40
TL

NTUAN NA
Huruf
A
AB+
B
BC+
C
D
E

Hitung jumlah dengan formula countif

No

No

Kelulusan Jumlah
1L
2 TL
Jumlah

SEMUA KELAS
Nilai
Jumlah
1A
2 A3 B+
4B
5 B6 C+
7C
8D
9E
Jumlah

KELAS A
Nilai
Jumlah
1A
2 A3 B+
4B
5 B6 C+
7C
8D
9E
Jumlah

Tuliskan kelas dan nilai dengan menggunakan formula vlookup

Reg
Nama
1 19030194001 ADILAH
2 19030194048 AFIFATUL
3 19030194002 AHMAD
4 19030194003 AJENG
5 19030194117 ALFANAHDIA
6 19030194086 ALIEF
7 19030194004 ALIF
8 19030194005 ALIFIA
9 19030194006 ALIS
10 19030194049 ALIYYU
11 19030194050 ALLIFAH
12 19030194007 AMALIA
13 19030194118 AMILIA
14 19030194087 AMIROTUL
15 19030194119 ANDINA
16 19030194120 ANGGORO
17 19030194008 ANGGRAENI
18 19030194051 ANISAH
19 19030194009 ANITA
20 19030194121 ANJANI
21 19030194052 ANNISAA
22 19030194088 APRILIA
23 19030194053 ARIZHA
24 19030194122 ARYSTA
25 19030194123 ASTRI
26 19030194124 AUDINA
27 19030194089 AURA
28 19030194125 AYU
29 19030194090 BAHRUL
30 19030194054 BARIROH
31 19030194055 BINAR
32 19030194091 BUNGA

Kelas

Nilai