Spreadsheet Arrangements

Topic Arrangements

Exam Clock

Main Aspect	F/G/C	G/C	C
Structure	Rows/Columns and cells	Page breaks
Cell Contents	Text; Values (numbers) Simple formulae (e.g. involving use of +, -, * and / operators)	More complex formulae and functions (e.g. =AVERAGE(....), =MIN(....), =MAX(....)	Formulae involving conditions (e.g. =IF(...)
	Functions (e.g. =SUM(....); Calculation - automatic and manual.		Relative Referencing; Absolute Referencing
Formatting	Alter Column width, row height; Insert columns and rows Delete columns and rows. Simple charting.	Replication; Alter cell format and attributes (e.g. Number of decimal places, currency, percentage) Cell Protection	Fully labeled charting.