Spreadsheets
A spreadsheet organises data in cells arranged in rows and columns and uses formulae to calculate results automatically.
▶ Interact
Play with the controls to see the idea in action.
📘 Learn
A spreadsheet organises data in cells arranged in rows and columns and uses formulae to calculate results automatically.
- Cell references like B2
- Formulae start with equals
- Charts display data visually
🧠 Quick quiz
Three questions. Score 2 or more to complete the topic.
What is Spreadsheets?
Within Computer Science, which covers algorithms, programming, data, networks, hardware and safe, responsible use of technology, this topic explains Spreadsheets. Computing topics explain how software, hardware and data work, with diagrams and models that show each step in order.
Check that you can explain Spreadsheets in your own words and give one example from everyday life. If you can do that, you have understood the core idea.
Understanding Spreadsheets helps you design, test and explain programs, websites and systems, from small projects to exam questions.
Spreadsheets in detail
A spreadsheet is a program, such as Excel or Google Sheets, that organises data in a grid of rows and columns, with cells identified by references such as B3. Cells can hold numbers, text or formulas that calculate automatically, such as =SUM(B2:B10) or =A1*B1.
Functions include SUM, AVERAGE, MAX, MIN, COUNT and IF, and cell references can be relative (change when copied) or absolute ($B$1). Features such as sorting, filtering, charts and conditional formatting help analyse and present data. Spreadsheets are used for budgets, records, scientific data and modelling "what if" scenarios, because changing one value updates all dependent results.
How the interactive helps you understand Spreadsheets
Watch the bar chart in the interactive. Use any sliders or buttons it offers to change the values and see how the bar chart responds.
Before you change anything, predict the result. Then change one value at a time and check whether your prediction was right. This is a quick way to build a correct mental model of Spreadsheets.
Real-life uses and examples
- Recognise Spreadsheets in an app or device you use every day.
- Apply Spreadsheets when you design a small program, website or spreadsheet.
- Explain Spreadsheets to someone new to computing by comparing it to a familiar process.
Common mistakes to avoid
- Using the term without being able to say what the computer actually does.
- Testing only the normal case and forgetting the edge cases.
- Learning the definition without testing it. Use the quiz and the interactive to check that you can apply the idea.
Frequently asked questions about Spreadsheets
What is Spreadsheets?
A spreadsheet organises data in cells arranged in rows and columns and uses formulae to calculate results automatically.
What are the most important points about Spreadsheets?
The main points are: Cell references like B2; Formulae start with equals; Charts display data visually.
Why is Spreadsheets useful?
Understanding Spreadsheets helps you design, test and explain programs, websites and systems, from small projects to exam questions.
How can I practise Spreadsheets?
Open the interactive at the top of this page and change the controls one at a time. Predict the result before each change, then take the three-question quiz. A score of two or more marks the topic as complete on this device.
Which topics are related to Spreadsheets?
Related topics in Computer Science include Embedded Systems and IoT, Moore's Law, Project Management and Teamwork.