create an activity sheet to check understanding of Spreadsheets for Year 7 mixed ability…
- User
create an activity sheet to check understanding of Spreadsheets for Year 7 mixed ability students including cell referencing, Spreadsheet, Cell Reference, Formula & Formulae, Functions, Revenue/Turnover, Variables, Profit, Revenue, Costs and simplifying the keywords, matching definitions etc
- Assistant
🖥️ Year 7 Spreadsheet Basics Activity Sheet
Name: _____________________ Class: ________ Date: __________
Section A – Match the Keywords 🔍
Draw a line to match each keyword in column A with its definition in column B.
Column A Column B 1. Spreadsheet A. The money left after you subtract costs from revenue. 2. Cell B. A predefined calculation (e.g., SUM, AVERAGE). 3. Cell Reference C. A collection of rows and columns in a file. 4. Formula D. A single box in a spreadsheet (e.g., A1, B3). 5. Function E. The amount of money earned from selling goods or services. 6. Revenue/Turnover F. A way to store a value that you can change (e.g., price, quantity). 7. Variable G. An instruction starting with “=” that does a calculation. 8. Cost H. The money spent to make or buy items. 9. Profit I. The address of a cell (like B2 or C5).
Section B – Fill in the Blanks ✏️
- A ________ is the location of a cell, like “C3.”
- Every formula in a spreadsheet must start with the _______ sign.
- The function
=SUM(A1:A5)adds all numbers from cell A1 to A5 and returns a single _______. - _______ is money coming in; _______ is money going out.
- _______ = Revenue – Costs.
Section C – Working with Cell References 📊
Below is part of a simple sales table.
A B C 1 Item Price (£) Quantity Sold 2 Soccer Ball 8 15 3 Tennis Racket 20 5 4 Water Bottle 2 40 a) What is the cell reference for “Tennis Racket”? _______
b) In which cell is the number 40? _______
c) Write a formula in cell D2 to calculate Revenue (Price × Quantity).
D2 = ___________________________________________________
Section D – Calculate Revenue, Cost & Profit 💰
Extend the table from Section C by adding Revenue, Cost, and Profit columns. Assume:
• Cost to make each Soccer Ball = £5
• Cost to make each Tennis Racket = £12
• Cost to make each Water Bottle = £1A B C D (Revenue) E (Cost) F (Profit) 1 Item Price (£) Qty Sold =B×C =Cost × Qty =D – E 2 Soccer Ball 8 15 3 Tennis Racket 20 5 4 Water Bottle 2 40 5 Total =SUM(D2:D4) =SUM(E2:E4) =SUM(F2:F4) Fill in D2–D4, E2–E4, F2–F4, and the totals in row 5.
Section E – True or False ✅❌
- A function is always typed without an equals sign.
- Changing a variable (e.g., price) will automatically update related cells.
- Profit can be negative if costs are higher than revenue.
- “SUM” is an example of a formula you type directly into cells.
Section F – Extension Challenge 💡
Imagine you sell a new product at £12 each and expect to sell 30 units.
- On paper, write the formula using cell references to calculate its revenue.
- If the cost per unit is £7, what will the profit be? Show your workings.
Great work! Hand this sheet in when you’re done. 😊
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.