-
Layout of a spreadsheet screen. Help features. Loading/saving models
-
Cell formatting. Font/size. Alignment. Column width, row height. Boxing grouped cells. Moving/copying/deleting cell(s)
-
Data types including NUMBER, TEXT, CURRENCY, SCIENTIFIC, DATE, TIME
-
Data formatting – decimal places. Alignment. Date/time options
-
Formulae. Cell addresses. Absolute and relative addressing. Replicating a formula to a block of cells
-
Functions
-
a. Number: SUM, COUNT, AVERAGE, MAX, MIN, INT, ROUND, RANDOM, SQRT, ODD, SIN, COS, TAN, POWER
-
b. Text: CHAR, VALUE, TRIM, RIGHT, LEFT, UPPER, LOWER
-
c. Decision: IF, AND, OR, NOT
-
Nesting functions within functions
-
Lookup tables and their use
-
Design and construct spreadsheet models for a given problem. Layout design
-
Print data, print formulae adjusting column widths as necessary. Print with/without grid lines. Print with/without row/column labels. Fitting to a page
-
Charts. Pie chart, histogram, bar chart, line graph. Customising output
-
“What-if” models for the determinations of best results. Practical use in business.
-
Exporting/importing data to/from other packages