TechnologyFreePrintable

Spreadsheet Skills Practice

A free technology worksheet ready for your classroom. Open in Kuraplan to grab the print-ready PDF, customize it for your students, or generate a fresh version in seconds.

Spreadsheet Skills Practice worksheet preview
Name:Date:

Spreadsheet Skills Practice

Amira, Jai and Hamish are organising a two-night camping trip. Use the sample spreadsheet below to practise writing formulas and functions. Cell references use column letters and row numbers. Formulas begin with =. You do not need to open a spreadsheet program.

Item

Unit price ($)

Quantity

Total ($)

Tents

120

2

Blank (D2)

Sleeping bags

45

3

Blank (D3)

Lanterns

18

2

Blank (D4)

Food packs

12

6

Blank (D5)

Grand total

Blank (D6)

1.Write a formula for cell D2 that multiplies the unit price in B2 by the quantity in C2.
2.Write a formula for cell D3 that multiplies the unit price in B3 by the quantity in C3.
3.Write the SUM function to enter in cell D6 to add the item totals in cells D2 through D5.
4.Calculate the grand total for the camping trip budget using the unit prices and quantities in the table.

About This Worksheet

Free in Kuraplan

Sign up free, grab the PDF, and customize it for your class.

Print-Ready

Formatted for standard paper. Clean layout, easy to read.

AI-Generated

Created with Kuraplan's AI, designed for real classroom use.

For Teachers & Parents

Use in classrooms, for homework, tutoring, or homeschool.

Need a custom version of this worksheet?

Kuraplan's AI generates custom worksheets in seconds — differentiated for every learner, aligned to your curriculum.

Generate Custom Worksheets — Free
No credit card Curriculum-aligned Under 60 seconds