Skip to content
TheChatArchiveThe Chat Archive
o4-mini-2025-04-16· OpenAIHugging Face LMArena Human Preference 140K

create an activity sheet to check understanding of Spreadsheets for Year 7 mixed ability…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with Geminigemini-2.0-flash-001’s answer.
  1. 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

  2. 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 AColumn B
    1. SpreadsheetA. The money left after you subtract costs from revenue.
    2. CellB. A predefined calculation (e.g., SUM, AVERAGE).
    3. Cell ReferenceC. A collection of rows and columns in a file.
    4. FormulaD. A single box in a spreadsheet (e.g., A1, B3).
    5. FunctionE. The amount of money earned from selling goods or services.
    6. Revenue/TurnoverF. A way to store a value that you can change (e.g., price, quantity).
    7. VariableG. An instruction starting with “=” that does a calculation.
    8. CostH. The money spent to make or buy items.
    9. ProfitI. The address of a cell (like B2 or C5).

    Section B – Fill in the Blanks ✏️

    1. A ________ is the location of a cell, like “C3.”
    2. Every formula in a spreadsheet must start with the _______ sign.
    3. The function =SUM(A1:A5) adds all numbers from cell A1 to A5 and returns a single _______.
    4. _______ is money coming in; _______ is money going out.
    5. _______ = Revenue – Costs.

    Section C – Working with Cell References 📊

    Below is part of a simple sales table.

    ABC
    1ItemPrice (£)Quantity Sold
    2Soccer Ball815
    3Tennis Racket205
    4Water Bottle240

    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 = £1

    ABCD (Revenue)E (Cost)F (Profit)
    1ItemPrice (£)Qty Sold=B×C=Cost × Qty=D – E
    2Soccer Ball815
    3Tennis Racket205
    4Water Bottle240
    5Total=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 ✅❌

    1. A function is always typed without an equals sign.
    2. Changing a variable (e.g., price) will automatically update related cells.
    3. Profit can be negative if costs are higher than revenue.
    4. “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.

    1. On paper, write the formula using cell references to calculate its revenue.
    2. 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. 😊

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.