Week 24 · June 2026
Weekly Excel Challenge
A new challenge drops every Monday. Solve it with the fewest attempts and fastest time to top the leaderboard.
Beginner⚡ 150 XP⏱ ~10 min
Time remaining
03
:
14
:
22
DAYSHRSMIN
Challenge #24 · This Week
Monthly Sales Summary
You're the sales analyst at NovaCorp. Your manager needs a summary of Q1 performance. Use the raw sales data below to calculate totals, averages, and identify the top-performing month.
1
In B8 — SUM total Q1 sales
2
In C8 — AVERAGE monthly sales
3
In D2 — Use MAX to find the best month
Spreadsheet
B8
fx
ABCD
1MonthSales ($)% of QuarterBest Month?
2January48,20032.1%
3February39,50026.3%
4March62,30041.5%
5
6SummaryValue
7Total Q1
8Monthly Avg
🏆 This Week's Leaderboard
1
JK
James K.
150 XP
2
SL
Sofia L.
130 XP
3
AM
Alex M.
120 XP
4
RK
Rita K.
110 XP
5
PR
Priya R.
100 XP
—
AH
You
—
📅 Past Challenges
📊
Week 23 — VLOOKUP product prices
+120
Done
📈
Week 22 — IF bonus calculator
+90
Done
🔢
Week 21 — COUNTIF survey data
—
Missed
💰
Week 20 — Budget variance
+140
Done
💡 Hint
Click the hint button to reveal. Costs 10 XP.