Grade 11 · Term 2

Spreadsheets: IF Logic and Databases

Grade 11 Computer Applications Technology

Cover nested IF, AND/OR operators, COUNTIF, SUMIF, VLOOKUP, data validation, conditional formatting, and database queries with criteria and wildcard characters.

Where this fits in CAPS

Spreadsheets: IF Logic and Databases is part of Grade 11 Computer Applications Technology, Term 2, in the CAPS (Curriculum and Assessment Policy Statement) practice on PrepPals. Each practice session gives you questions on the topic with instant feedback, and you keep a streak as you go. It is free.

Also in Term 2

New to PrepPals? It is free to start.

All Grade 11 subjects