ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
National Excel Championships 2026
3
4
My Favorite Functions in ExcelCase Author
5
6
7
8
9
10
11
12
Andrew Grigolyunovich
13
14
Instructions
15
In this case study, I wanted to share a couple of my favorite Excel functions for the last qualification round of the National Excel Championships. Each level in this case study is independent of other levels. The seasoned Excel pros might find this case study to be on the easier side, but we wanted to make it accessible to the novice players joining the community from all over the world. We have also provided hints for some of the levels to help new players select the right Excel function to solve these levels efficiently.
16
17
18
19
20
Bonus Questions
21
22
To make the game more exciting, we have created 5 bonus questions for you.
23
24
Game #Relates to Level #PointsAnswerQuestion
25
Bonus 1Level 1350There are 200 numbers given for Level 1 (excluding Example1). Of these, sum only those numbers that are equal to or larger than 50. What is the sum of such numbers?
26
Bonus 2Level 2400How many letters "K" are there in the 20 text strings provided for Level 2 (excluding Example2)? Ignore the capitalization - both "K" and "k" should be counted.
27
Bonus 3N/A450How many letters "E" are there in the Dataset (see "Dataset" tab)? Ignore the capitalization - both "E" and "e" should be counted.
Note that column labels (blue cells in row 5) are not a part of the dataset.
28
Bonus 4N/A600What is the sum of all the numbers in the Dataset?
Note that row labels (blue cells in column B) are not a part of the dataset.
29
Bonus 5N/A700What is the sum of all the odd numbers in the Dataset (i.e., numbers 1, 3, 5, 7 and 9)?
Note that row labels (blue cells in column B) are not a part of the dataset.
30
31
Questions
32
33
Level 1Very EasyCurrent Score
34
0
35
What is the sum of the 10 numbers provided for each of the games below?
36
Hint: You might use the =SUM() function.
37
38
Example1:
39
The sum of the numbers is 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10 = 55.
40
41
Game #1 Hint: The correct answer is between 680 and 685.
42
Game #2 Hint: The correct answer is between 395 and 400.
43
Game #3 Hint: The correct answer is between 675 and 680.
44
45
Game #LevelPointsAnswer12345678910
46
47
Example11055112345678910
48
49
11407654929860497129695
50
2140318234232465634186
51
3140514521367371929595100
52
41405483865864175455228
53
514085926271451146619786
54
614011681114358672563072
55
71406117444463333538140
56
814040401842876510841235
57
914056306354886677493719
58
1014039732222765467829136
59
1114086692962741798998451
60
121404189769260942155843
61
1314091409219308595344997
62
1414041847011901323883859
63
1514075501743932849442836
64
161404414555784234173760
65
1714054826770132230517082
66
1814094117169976598966627
67
19140877192065862260259
68
2014021669827705569891935
69
70
71
Level 2Easy
72
73
Return the first 4 characters of the text provided.
74
Hint: You might use the =LEFT() function.
75
76
Example2:
77
The first 4 characters in "Microsoft Excel World Championship" are "Micr".
78
79
Game #LevelPointsAnswerText
80
81
Example220Micr1Microsoft Excel World Championship
82
83
21250XLOOKUP
84
22250Power Query
85
23250Spreadsheet Ninja
86
24250Formula Racing
87
25250Dashboard Design
88
26250VBAWizardry
89
27250Financial Modeling
90
28250Conditional Formatting
91
29250Data Crunching
92
30250Keyboard Speedrun
93
31250Cell Mastery
94
32250Dynamic Arrays
95
33250Excel Arena
96
34250Formula Fighter
97
35250Spreadsheet Olympics
98
36250Data Visualization
99
37250Excel Esports Championship
100
38250Lookup Legends