Cell kid — finale · البرمجة مع مارتن

Cell kid = a table looks and behaves right

Twelve lessons: address, types, width, range, format, colours, merge, rows, series, protection. The finale = you tune the whole workbook so Formula kid and Chart maker can pick up without a tidy.

Then pick up the Cell kid certificate on الشهادات, when you have all 12 lessons تم.

💡

A certificate is praise for work — not automatic after reading. Make sure the tables really fit. A parent or a teacher can look with you.

Big task: three sheets in one style

Grades — a merged heading, bold headings, 6+ subjects, borders, alternating colours, an Average row at the bottom (B still empty).
Pocket — A1:D1 headings like on Grades (colour, bold). Days Mon–Sun in A. Columns B,C with sample numbers. D empty for a formula. Borders A1:D8.
Survey — a merged question at the top. Column A snacks, B counts (at least 5 rows). Borders, a coloured heading.
ملاحظةs — three bullets of what you can do from Cell kid (range, brush, merge…).
Optional: a protected heading row on Grades.

Mini dashboard — only a notice board

Still no chart or formulas linked at the top. Just prepare sheet Dashboard (plus at the bottom):

A1 merged across A:D — Overview. Bold.
A3 Grade average, B3 empty (later a link to Grades!B??).
A4 Pocket week, B4 empty.
A5 Favourite snack, B5 empty.

Workbook boss will turn these cells into live links. Today signs are enough.

⚠️

Do not type numbers into the dashboard by hand when you already have a table elsewhere — in a week you will have two truths. Leave B3–B5 empty or type =link later.

🏫 Grade average

One sheet, two columns: subject and grade. At the bottom a sum and an average.

💰 Pocket money

Rows = days, columns = income / spend / left.

📊 Class survey

One question, answers in one column, later a chart.

🏆 Mini dashboard

Three numbers at the top and one chart. Numbers as a link, not copied by hand.

Now you 💪

Final Cell kid checklist:

All four sheets exist and have names that make sense.
Each sheet has a heading and bordered data.
No cut text in column A.
Grades are numbers. The survey has counts in B.
The dashboard has three empty cells for future links.
Workbook named, Drive, the right account.
You go to Formula kid — equals and functions.

✅

Cell kid تم. The tables look professional and have the right structure. Pick up the 📊 Cell kid certificate on الشهادات. Next stop: Formula kid — counting.

What to take from this finale

Cell kid = look + structure + series + protection.
Three projects in one workbook: Grades, Pocket, Survey.
The dashboard waits for links and a chart.
الشهادة excel-bunkar after 12 lessons.
Formula kid will add numbers the spreadsheet counts itself.