Spreadsheets and Data
Enter data, use formulas and create a simple chart.
Spreadsheets turn rows of numbers into useful answers.
- Enter and format data in cells.
- Use SUM, AVERAGE, MAX and MIN.
- Create a chart from data.
Cells and Ranges
A spreadsheet is a grid of cells named by column letter and row number, such as A1. A range like B2:B10 selects several cells.
Formulas
Every formula starts with =. Useful functions:
- =SUM(B2:B10) — total.
- =AVERAGE(B2:B10) — mean.
- =MAX(B2:B10) and =MIN(B2:B10) — highest and lowest.
- =B2*C2 — multiply values.
Charts
A bar chart compares categories; a line chart shows change over time; a pie chart shows proportions. Choose the chart that matches your question.
Enter names in column A and scores in column B.
In B11 type =AVERAGE(B2:B10).
Select the data and insert a bar chart to compare scores visually.
Practice
- Enter five test scores and calculate the total and average.
- Use MAX and MIN to find the highest and lowest scores.
- Create a bar chart from your data.
Recap
Spreadsheets store data in cells and use formulas and functions to calculate results, which charts can display.
AI Notes
Get AI-powered summaries, key points, and quick revision notes for this lesson — available with Premium.
Unlock AI NotesContents
Digital Skills
0/3 lessons completed