• 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

  1. Cells, rows, columns and ranges Read cell addresses and ranges correctly and count cells in a range, a favourite exam calculation.
  2. Formulas and basic functions Write and evaluate formulas using SUM, AVERAGE, MAX, MIN and COUNT and the order of operations.
  3. Cell references: relative, absolute and mixed Predict how a copied formula changes with relative, absolute and mixed references.
  4. Sorting, filtering, charts and data tools Choose between sort, filter and chart types, and answer questions on the order and meaning of results.
  5. Spreadsheets mixed practice Practise mixed questions combining ranges, formulas, references and charts.

Lessons in this course

  1. 1 Cells, rows, columns and ranges About 12 min Start
  2. 2 Formulas and basic functions About 14 min Start
  3. 3 Cell references: relative, absolute and mixed About 13 min Start
  4. 4 Sorting, filtering, charts and data tools About 13 min Start
  5. 5 Spreadsheets mixed practice About 14 min Start
  6. 6 Evaluating formulas on ranges with gaps: SUM, AVERAGE, COUNT, MAX and MIN About 12 min Start
  7. 7 Copy and fill drills: predicting formulas after copying About 13 min Start
  8. 8 Trace questions: IF, COUNTIF, SUMIF and ROUND on a marks list About 13 min Start
  9. 9 Spot the mistake: error values and common formula slips About 12 min Start
  10. 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.

Keep going

Privacy · Terms · Refunds · Delivery