Show model answer and explanation
100
Multiply quantity by unit price.
Class 8 · English Medium · Pearson Edexcel · ICT
Documents, spreadsheets and presentations
Choose document, spreadsheet and presentation tools for their purpose.
Shared cross-level core and stretch unit. Start with the core questions, then use the stretch example for deeper work. The same unit is available in related class and board pathways; it is not a full grade-specific or examination-specification course. A teacher should select the appropriate depth and further topics.
Learn the idea
A document organises prose; a spreadsheet calculates from structured cells; a presentation supports an oral explanation. A formula must refer to the intended cells. Relative references move when copied; absolute references stay fixed. Formatting helps reading but does not make a calculation correct.
Worked example
If B2 contains quantity 4 and C2 unit price 25, =B2*C2 returns 100. Copying this formula down adjusts the row references. A fixed tax rate in F1 can be referenced as $F$1.
- Define the intended result.
- Write and inspect the formula.
- Test a normal, zero and boundary case.
Stretch example
A copied formula can silently use the wrong rate if a fixed reference was not locked. Data validation limits input; it cannot prove a plausible-looking value was entered correctly.
Your written practice
Show your working on paper and enter your answer here. If it does not match, compare the model and try again.
Show model answer and explanation
$F$1
Dollar signs lock both column and row.
Show model answer and explanation
15
3 + 5 + 7 = 15.
Write in your own words. A guardian or teacher should review this response.
Show model answer and explanation
They tell a reader what the values represent and prevent mixing units.
Connect labels to interpretation.
Write in your own words. A guardian or teacher should review this response.
Show model answer and explanation
It uses readable text, clear contrast, a logical order and a description of a meaningful visual.
Specify practical readability features.
Show model answer and explanation
=B3*$F$1
B2 moves to B3; the absolute reference remains fixed.
Write in your own words. A guardian or teacher should review this response.
Show model answer and explanation
Check each case against independently calculated expected totals, including any stated discount boundary.
Give explicit expected outcomes, not merely “it opens”.
Budget sheet
Make a small fictional class-event budget on paper or in a local spreadsheet.
Review with a guardian or teacher
- Use labelled inputs and formulas.
- Check totals independently.
- Do not enter real financial or personal records.
Keep your work on paper or in a local file. This page does not upload it or automatically grade the project.
Teacher-led lessons, schedules and prices for this outline are upcoming. You can use any starter practice above now without booking.
Your next step
Solo practice works without an account. Sign in to save a practice record to your learner profile.
Keep practising
Exact lesson links and related activities are labelled separately. Return-to-course links retain your selected learning path.