- Free
- Computer Awareness
- 10 lessons
- About 1 h 56 min
Spreadsheets: Practice
Practice course on Spreadsheets (Computer Awareness): worked examples and practice.
Start: Cells, rows, columns and ranges
Sign in to keep track of your progress.
About this course
Practice course on Spreadsheets (Computer Awareness): worked examples and practice.
What you will learn, lesson by lesson
- Cells, rows, columns and ranges Read cell addresses and ranges correctly and count cells in a range, a favourite exam calculation.
- Formulas and basic functions Write and evaluate formulas using SUM, AVERAGE, MAX, MIN and COUNT and the order of operations.
- Cell references: relative, absolute and mixed Predict how a copied formula changes with relative, absolute and mixed references.
- Sorting, filtering, charts and data tools Choose between sort, filter and chart types, and answer questions on the order and meaning of results.
- Spreadsheets mixed practice Practise mixed questions combining ranges, formulas, references and charts.
Lessons in this course
- 1 Cells, rows, columns and ranges About 12 min Start
- 2 Formulas and basic functions About 14 min Start
- 3 Cell references: relative, absolute and mixed About 13 min Start
- 4 Sorting, filtering, charts and data tools About 13 min Start
- 5 Spreadsheets mixed practice About 14 min Start
- 6 Evaluating formulas on ranges with gaps: SUM, AVERAGE, COUNT, MAX and MIN About 12 min Start
- 7 Copy and fill drills: predicting formulas after copying About 13 min Start
- 8 Trace questions: IF, COUNTIF, SUMIF and ROUND on a marks list About 13 min Start
- 9 Spot the mistake: error values and common formula slips About 12 min Start
- 10 Final self-assessment: spreadsheet problems Start
Questions about this course
Should I do Foundation first?
If Spreadsheets is new to you, yes. Start with Spreadsheets: Foundation and come back to this course after.
Is this course free?
Yes. Every lesson in this course is free to read.
How do I keep track of what I've finished?
Create a free account and sign in. Each lesson you finish is saved to your account and shown here and on your dashboard.
Student reviews
No reviews yet. Students who finish a lesson can rate this course.