Compute ABS(A) for all rows in the dataset

Find the sum of all absolute values in column A

Calculate FACT(C) for each row where C ≤ 10
Identify the row that produces the highest factorial value of C
Compute INT(A / B) for every row
Compute INT((A + C) / B) for each row
Find A MOD B for each row
Compute SUM(A, B, C) for every row
Compute the total SUM of all values in column B
Compute PRODUCT(A, B) for each row
Compute POWER(B, C) for each row with the constraint C ≤ 5
Compute the SQRT of column C for every row
Determine whether each value in column A is EVEN or ODD
Convert the values of column B into Roman numerals for each row
ID A B C
1 2 39 8
2 79 5 17
3 -8 22 12
4 -86 29 19
5 6 3 10
6 -29 12 9
7 88 26 5
8 -80 16 6
9 2 37 2
10 21 22 13
11 -26 29 6
12 -13 14 5
13 16 28 1
14 -1 5 6
15 3 47 6
16 51 49 16
17 30 30 4
18 49 46 11
19 -48 5 9
20 -99 12 3
21 -13 16 19
22 57 26 8
23 -63 26 5
24 29 48 4
25 91 21 6
26 87 39 2
27 -80 36 11
28 60 33 4
29 -43 30 15
30 -79 37 6
31 -12 23 17
32 -52 10 6
33 -42 5 19
34 69 36 2
35 87 34 15
36 -86 31 11
37 89 10 8
38 89 19 19
39 74 32 13
40 89 1 12
41 -50 5 5
42 7 45 6
43 -46 4 4
44 -37 16 19
45 30 24 1
46 -50 16 17
47 34 2 12
48 -80 49 15
49 -28 28 1
50 66 32 14
51 -83 27 6
52 31 20 5
53 -12 24 11
54 -41 12 4
55 -87 35 13
56 -92 33 11
57 -11 33 3
58 -48 43 1
59 29 37 6
60 -17 12 18
61 -9 3 10
62 10 1 5
63 87 33 10
64 98 40 12
65 71 10 2
66 -93 43 13
67 74 44 8
68 -66 29 2
69 -20 13 1
70 63 12 5
71 -51 31 9
72 3 46 17
73 31 2 9
74 -99 35 11
75 33 23 15
76 -47 17 6
77 5 26 3
78 -97 8 17
79 -47 29 5
80 90 26 12
81 45 10 18
82 -57 26 14
83 61 34 11
84 89 41 9
85 -87 7 2
86 -6 4 12
87 -53 45 3
88 -86 11 3
89 99 29 1
90 89 36 8
91 -61 25 8
92 -19 21 11
93 10 36 9
94 -48 10 5
95 -77 37 14
 96 53 9 3
97 87 24 5
98 23 35 5
99 -60 49 19
100 56 35 14
101 -86 48 4
102 -56 36 13
103 -36 18 10
104 -12 49 18
105 -30 39 8
106 -92 32 8
107 -13 24 7
108 28 23 8
109 35 32 14
110 -38 37 19
111 38 12 6
112 -20 49 1
113 35 13 15
114 62 23 1
115 62 25 17
116 -68 35 1
117 22 41 15
118 -96 30 2
119 -60 17 14
120 -73 49 8
121 34 20 8
122 -29 48 19
123 -89 25 7
124 61 22 19
125 -68 13 6
126 -53 19 6
127 50 49 3
128 -39 36 7
129 -64 12 19
130 -2 41 8
131 71 19 10
132 3 12 15
133 -66 9 15
134 92 7 1
135 0 28 7
136 74 14 4
137 30 31 6
138 -100 19 1
139 -96 47 5
140 41 16 1
141 2 5 4
142 -74 35 2
143 36 12 10
144 -86 25 5
145 -11 21 10
146 -59 36 1
147 23 23 6
148 78 16 13
149 -38 39 15
150 -5 45 4
151 -49 42 13
152 -5 39 15
153 31 14 8
154 50 31 5
155 42 5 15
156 70 35 4
157 -72 23 12
158 -65 29 13
159 -88 43 2
160 59 11 19
161 -30 18 19
162 86 47 4
163 -15 12 4
164 -73 9 11
165 -35 10 5
166 69 44 11
167 -56 17 10
168 -39 38 8
169 84 7 6
170 33 46 6
171 -73 13 8
172 -73 40 15
173 7 42 14
174 -57 9 11
175 -17 27 12
176 -71 2 13
177 89 5 8
178 -26 29 18
179 27 37 1
180 -9 38 15
181 89 19 8
182 28 8 11
183 20 48 12
184 -74 45 12
185 89 1 4
186 20 22 16
187 15 17 4
188 -98 7 5
189 2 25 5
190 97 45 8
191 99 4 10
192 54 36 17
193 36 6 9
194 -39 31 19
195 64 19 14
196 -50 44 8
197 71 39 9
198 51 27 11
199 -42 10 1
200 17 26 14
201 59 19 5
202 -5 39 14
203 79 3 4
204 12 45 1
205 -39 13 19
206 85 28 8
207 -49 20 15
208 -89 28 15
209 -62 8 9
210 29 41 9
211 30 39 10
212 12 1 9
213 0 3 3
214 12 13 11
215 83 28 6
216 -20 49 2
217 86 25 7
218 12 33 18
219 -99 38 2
220 29 6 17
221 -47 44 11
222 -14 45 12
223 28 32 19
224 46 45 7
225 25 47 6
226 29 21 1
227 -48 16 17
228 71 21 11
229 59 11 18
230 97 37 17
231 59 36 7
232 -33 35 17
233 82 19 9
234 83 20 17
235 22 18 8
236 44 47 17
237 -63 41 7
238 -77 49 1
239 -32 14 13
240 15 15 19
241 -3 31 19
242 97 1 17
243 38 3 13
244 43 16 16
245 -4 23 8
246 23 11 19
247 86 12 18
248 -31 10 1
249 -8 32 14
250 -98 16 19
251 47 8 15
252 86 38 18
253 63 12 2
254 46 24 17
255 -11 28 18
256 94 8 6
257 46 28 19
258 47 36 4
259 -5 26 1
260 98 8 8
261 -49 28 7
262 60 28 3
263 67 37 10
264 27 41 10
265 -62 36 19
266 -19 27 14
267 3 17 2
268 28 9 1
269 -90 33 18
270 84 20 7
271 77 13 8
272 50 28 1
273 58 48 3
274 -59 29 8
275 -2 13 15
276 -94 46 5
277 43 35 3
278 -11 6 19
279 11 18 1
280 -41 5 15
281 12 47 8
282 -99 25 2
283 28 2 3
284 -53 10 14
285 39 30 14
286 96 45 11
287 -64 5 16
288 59 33 4
289 -92 1 5
290 -2 18 14
291 46 32 16
292 -53 47 18
293 30 49 7
294 47 11 10
295 51 21 7
296 -47 26 1
297 19 25 19
298 60 22 16
299 51 27 19
300 15 49 4
301 -26 13 18
302 12 33 2
303 99 34 1
304 63 41 15
305 65 35 5
306 3 1 11
307 -17 21 10
308 11 48 2
309 -2 6 3
310 52 28 12
311 -8 17 5
312 45 5 5
313 27 31 6
314 9 5 9
315 -19 38 2
316 93 3 12
317 -47 23 3
318 62 37 12
319 88 37 17
320 68 10 10
321 60 10 14
322 -33 19 17
323 -68 17 18
324 41 21 19
325 -80 14 17
326 -53 9 14
327 47 46 9
328 27 1 8
329 35 45 2
330 34 13 13
331 94 4 7
332 44 1 9
333 27 49 11
334 -68 40 14
335 75 32 4
336 86 34 13
337 14 28 2
338 18 31 5
339 -79 8 11
340 57 39 6
341 -63 26 18
342 8 34 10
343 -50 3 4
344 81 12 9
345 -93 1 6
346 -74 44 2
347 -74 5 17
348 -80 30 5
349 -71 30 6
350 -4 17 12
351 -73 48 10
352 10 47 6
353 91 23 8
354 96 15 2
355 -40 37 12
356 -53 21 13
357 46 14 7
358 -97 2 10
359 -66 11 13
360 91 39 17
361 -52 38 14
362 -84 34 2
363 71 38 11
364 57 34 1
365 -55 18 19
366 16 30 4
367 -95 15 19
368 -2 27 11
369 23 34 8
370 -64 38 11
371 -77 33 4
372 -8 24 17
373 -55 15 7
374 80 30 8
375 -6 42 3
376 -2 17 2
377 87 5 15
378 15 29 5
379 90 4 1
380 59 10 4
381 60 17 15
382 -34 10 19
383 27 17 3
384 -83 20 11
385 -76 24 17
386 -47 5 13
387 -43 34 11
388 -34 6 2
389 3 2 9
390 73 13 2
391 -77 43 9
392 13 43 9
393 -69 48 8
394 74 11 17
395 -15 47 1
396 50 23 11
397 93 16 8
398 26 31 10
399 54 11 7
400 29 16 3
401 -84 8 3
402 3 4 18
403 60 40 5
404 36 4 12
405 -58 25 12
406 75 3 19
407 -62 32 6
408 69 3 2
409 -75 27 12
410 -2 29 19
411 -51 32 5
412 52 19 12
413 51 21 17
414 -88 5 17
415 -41 18 10
416 34 28 17
417 -44 42 15
418 -65 22 12
419 72 21 16
420 -81 6 19
421 -36 1 8
422 -93 5 17
423 43 41 5
424 41 12 16
425 14 26 6
426 42 46 8
427 -9 34 18
428 -3 49 12
429 -35 14 15
430 -69 26 9
431 90 45 13
432 -15 27 15
433 -50 9 10
434 52 26 16
435 85 47 7
436 -38 22 17
437 89 47 7
438 24 30 14
439 49 43 15
440 -43 48 7
441 -43 17 9
442 -15 26 19
443 -52 36 16
444 79 1 8
445 69 8 18
446 -31 49 18
447 -86 35 7
448 -47 15 3
449 87 47 18
450 0 22 10
451 -93 14 7
452 -48 26 17
453 -41 28 14
454 7 23 3
455 -96 14 12
456 2 24 13
457 95 2 2
458 -95 45 3
459 8 26 5
460 15 14 11
461 -7 7 8
462 -54 3 12
463 -2 47 7
464 -46 23 15
465 67 46 17
466 -49 43 4
467 43 47 13
468 -88 45 18
469 13 18 1
470 23 38 16
471 5 35 13
472 57 15 10
473 46 25 12
474 44 37 2
475 19 28 3
476 -38 10 10
477 -82 39 2
478 -9 17 13
479 -43 39 13
480 82 22 18
481 -11 26 3
482 16 44 7
483 -39 25 14
484 -78 17 17
485 26 13 12
486 36 20 16
487 39 25 12
488 28 4 15
489 -43 10 10
490 21 3 7
491 -100 41 5
492 -67 45 1
493 -5 18 17
494 25 47 3
495 17 36 13
496 -53 47 14
497 -12 22 18
498 16 34 4
499 28 47 18
500 -85 8 5
ID Name Score1 Score2 Category
1 cCecs 77 B
2 bIXAlpn 86 B
3 nBMxwbah 40 46 C
4 mrdJ 73 B
5 pJqZf 51 C
6 vHHJkqnP A
7 nrti B
8 RYAIeE 86 A
9 dRBT 73 99 A
10 dlTKZy 75 C
11 GzEUHq 73 86 C
12 AsGG 78 C
13 JTpQNqdN 64 B
14 CBIOWsI 32 A
15 dScwDKxn C
16 XBSkZFX A
17 UwrK 85 B
18 qiksGaNz B
19 ADQT 38 B
20 WvApZir 74 A
21 EAFXDm 71 C
22 cpNsz 85 45 C
23 YKxha 43 31 A
24 KRby 43 50 B
25 IvBQWjuJ 99 B
26 isPE 72 B
27 jMYR 70 54 C
28 GBrpaX 76 A
29 AQxE 47 55 B
30 ZUDzFDn B
31 UBCdoH A
32 ymoyNt 40 C
33 dkjpNMP 56 C
34 tvIa 46 97 C
35 tyGeH 83 37 C
36 KmEaKsPh 46 B
37 LdreQCd 93 A
38 XuRr 32 85 A
39 ohdOa 59 67 C
40 WWxgyu 84 33 C
41 DlcBSsY 41 B
42 EezA 75 A
43 ITnS 83 B
44 AiDTuVg 85 B
45 xRxNcTfn C
46 OPkn 96 91 B
47 XDnUu 60 B
48 iFoY 39 A
49 mgPKS 85 100 C
50 ZYhod 63 A
51 zfsL 97 34 C
52 HLoHFYz 70 C
53 JPWl 61 A
54 zsSBLR 81 C
55 JRfpFx 55 84 A
56 uiiBKoz 32 A
57 pvETVIcR 57 A
58 ULee C
59 ReVDJQ 58 B
60 JgmbiqeN 81 C
61 aMpPo B
62 JTufrSmU B
63 VHSSvJcm B
64 WfwhjD 83 31 B
65 Cyity 42 84 B
66 ioVHdCOO 93 B
67 DYDbU 96 88 C
68 aMDugXUD 89 C
69 JrlVgTr C
70 HtjM 84 B
71 lPqwY 34 55 B
72 WoTeQD 100 C
73 RXJtin 78 B
74 ByoEr 52 A
75 rOTVC 80 A
76 SaApulP B
77 DxgXkV A
78 jZEXdDR 85 B
79 gSGaN C
80 VpIY 100 A
81 dCoKuxId 41 A
82 IsBXQb B
83 KqPFaAJ A
84 bPiTQE 81 A
85 vbzsOXW B
86 IXuRDWZL 83 A
87 DIxTNAR C
88 gvTPHqU 60 C
89 zStFhrE 41 72 C
90 byXFB A
91 eIeaLm 59 44 A
92 BQZPVLK 85 A
93 GaJaGG 50 B
94 GSyVi 41 82 C
95 ToWXkDmI 54 A
 96 ITYIg 30 A
97 EyHc 54 C
98 HWIcyn C
99 kPjmofV 73 A
100 jijh 36 C
101 WTQQYIoA 85 B
102 kNam 79 48 C
103 CBNB 73 41 A
104 BlzDN B
105 qxqwE 38 52 A
106 WgIyysO 31 B
107 KAyv 43 B
108 kYGpJsH 48 C
109 ugKIFz C
110 TPXOy 87 38 B
111 SXoPN B
112 NYMPXk 81 B
113 MxmhHcP A
114 VLUsr 86 98 A
115 zNOqUt 62 A
116 IJDEO 50 B
117 gdCD 97 78 C
118 Qvdu 33 C
119 qsMHpqNh A
120 vTKcIp 62 C
121 pAOvNPY 78 A
122 avimfEC 57 C
123 TYhVCr 63 48 C
124 ZxvZfNx 59 48 C
125 tlcT B
126 NjzXZXRW 92 C
127 feXtbT 58 A
128 FfKDKQ 100 B
129 uAHYrGpa B
130 tjUVIQgY A
131 HhGR 97 C
132 HXWXlJ 58 C
133 KaKTDJfm 56 66 C
134 SBhvHGbL 76 B
135 QOTLTNL 46 69 B
136 jlfIe C
137 UDaoQxDf 36 80 A
138 nxWP A
139 FFLGpE 42 37 B
140 wcxk 68 C
141 bpYZtPp 60 100 B
142 VQRxh 44 B
143 aGuy 100 B
144 KknmHgVq 79 C
145 qIIp 31 66 C
146 EfQD 51 A
147 OLjhorC 66 A
148 ukWW A
149 vavrl 59 C
150 nLNZWg C
151 SAJH 46 42 B
152 BruOO 67 A
153 mOzdqVmu 53 B
154 wnjJrM A
155 yWfm C
156 uJrUDDL 41 42 C
157 YXpvqsN B
158 YEODFhol 53 A
159 BmEZtVW 85 B
160 FtXWhSzK 59 97 C
161 iFXJnP 61 C
162 plOZFNyO 80 B
163 xIaJ 85 A
164 cmliFMI C
165 jMZD 97 A
166 hokXbvoV 56 B
167 PfCrw B
168 HYkgdD 69 B
169 dvvEhue 45 66 C
170 FRBREWRO 80 64 A
171 KzoTdfM 93 A
172 uDobnmVM 41 B
173 mIttmhds 43 B
174 SjecDK C
175 FMUH A
176 wXEmi 46 A
177 kTSwmuSx 54 A
178 wIFAFixf 56 B
179 QQCIsu 40 A
180 oqUmXI 36 C
181 iNMzojh B
182 sYuSuSwg 31 91 A
183 pxansmfJ 70 89 B
184 urZvXfP 91 31 C
185 pduAS C
186 oEvT 92 41 B
187 uwfL 75 74 A
188 qWhFqUI 79 C
189 dVXO 50 A
190 UaBPeorg 83 C
191 mIxna 57 51 B
192 LHBiGw 80 C
193 pYFog 100 A
194 yCvq 89 A
195 uvvKHM 87 A
196 FhwCWsN A
197 oEumqv 63 79 C
198 cjZqm 37 C
199 aLnAUkTc 61 96 B
200 kescv 79 C
201 PRkZjoS 45 C
202 CxSSdi 37 81 A
203 RLVVohx 43 C
204 XeLwoH 100 72 A
205 eONxIK 55 B
206 gKSHZ 65 C
207 rqwsDr C
208 LbAP B
209 vkpMmpco 77 B
210 NmbCIZV 86 C
211 DNxAqfE 86 B
212 mGsw 60 C
213 etTGZDHW 78 A
214 Awgkb 71 97 C
215 LCkDUG 46 B
216 zcbZiJ C
217 lmXDq 73 A
218 IREbNXHi C
219 cXrJl A
220 gFGuDf 65 A
221 GwtkVb A
222 OvkKWrr 81 39 A
223 unbusbPP 71 85 C
224 UgKQ B
225 hQTxw 60 51 A
226 xXJzhVH 40 B
227 MBSSTtqs 34 81 B
228 Xkkkz 65 73 C
229 gjVpV 50 C
230 MkrBAYVx 50 A
231 yNJD 74 A
232 RdzIiJG 74 A
233 RhRTJIa 30 68 A
234 UsRDq 44 B
235 yVZNtU 34 55 C
236 SOBeEN 100 60 C
237 WvplcoX B
238 jGbBR 54 A
239 CJEzb 83 A
240 lVADYS 45 C
241 nHwWi 38 A
242 mRokUOcp 99 68 A
243 mthyjo 30 A
244 yMTdhHJI 70 A
245 aaaOrc A
246 BAjLT C
247 dcGTC 72 71 C
248 MttyYT 80 A
249 jBwu A
250 jhDBKgO 80 83 A
251 zAafIHy B
252 lshewhoS 92 57 C
253 RxtYgCe 57 B
254 TAnQ 83 C
255 nolcTO 69 C
256 QKTd A
257 WFkhs C
258 XHOUfhNt 39 44 A
259 eTxH 68 81 A
260 YRXgQsE 61 56 B
261 uBzwd B
262 tWecyd 61 B
263 RbOXDX C
264 aoYHIrP 47 69 C
265 fdPrnsnc 73 A
266 syNr 60 47 B
267 XAEY 56 C
268 wgwHWij 33 A
269 SlQko 86 76 A
270 HPtCq 74 A
271 SbXSpf 94 B
272 FsCBMSzR 67 A
273 xdCwcsl A
274 qJhfFtG 38 C
275 TnWLQ A
276 uTlrtJhW 45 88 A
277 CxpSR A
278 oUDWC 60 C
279 JHBWSMPl 59 B
280 TiNVkfCy A
281 QPEGqUXP 39 C
282 MXov 66 B
283 LKxuw 52 50 B
284 kJfrAW B
285 giXaH 30 B
286 nvUhU 89 B
287 HGzBPKL B
288 hxuOTbh 33 C
289 TwIR 86 C
290 aaQUm 32 B
291 wqBeq A
292 JgdT 46 44 B
293 CECoGRNY 33 67 C
294 mmlDBU 88 C
295 nSznSl 33 B
296 VPNB 73 A
297 vNRfrNLb 61 50 C
298 hdsq 65 B
299 qLlbDZ 78 B
300 MLdQ 63 C
301 xigTz A
302 opZx 91 B
303 BzvQSFzF 96 A
304 lafdcgAd 55 73 A
305 DMybr A
306 TRqlq B
307 ojngOBZ 82 32 A
308 mDMpX 81 B
309 teZTFS 33 A
310 mrQAlDE 57 A
311 SPYCNSdA 100 C
312 dXHLV C
313 SHGNxOlc 70 88 B
314 ddTq 56 B
315 bnpktL 38 B
316 FTyDKS A
317 ZzLw 34 B
318 yNemaz 94 A
319 fXSl B
320 fRjysbE 87 B
321 VfKDc 36 82 B
322 viVgkny 94 98 B
323 pgLqi A
324 DExPOhWC 62 38 C
325 wGscX A
326 pyMscn B
327 PPqX 95 A
328 ZiYvyY 72 B
329 xXcU 78 A
330 BjwujMWG 69 C
331 DakdW 50 C
332 EHjo 93 38 C
333 ooNvmIPh 98 B
334 pjNrgs C
335 lhzNYcuy C
336 obiYPI 66 C
337 gPGUx 85 A
338 UokfUB 40 B
339 hjxB 48 B
340 XwtXwhwr 83 72 B
341 DcwhETF A
342 OiwgKQW A
343 gOemW 94 B
344 iIFT 99 44 A
345 eMRiM A
346 oEsE 39 A
347 zrodX 70 C
348 mmsedUr B
349 uLzpgD B
350 sUEYUp 58 A
351 nZUWJPqx 82 C
352 KSgk 60 94 B
353 pHXCCRD 42 76 B
354 WgAyFpn 68 A
355 XucUor 43 99 A
356 GPubADs 62 61 B
357 ZeJDtyV 94 71 A
358 bjpTnzs C
359 uqFXDgT 69 A
360 Thnxe 89 A
361 hjsAcT B
362 AMSF B
363 AeMTm 76 B
364 ARrpYq B
365 onUim 97 A
366 VAgjQ 52 A
367 qcWuv 69 C
368 gXZA B
369 ClWo 54 55 A
370 BvEAn 90 C
371 XQwoZOe C
372 tfhh 88 B
373 ADGJ C
374 iyiM 41 92 C
375 rEArSFmC B
376 kSLKZ C
377 IwMgQX 79 99 B
378 dDgcmnZ 63 A
379 TbBa A
380 LWrQmpai 56 A
381 fhmX 83 A
382 KAlZZ 43 C
383 EQkALjNV 55 A
384 VIpLg 56 B
385 dRAC 85 54 C
386 eZtQi 38 A
387 TFyzd 46 31 A
388 XoUV 55 80 B
389 GDIA 51 C
390 PlQfj C
391 FdeBqEc 59 B
392 Iddc 76 B
393 LMaq 41 61 B
394 CFFMR 66 56 C
395 mtyutH 69 B
396 xpFNqA 40 75 C
397 AMHRBFm 69 B
398 lihPr 70 C
399 abOW B
400 WMZXVGb 71 C
401 iGhfYyHT 70 B
402 ipVBG C
403 deczyz B
404 CgBCUvaN B
405 ljTbKfbd 50 40 C
406 xkBxxF 33 B
407 shPdcSA B
408 aSXtnaDb 92 59 B
409 vMdrD C
410 pxeSZ 32 52 C
411 XbrusB 53 B
412 hGFXlKh 94 B
413 oGiYme 93 C
414 fXvk 51 C
415 IZNjdP 78 45 B
416 HnVWmc 91 58 A
417 ZpDIFp 68 C
418 HLyZcQIi 40 B
419 AFatT 43 A
420 Lmth A
421 kVzqsOs 31 A
422 GNKGlPFN 45 B
423 nsiHbVb C
424 ZBcxdp C
425 HOceSB B
426 SPSG A
427 QJIrxz 78 C
428 zjfu 90 A
429 rgmUBSy C
430 axst A
431 DAdH 75 A
432 WuGD A
433 HFfUv 66 56 B
434 ujaMkmFw 87 84 A
435 rHeUCP A
436 LChIVguF 35 72 A
437 FQvgK 85 A
438 IXWIfL B
439 fOhGGGt 83 52 C
440 rHZxxR 90 75 C
441 JWmkXKTb 51 85 C
442 pCffnnt C
443 TReggHeO 36 C
444 oULoC 56 B
445 wSbzcuBz 96 39 B
446 kkKsg 94 C
447 XGwQ 93 C
448 nOVkJ C
449 MnMv 37 84 A
450 MUpvnwCa 63 C
451 zlnFD 52 B
452 DmIYtg 41 63 A
453 mPkISZ 35 B
454 zpWZZ 55 B
455 FrEtKpa 48 47 B
456 rQQjBKZ 61 98 A
457 PUzPLDx B
458 VdjiF 64 B
459 JPMMXCI 87 46 B
460 HLRXSHg 56 B
461 VcjWpJ 42 B
462 nEzgKJ 80 62 A
463 KmVeW 57 A
464 gVfSAfK 54 36 B
465 qUEk 100 C
466 rjsANd 90 C
467 oUVWB 100 30 B
468 ysncO 47 B
469 ioEDwwfI 57 B
470 uxitSc B
471 rOFGst A
472 BwafU 73 96 B
473 RMipScx C
474 mPaOR B
475 Imaa 48 72 A
476 CPvBD 89 B
477 snJBeYkU 94 A
478 iRyce 94 C
479 vEhcooq 61 90 B
480 ryNlIQBF B
481 EVTKPTA C
482 oWgP 56 C
483 rCNCjv 69 C
484 RFheCz 35 99 A
485 dkXpLDd 62 40 A
486 gQEnQ 63 C
487 XtjLSk 85 C
488 WGdVjgkw B
489 nzkjZ 63 B
490 BMbzEcLf 73 B
491 IigVa 60 B
492 YErBrZ 85 B
493 XqWFdm 40 95 C
494 CnSFbiVi 100 C
495 zacCy 45 69 A
496 KUsmXba 50 86 B
497 hzQO 86 A
498 bYljyPqA 60 A
499 rrhvE 52 A
500 LjBbg 74 B
Find the AVERAGE of Score1 for all students
Find the MIN value in Score1
Find the MAX value in Score2
Count how many numerical entries are present in Score2 using COUNT
Count how many non-empty cells are in the Name column using COUNTA
Convert all names in the Name column to LOWER case
Convert all names in the Name column to UPPER case
Convert each name in the Name column to PROPER case
Find the LEN (number of characters) of each name
Extract the first three characters of each name using LEFT
Extract the last two characters of each name using RIGHT
Extract characters 2 to 4 from each name using MID
Repeat each name 3 times using REPT
Check whether the name in each row is EXACTly equal to “alice”
Convert each Score1 value into a currency format using the DOLLAR function
CONCATENATE the Name and Category columns together for each row
Return the character represented by ASCII code 65 using CHAR
Return the ASCII code of the first letter of each name using CODE
Using IF, display “PASS” if Score2 ≥ 80, otherwise “FAIL”
Using AND, check which rows have both Score1 ≥ 50 AND Score2 ≥ 80
Using OR, check which rows have Score1 ≥ 60 OR Score2 ≥ 85
Using NOT, invert the result of “Score1 > 60”
Using ISTEXT, check which values in the Category column are text
Using ISNUMBER, check which values in Score1 are numeric
Using ISLOGICAL, check whether the result of Score1 > Score2 returns a logical value
Using ISBLANK, identify which cells in Score1 or Score2 are blank