Page 88 - Penta Book's ICT Catalogue

Now you have learned how to:

> work with powers and
percentages.

> use advanced functions.
> use a multiple IF.

> use relative and absolute
references.
> understand and correct error
messages.

> format diff erent types of charts. DIGITAL TEENS 2 MODULE 5 Computing and ICT . Sample Pages

> format different types of charts.
> create mini charts.
> apply conditional formatting
to cells.

> import and export data as 8
a CSV file. GRADE

GLOSSARY

absolute conditional export multiple IF scatter chart
reference formatting
formula multiplication sparkline
addition COUNT
gradient OR SUBSTITUTE
AND COUNTIF
import percentage subtraction
area chart CSV
LEFT pie chart TODAY
bar chart delimiter
line chart power TXT
column chart division
MID relative
CONCATENATE doughnut chart reference
mini chart
error message RIGHT
Penta Books