Spreadsheets
Spreadsheets compute with cells, formulas and charts.
About this topic
A spreadsheet is a grid of cells arranged in rows and columns, used to store, calculate and analyse data. Each cell has an address, such as B3, and can contain text, numbers or a formula that begins with an equals sign. Formulas update automatically when the cells they use change.
Common functions include SUM, AVERAGE, MIN, MAX, COUNT and IF. For example, =SUM(B2:B10) adds the values in nine cells, and =IF(C2 at least 50, Pass, Fail) shows a result depending on a test. A relative reference like A1 changes when copied to another cell, while an absolute reference like $A$1 stays fixed. Spreadsheets can sort, filter, make charts and use pivot tables to summarise large tables.
They are used for budgets, grade books, science data, inventory and planning. For example, a student could track savings and instantly see how a different weekly amount changes the total. A common mistake is typing a number into a formula instead of referencing the cell, which stops it updating. Another is forgetting that copied formulas shift references. Label columns clearly, keep data tidy and check results with a few hand calculations.
Key ideas
- Cell references like A1
- SUM and AVERAGE
- Charts
Quick check
Use cases: where Spreadsheets helps
- Homework: review the key idea behind Spreadsheets before you start a problem set.
- Exam revision: use the quick check to test whether you can recall Spreadsheets without notes.
- Visual learning: play with the interactive lab to see how Spreadsheets changes when you adjust its inputs.
- Teaching a friend: explain Spreadsheets in your own words, then compare your version with the key ideas.
Computing ideas run phones, search engines, games and the wider internet.
Frequently asked questions
What is Spreadsheets?
Spreadsheets compute with cells, formulas and charts.
What will I learn in Spreadsheets?
Cell references like A1. SUM and AVERAGE. Charts.
Is Spreadsheets part of Computer Science?
Yes. It is one of 80 Computer Science topics on LearnViz HighSchoolEdu, with 3 key ideas, a live animation and a quick check.
Does the Spreadsheets lab work on a phone or tablet?
Yes. The animation resizes to fit your screen and supports touch, so you can drag, tap and slide with your finger.
How should I study Spreadsheets?
Read the summary and key ideas first, play with the interactive lab to see the idea in motion, then answer the quick check. If you get a question wrong, go back to the key idea it tests.
Do I need an account, and is my progress saved?
No account is needed. Marking a topic as learned is saved in your own browser, so it stays on that device and is not sent to a server.