Spreadsheet Skills Practice

Name:

Date:

📚 Part 1: Multiple Choice

1. How do you find total cost if Unit Price is in B6 and Quantity is in C6? (Hint: Multiply)

=B6*C6

=SUM(B6:C6) (Hint: This adds)

=B6+C6 (Hint: This adds)

=SUM(B6*C6) (Hint: Check structure)

2. How do you find the average of D2 to D10? (Hint: Think mean)

=AVERAGE(D2:D10)

=MEAN(D2:D10) (Hint: Not valid)

=SUM(D2:D10)/COUNT(D2:D10) (Hint: This works too)

=AVG(D2:D10) (Hint: Check names)

3. What does $ mean in $A$1? (Hint: Locks cells)

Absolute reference

Currency (Hint: Not this)

Start formula (Hint: Not correct)

Wildcard (Hint: For searching)

4. Which icon shows rows with Status = "Completed"? (Hint: Think filter)

Filter (funnel icon)

Sort (A→Z) (Hint: This organizes)

Find & Replace (Hint: For searching)

Freeze Panes (Hint: Keeps rows visible)

✏️ Part 2: Short Answers

Teacher notes: Work alone or in pairs. Write formulas on your mini whiteboard first, then type them in. Mid-check: show your board with the AVERAGE for 'Cost'. One-word check: What button filters data? (Filter)

5. Write the formula for total cost for row 4 (Unit Price B4, Qty C4). (Hint: Multiply)

6. Write the formula for the AVERAGE of 'Cost' (E2:E12). Show it during the mid-check. (Hint: Use AVERAGE)

7. One-word answer: What button filters data? (Hint: Funnel icon)

🖥️ Part 3: Practical Tasks

8. Open "PartyBudget.xlsx". In column F, make a running total of Costs (column E). What formula goes in F2? Write it and the expected total in F3 after dragging down. (Hint: Add previous total)

9. Create a chart for Items (A2:A8) and Costs (E2:E8). What chart type is best? Give a short reason (1–2 words). (Hint: For comparison)

Extra support: Use short breaks at the whiteboard to check understanding. Teacher will help with any unclear plans.