Loading…
Loading…
What you will build: Weighted final scores, letter grades, ranks, class statistics, a grade distribution with chart, failing scores highlighted, and the list sorted best first.
Education
You teach class 10B. Term marks for 30 students are in: two homeworks, a project and an exam, each out of 100. The weights are in row 33 and the grade boundaries in M1:N6. Produce final scores, grades and ranks, a class summary and a grade distribution chart for the parents’ evening.
Premium includes all 12 projects, every advanced lesson and certificates. Already Premium? Sign in to open it.
Weighted final scores, letter grades, ranks, class statistics, a grade distribution with chart, failing scores highlighted, and the list sorted best first. Every step is checked automatically, with hints when you get stuck.
Type Final in F1 and fill F2:F31 with each student’s weighted score: SUMPRODUCT of the four marks and the weights in B33:E33.
15 points
Type Grade in G1 and fill G2:G31 using the boundaries in M2:N6 (approximate match).
15 points
Type Rank in H1 and fill H2:H31 with each student’s rank (highest final = 1).
10 points
Q1: class average of the finals. Q2: the median. Q3: how many finals are 50 or more. Q4: the name of the top student.
15 points
Q8:Q12: how many students got each grade in P8:P12.
10 points
Highlight the finals in F2:F31 that are less than 50.
10 points
Insert a bar chart of P7:Q12 titled Grade distribution.
10 points
Sort the class list A1:H31 by Final, highest first.
15 points
New to any of these? Each one is a free or Premium lesson you can do first.
FluentExcel project · Personal finance
Personal Budget
9 steps · 40 rows of data · 10 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Date | Category | Description | Amount | Type | Summary | Category | |||
| 2 | 1/1/2026 | Salary | Salary | $2,100.00 | Income | Total income | 4730 | Rent | ||
| 3 | 1/1/2026 | Rent | Monthly rent | $1,250.00 | Expense | Total expenses | 3188.76 | Groceries | ||
| 4 | 1/1/2026 | Utilities | Electricity | $115.64 | Expense | Net savings | 1541.24 | Transport | ||
| 5 | 1/1/2026 | Entertainment | Streaming | $29.76 | Expense | Savings rate | 33% | Utilities | ||
| 6 | 1/1/2026 | Groceries | Corner shop | $105.00 | Expense | Dining | ||||
| 7 | 1/1/2026 | Dining | Coffee | $30.63 | Expense | Entertainment | ||||
| 8 | 1/1/2026 | Groceries | Supermarket | $32.17 | Expense | |||||
| 9 | 1/2/2026 | Groceries | Corner shop | $92.91 | Expense | |||||
| 10 | 1/2/2026 | Entertainment | Cinema | $31.06 | Expense | |||||
| 11 | 1/4/2026 | Groceries | Corner shop | $59.02 | Expense |
Spent
Personal finance
Personal Budget
9 steps · 1.5 h
FluentExcel project · Project management
Project Tracker
8 steps · 40 rows of data · 125 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Task | Owner | Start | Due | Status | Priority | Work days | Days left | Flag | |
| 2 | Design dashboard | Tom | 4/4/2026 | 4/7/2026 | In progress | Low | 2 | -8 | Overdue | |
| 3 | Build API endpoint | Sara | 3/25/2026 | 3/31/2026 | Done | High | 5 | -15 | ||
| 4 | Test reports | Priya | 3/26/2026 | 3/30/2026 | Done | Medium | 3 | -16 | ||
| 5 | Review login page | Lena | 4/15/2026 | 5/6/2026 | In progress | High | 16 | 21 | ||
| 6 | Document settings | Sara | 3/28/2026 | 4/18/2026 | Not started | Low | 15 | 3 | ||
| 7 | Deploy settings | Marco | 3/8/2026 | 3/26/2026 | Done | Low | 14 | -20 | ||
| 8 | Plan settings | Sara | 4/5/2026 | 4/13/2026 | Not started | Medium | 6 | -2 | Overdue | |
| 9 | Migrate onboarding | Tom | 4/2/2026 | 4/7/2026 | In progress | Low | 4 | -8 | Overdue | |
| 10 | Design reports | Lena | 4/1/2026 | 4/26/2026 | Done | Low | 18 | 11 | ||
| 11 | Build reports | Priya | 4/2/2026 | 4/12/2026 | Not started | Medium | 7 | -3 | Overdue |
Tasks
Project management
Project Tracker
8 steps · 2 h
FluentExcel project · Real estate
Real Estate Analysis
10 steps · 60 rows of data · 66 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Listing | Neighborhood | Type | Beds | SqFt | Price | Days on market | Price/SqFt | Summary | |
| 2 | RE-1029 | Downtown | House | 4 | 2540 | $1,235,000 | 108 | 486.2204724 | Total value | |
| 3 | RE-1001 | Downtown | Condo | 5 | 2900 | $1,185,000 | 9 | 408.6206897 | Average price | |
| 4 | RE-1054 | Downtown | Townhouse | 4 | 2740 | $1,137,000 | 90 | 414.9635037 | Condos listed | |
| 5 | RE-1019 | Downtown | Condo | 5 | 2740 | $1,135,000 | 140 | 414.2335766 | Avg price Riverside | |
| 6 | RE-1002 | Downtown | House | 4 | 2380 | $1,131,000 | 143 | 475.210084 | Highest price | |
| 7 | RE-1049 | Hillcrest | House | 5 | 3000 | $1,130,000 | 133 | 376.6666667 | Neighborhood of highest | |
| 8 | RE-1025 | Lakeside | Townhouse | 5 | 2710 | $1,111,000 | 24 | 409.9630996 | ||
| 9 | RE-1022 | Hillcrest | Condo | 5 | 3130 | $1,080,000 | 123 | 345.0479233 | ||
| 10 | RE-1007 | Downtown | Condo | 5 | 2850 | $1,072,000 | 148 | 376.1403509 | ||
| 11 | RE-1009 | Downtown | Townhouse | 5 | 2580 | $1,030,000 | 7 | 399.2248062 |
Real estate
Real Estate Analysis
10 steps · 3 h