Question 1
3 marks
Spreadsheet features and operating system role
- System fundamentals
- Computer organisation
(a)
2 marks
- Outline two distinct functional characteristics of spreadsheet applications:
- 1) Grid-based addressable matrix: Data is organized into intersecting rows and columns forming individual cells referenced by coordinate labels (e.g., B4).
- 2) Dynamic formula recalculation: Built-in mathematical and statistical functions automatically recompute output values whenever underlying cell values change.
Mentor tip
State two distinctive traits: cell grid structuring and automatic formula recalculation.
(b)
1 mark
- Define the term operating system:
- Core system software that manages physical hardware resources, supervises processor scheduling and memory allocation, and provides foundational platform services for application execution.
Mentor tip
Emphasize management of physical computer hardware and system resources.

