• Free
  • CCC Computer Concepts
  • 6 lessons
  • About 1 h 50 min

Spreadsheet: Practice

Practice course on Spreadsheet (CCC Computer Concepts): step-by-step practice and exam-style questions.

About this course

Practice course on Spreadsheet (CCC Computer Concepts): step-by-step practice and exam-style questions.

What you will learn, lesson by lesson

  1. Formula evaluation drills: order of operations, comparisons, percentages and text joins Work out what a formula shows before pressing Enter, avoid the common precedence and percentage traps, and use comparisons and the & operator correctly.
  2. Relative, absolute and mixed references: copy-and-predict tasks Predict exactly how a formula changes when copied, choose between A1, $A$1, $A1 and A$1, and build a multiplication table and a percentage-of-total column with one formula each.
  3. Functions in practice: a complete marksheet with SUM, AVERAGE, IF, nested IF, COUNTIF and text functions Build a marksheet step by step - totals, rounded averages, grades with nested IF, pass/fail, class summaries with COUNTIF - and tidy names with text functions.
  4. Data tasks: series, dates and formats, multi-level sorting, filtering and freeze panes Fill series and dates quickly, calculate with dates, apply number formats correctly, sort by two keys, filter with conditions and freeze the right rows and columns.
  5. Charts, printing and fixing error values: troubleshooting tasks Choose and build the right chart, set up a sheet to print cleanly, and diagnose and fix #DIV/0!, #NAME?, #VALUE!, #REF!, ##### and circular references.
  6. Final self-assessment: Spreadsheet practice Test yourself on the whole course: 15 questions with answers explained.

Lessons in this course

  1. 1 Formula evaluation drills: order of operations, comparisons, percentages and text joins About 16 min Start
  2. 2 Relative, absolute and mixed references: copy-and-predict tasks About 17 min Start
  3. 3 Functions in practice: a complete marksheet with SUM, AVERAGE, IF, nested IF, COUNTIF and text functions About 18 min Start
  4. 4 Data tasks: series, dates and formats, multi-level sorting, filtering and freeze panes About 17 min Start
  5. 5 Charts, printing and fixing error values: troubleshooting tasks About 17 min Start
  6. 6 Final self-assessment: Spreadsheet practice About 25 min Start

Questions about this course

Should I do Foundation first?

If Spreadsheet is new to you, yes. Start with Spreadsheet: 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