Grade 5 ICT REVISION

Semilore wants to show his teacher a graphical representation of the number of pupils that love different flavours of cake in his class. What tool on Excel can he use to achieve that?

• SmartArt

• Shapes

• Line

• Figure

• Charts

What is the file extension for Macromedia flash?

• .fla

• .pptx

• .xlsx

• .png

• .docx

Charts are on what tab on which group.

• insert, illustration

• Home, font

• insert, Sparkline

• Insert, chart

• insert, link

What formatting provides another way to visualize data and make worksheets easier to understand and work with rules?

• Conditional

• Basic

• Chart

• Sparkline

• Graph

The colour code that represents each item on a chart is known

• Legend

• Chart title

• Axis

• Gridlines

• Table

Conditional formatting is on ___________ tab on _______________ group.

• Home, cells

• Home, style

• Home, editing

• Home, styles

• Home,

  clipboard

What conditional formatting rule can be used to fish out a particular letter or word in a cell?

• Highlight cell rules( between)

• Highlight cell rules

  (top and bottom)

• Highlight cell rules( less than)

• Highlight cell rules( equal to)

• Highlight cell rules( text that contains)

Which chart elements displays the chart values in a table below the chart?

• Data Table

• Data labels

• Legend

• Lines

• Colours

Which chart elements show the values or data points on the chart on your worksheet?

• Data labels

• Data tables

• Legend

• Axis

• Chart title

How many drawing modes do we have on flash?

• 1

• 3

• 5

• 2

• 6