Spreadsheet fundamentals

JAMB Computer Studies Revision Notes

All Computer Studies topics
  1. Computer Fundamentals
    1. History and evolution of computing
    2. Classification and uses of computers
    3. Data, information and data processing
    4. The computer system: input, processing and output
    5. Memory and storage
    6. Maintenance, safety and troubleshooting
  2. Software and Operating Systems
    1. System and application software
    2. Operating systems and file management
  3. Data Representation and Logic
    1. Number systems and base conversion
    2. Binary arithmetic and data representation
    3. Logic gates and truth tables
  4. Algorithms and Programming
    1. Algorithms, pseudocode and flowcharts
    2. Programming languages and translators
    3. Variables, data types and operators
    4. Selection and iteration
    5. Functions, arrays and modular programming
    6. Debugging, testing and dry runs
    7. Software development life cycle
  5. Application Packages
    1. Word processing
    2. Spreadsheet fundamentals
    3. Spreadsheet functions and charts
    4. Presentation, graphics and multimedia
  6. Databases and Data Analysis
    1. Database concepts
    2. Queries and relational databases
    3. Data collection and analysis
  7. Networks and the Internet
    1. Computer networks
    2. Internet protocols and addressing
    3. The internet, the web and online services
    4. Web design and publishing
  8. Security, Ethics and Society
    1. Digital citizenship and safe communication
    2. Cybersecurity threats and protection
    3. Authentication and privacy
    4. Computer ethics, law and health
    5. ICT careers and entrepreneurship

GRO Academy notes Checked by imtiaz ahmed 2 min read Updated October 19, 2026

How a spreadsheet is organised, how to write formulas, the difference between relative and absolute references, and what common error messages mean.

In these notes
  1. The parts of a spreadsheet
  2. Formulas
  3. Relative and absolute references
  4. Formatting
  5. Error messages
  6. Good practice

Revision notes come with the Complete plan

Complete gives you full UTME mock exams in the CBT style, revision notes for every topic, the full curriculum as a checklist and past papers, as well as every practice question with its explanation. ₦10,000 a month, or ₦108,000 a year.

See the plans Sign in

Practise this topic

CONTACT US

 Have questions, let us help!