GRADE 10

EXERCISE BOOKLET
Additional exercises from
national exams sorted
according to program and
chapter to fine-tune your skills

This work is licensed under a Creative Commons Attribution-

NonCommercial-ShareAlike 4.0 International License.

Revision date: 11 April 2023 Compiled by Claire Smuts

TABLE OF CONTENTS
WORD ................................................................................................... 3
Interactive tables of contents
EXCEL .................................................................................................. 32
(click to follow)
HTML .................................................................................................. 43
WINDOWS SHORTCUTS ................................................................... 56

Tips for using this booklet

Print an A5 copy in booklet format for yourself, or use it
electronically and highlight the questions you've done,
so that you know what you've completed.

Get a copy of the data for this booklet from here:

https://bit.ly/CATpractise . When you're working in
Word, find the folders for each exam in the 'Word' folder
and the same for other programs.

The memorandums for each question paper are included

in the folders. Consult them regularly to check whether
you completed the question correctly.
 WORD
TABLE OF CONTENTS
3.1 WORK WITH TEXT ...................................................................................................................... 4
3.2 PAGE LAYOUT ............................................................................................................................. 5
3.2 PARAGRAPH FORMATTING ...................................................................................................... 5
3.3 EDITING........................................................................................................................................ 6
3.4 PICTURES ..................................................................................................................................... 8
3.4 SHAPES....................................................................................................................................... 12
3.4 TEXT EFFECTS & DROP CAP ..................................................................................................... 13
3.4 PAGE BACKGROUND, PAGE BORDER & WATERMARKS...................................................... 16
3.4 SMARTART ................................................................................................................................ 17
3.5 BULLETED & NUMBERED LISTS .............................................................................................. 19
3.5 TAB STOPS ................................................................................................................................. 20
3.5 PAGE HEADER & FOOTER ........................................................................................................ 22
3.6 TABLES ....................................................................................................................................... 23
3.7 COLUMNS .................................................................................................................................. 28
3.7 HYPHENATION & LINE NUMBERS ......................................................................................... 29
3.7 COMMENTS ............................................................................................................................... 29
3.7 HYPERLINKS .............................................................................................................................. 30

Grade 10 Word Page |3

3.1 WORK WITH TEXT
Character formatting, creating documents

Mar 2015

Jun 2015

Nov 2015 – 2

Nov 2017 – 2

Mar 2018

4|Page Word Grade 10

3.2 PAGE LAYOUT
Margins, orientation, paper size, page numbers

Jun 2015

Nov 2015 – 2

Nov 2016 – 2

Jun 2018

3.2 PARAGRAPH FORMATTING

Line and paragraph spacing, alignment, styles, paragraph borders and shading

Exe 2014

Jun 2015

Grade 10 Word Page |5

Mar 2016

Nov 2016 – 2

Jun 2018

3.3 EDITING
Delete, move or copy text, basic find & replace, spell check, autocorrect

Nov 2013

Mar 2017

6|Page Word Grade 10

Exe 2014

Nov 2016 – 2

Mar 2015

Jun 2017

Grade 10 Word Page |7

Nov 2017 – 2

3.4 PICTURES

Mar 2015

Mar 2017

Jun 2018

8|Page Word Grade 10

Jun 2015

Nov 2015 – 2

Grade 10 Word Page |9

Nov 2017 – 2

Mar 2018

10 | P a g e Word Grade 10
Jun 2022

Grade 10 Word P a g e | 11
3.4 SHAPES

Exe 2014

12 | P a g e Word Grade 10
Nov 2014 – 2

Mar 2017

Mar 2015

3.4 TEXT EFFECTS & DROP CAP

Exe 2014

Jun 2015

Grade 10 Word P a g e | 13
Jun 2015

Mar 2015

Nov 2015 – 2

14 | P a g e Word Grade 10
Mar 2017

Jun 2017

Mar 2018

Jun 2018

Jun 2022

Grade 10 Word P a g e | 15
3.4 PAGE BACKGROUND, PAGE BORDER & WATERMARKS

Jun 2015

Exe 2014

Mar 2015

16 | P a g e Word Grade 10
Nov 2016 – 2

Jun 2017

Nov 2017 – 2

3.4 SMARTART

Mar 2015

Grade 10 Word P a g e | 17
Mar 2016

Nov 2016 – 2

18 | P a g e Word Grade 10
3.5 BULLETED & NUMBERED LISTS

Mar 2015

Mar 2016

Mar 2017

Jun 2018

Nov 2020 – 2

Grade 10 Word P a g e | 19
3.5 TAB STOPS

Exe 2014

Mar 2015

Mar 2016

20 | P a g e Word Grade 10
Nov 2015 – 2

Mar 2017

Nov 2017 – 2

Grade 10 Word P a g e | 21
3.5 PAGE HEADER & FOOTER

Jun 2015

Mar 2016

Nov 2017 – 2

Mar 2018

22 | P a g e Word Grade 10
3.6 TABLES

Exe 2014

Nov 2014 – 2

Grade 10 Word P a g e | 23
Mar 2015

Nov 2016 – 2

24 | P a g e Word Grade 10
Jun 2015

Mar 2017

Grade 10 Word P a g e | 25
Nov 2015 – 2

Jun 2017

26 | P a g e Word Grade 10
Nov 2017 – 2

Jun 2018

Grade 10 Word P a g e | 27
3.7 COLUMNS

Nov 2015 – 2

Jun 2017

Jun 2015

28 | P a g e Word Grade 10
3.7 HYPHENATION & LINE NUMBERS

Mar 2016

Nov 2016 – 2

Jun 2015
* Not in the textbook – but have a look, right above Hyphenation on the Ribbon.

3.7 COMMENTS

Exe 2014

Nov 2016 – 2

Grade 10 Word P a g e | 29
Nov 2017 – 2

Jun 2018

3.7 HYPERLINKS

Exe 2014

Mar 2015

Jun 2015

Nov 2015 – 2

30 | P a g e Word Grade 10
Jun 2017

Nov 2017 – 2

Nov 2017 – 2

Grade 10 Word P a g e | 31
 EXCEL
TABLE OF CONTENTS
4.1 ENTERING TEXT & SIMPLE FORMULAS ................................................................................. 32
4.1 FORMATTING ............................................................................................................................ 33
4.1 FUNCTIONS (SUM, AVERAGE, MIN, MAX) ............................................................................ 35
4.1 DATA FORMAT (DECIMALS, CURRENCY, DATE & TIME) ..................................................... 36
4.2 FORMULAS................................................................................................................................. 37
4.2 CELL NAMES .............................................................................................................................. 38
4.2 PAGE SETUP (MARGINS, ORIENTATION, PRINT) ................................................................. 38
4.3 COUNTING FUNCTIONS (COUNT, COUNTA, COUNTBLANK) .............................................. 38
4.3 COUNTIF .................................................................................................................................... 39
4.3 OTHER FUNCTIONS (RAND, RANDBETWEEN, MODE, MEDIAN, TODAY, NOW) .............. 40
4.3 SORTING .................................................................................................................................... 40
4.3 WORKSHEETS ............................................................................................................................ 41
4.3 HEADERS & FOOTERS .............................................................................................................. 41
4.4 SIMPLE GRAPHS ........................................................................................................................ 41

32 | P a g e Excel Grade 10
4.1 ENTERING TEXT & SIMPLE FORMULAS

Jun 2017

Nov 2013

4.1 FORMATTING

Nov 2013

Nov 2015 – 2

Grade 10 Excel P a g e | 33
Nov 2014 -2

Mar 2016

Nov 2016 – 2

Mar 2017

Jun 2017

3.4

34 | P a g e Excel Grade 10
Nov 2017 – 2
Open the 4Tickets spreadsheet. Work in the Sales_Verkoop worksheet.

Mar 2018

Jun 2018

4.1 FUNCTIONS (SUM, AVERAGE, MIN, MAX)

Nov 2015 – 2

Mar 2016

Grade 10 Excel P a g e | 35
Nov 2016 – 2

Jun 2017

Mar 2018

Jun 2018

4.1 DATA FORMAT (DECIMALS, CURRENCY, DATE & TIME)

Nov 2014 -2

Mar 2016

36 | P a g e Excel Grade 10
Jun 2016

4.2 FORMULAS

Mar 2016

Jun 2017

Jun 2018

Grade 10 Excel P a g e | 37
Jun 2022

4.2 CELL NAMES

Mar 2017

4.2 PAGE SETUP (MARGINS, ORIENTATION, PRINT)

Jun 2016

Nov 2017 – 2
Open the 4Tickets spreadsheet. Work in the Sales_Verkoop worksheet.

4.3 COUNTING FUNCTIONS (COUNT, COUNTA, COUNTBLANK)

Nov 2013

38 | P a g e Excel Grade 10
Nov 2014 -2

4.3 COUNTIF

Nov 2013

Jun 2017

Nov 2020

Grade 10 Excel P a g e | 39
4.3 OTHER FUNCTIONS (RAND, RANDBETWEEN, MODE, MEDIAN,
TODAY, NOW)

Nov 2014 -2

Jun 2016

Mar 2017

4.3 SORTING

Nov 2013

Nov 2016 – 2

Mar 2017

40 | P a g e Excel Grade 10
4.3 WORKSHEETS

Nov 2013

Nov 2013

Nov 2017 – 2
Open the 3Stat spreadsheet. Select ‘OK’ for the warning message that appears when you open
the spreadsheet.

4.3 HEADERS & FOOTERS

Mar 2017

4.4 SIMPLE GRAPHS

Nov 2016 – 2

Grade 10 Excel P a g e | 41
 NOTE: NO FORMATTING IS NECESSARY

42 | P a g e Excel Grade 10
 HTML
TABLE OF CONTENTS
BASIC TAGS...................................................................................................................................... 52
ATTRIBUTES ..................................................................................................................................... 53

Grade 10 HTML P a g e | 43
SCREENSHOT EXAMPLES

Exe 2014
(Press Alt+ to go back)

44 | P a g e HTML Grade 10
Mar 2015
(Press Alt+ to go back)

Grade 10 HTML P a g e | 45
Jun 2015
(Press Alt+ to go back)

46 | P a g e HTML Grade 10
Nov 2016 - 2
(Press Alt+ to go back)

Grade 10 HTML P a g e | 47
Jun 2017
(Press Alt+ to go back)

48 | P a g e HTML Grade 10
Nov 2017 – 2
(Press Alt+ to go back)

Grade 10 HTML P a g e | 49
Jun 2018
(Press Alt+ to go back)

50 | P a g e HTML Grade 10
Jun 2018 – 2
(Press Alt+ to go back)

Grade 10 HTML P a g e | 51
BASIC TAGS

Mar 2015
Refer to example on pg. 45

Jun 2015
Refer to example on pg. 46

Exe 2014
Refer to example on pg. 44

Jun 2017
Refer to example on pg. 48

Nov 2017 – 2
Refer to example on pg. 49

52 | P a g e HTML Grade 10
ATTRIBUTES
Exe 2014
Refer to example on pg. 44

Nov 2016 – 2
Refer to example on pg. 47

Mar 2015
Refer to example on pg. 45

Grade 10 HTML P a g e | 53
Nov 2017 – 2
Refer to example on pg. 49

Jun 2018
Refer to example on pg. 50

Jun 2018 – 2
Refer to example on pg. 51

54 | P a g e HTML Grade 10
 Windows Shortcuts
Where one shortcut is mentioned, the opposite also applies (e.g. there is also a ‘Page Up’, even though only
a ‘Page Down’ is mentioned).

Copy

Paste

Undo

Find

Move cursor one word right (also works to left)

Select one word to the right (and then cut/copy/delete)

Move window right

Show Desktop

Open File Explorer

Launch Snipping Tool

Switch between windows

Jump to the next textbox when you fill in a form

Jump to the previous textbox when you fill in a form

Move down one screen

The following shortcuts only work in Microsoft Word

After this, type the letter you want e.g. áéíóú

After this, type the letter you want e.g.àèìòù

After this, type the letter you want e.g. âêîôû

After this, type the letter you want e.g. äëïöü