Spreadsheet Applications I: Introduction, Basic Formulas, and Cell Referencing for SSS 1 Students

Sir George For --GeoWeb Tech Ltd.-- May 10, 2026



Spreadsheet Applications I: Introduction, Basic Formulas, and Cell Referencing 

INTRODUCTION

If you have ever watched someone at a bank teller window, a school bursar's office, or a market stall quickly add up long rows of numbers without reaching for a calculator, there is a good chance they were using a spreadsheet. Today, spreadsheet software is one of the most widely used tools in offices, schools, hospitals, and businesses all across Nigeria — from Kano to Lagos, Port Harcourt to Abuja.

For SSS 1 students, learning how to use spreadsheet applications is not just a school requirement. It is a life skill. Whether you plan to run your own business someday, work in an organisation, or study a technical course in university, knowing how to work with spreadsheets will give you a real advantage. The Nigerian job market increasingly expects young graduates to be comfortable with digital tools, and Microsoft Excel or similar applications sit right at the top of that list.

In this lesson, we will start from the very beginning. You will learn what a spreadsheet is, how it is set up, how to enter data properly, and how to use simple formulas and cell references to get the most out of this powerful tool. Take your time with each section, and by the end, you will have a solid foundation that will carry you through more advanced spreadsheet topics in future terms.

LEARNING OBJECTIVES

By the end of this lesson, SSS 1 students should be able to:

  1. Define a spreadsheet and identify common spreadsheet software used in Nigeria and worldwide.
  2. Describe the basic structure and components of a spreadsheet interface.
  3. Explain the concept of cell referencing and identify different types of cell references.
  4. Demonstrate how to enter data and simple formulas into a spreadsheet correctly.
  5. Use basic arithmetic formulas such as SUM, AVERAGE, MIN, and MAX to solve everyday problems.
  6. Apply spreadsheet knowledge to practical real-life situations relevant to Nigerian students and society.

WHAT IS A SPREADSHEET?

A spreadsheet is a computer program that organises data in rows and columns, making it easy to store, calculate, analyse, and present information. Think of it as a very smart, electronic version of the ruled exercise books your accounting teacher uses to record scores or fees.

The most popular spreadsheet application in Nigeria and globally is Microsoft Excel. Others include Google Sheets (which works online and is free), LibreOffice Calc (also free), and Apple Numbers. In many Nigerian schools and cyber cafés, Microsoft Excel remains the standard, so most of the examples in this lesson will reference Excel — though the concepts apply to all spreadsheet programs.

A spreadsheet file is called a workbook. Inside a workbook, you have individual pages called worksheets or sheets. Each worksheet is made up of a grid — a series of horizontal rows and vertical columns that intersect to form boxes called cells.

THE SPREADSHEET INTERFACE — KNOWING YOUR WAY AROUND

Before you start typing or calculating anything, you need to understand the layout of a spreadsheet. Here is a breakdown of the key parts:

 Rows and Columns

Columns run vertically (up and down) and are labelled with letters — A, B, C, D, and so on. After Z, columns continue as AA, AB, AC, and keep going.

Rows run horizontally (left to right) and are labelled with numbers — 1, 2, 3, 4, and so on.

A standard Microsoft Excel worksheet has 1,048,576 rows and 16,384 columns. That is an enormous amount of space for your data.

 Cells and the Cell Address

Every single box on the spreadsheet grid is called a cell. A cell is where you type your data — whether it is a name, a number, a date, or a formula.

Each cell has a unique name called a cell address or cell reference. The cell address is formed by combining the column letter and the row number. For example:

  • The cell at the intersection of Column A and Row 1 is called A1.
  • The cell at the intersection of Column B and Row 3 is called B3.
  • The cell at Column D and Row 7 is D7.

This addressing system is what makes spreadsheets so powerful — you can refer to any piece of data anywhere on the sheet just by using its address.

 The Name Box and Formula Bar

At the top left of the spreadsheet, there is a small box that shows you the address of the cell you are currently working in. This is called the Name Box.

Beside it is the Formula Bar, a long white area where you can see (and type) the content of the active cell. When you enter a formula, the formula bar shows the formula, while the cell itself shows the result.

 The Ribbon and Toolbar

Across the top of Excel, you will see tabs like Home, Insert, Formulas, Data, and Review. These are organised into the Ribbon. Each tab contains groups of tools related to specific tasks. For spreadsheet beginners, you will spend most of your time on the Home tab and the Formulas tab.

Parts of MS Excel Spreadsheet Interface

TYPES OF DATA YOU CAN ENTER IN A SPREADSHEET

Not everything you type into a cell is the same. Spreadsheets recognise three main types of data:

  1. Text (Labels): Words, names, headings, or any combination of letters. Examples include "Student Name," "Lagos," or "Mathematics." Text automatically aligns to the left side of a cell.

  2. Numbers (Values): Any numeric data — whole numbers, decimals, percentages, currency amounts. Numbers align to the right side of a cell by default. Examples include 85, 3500.50, or 100%.

  3. Formulas: Instructions that tell the spreadsheet to perform a calculation. Every formula begins with an equal sign (=). For example, =A1+B1 tells Excel to add whatever is in cell A1 to whatever is in cell B1.

UNDERSTANDING CELL REFERENCING

Cell referencing is one of the most important concepts in spreadsheet work. Instead of typing actual numbers into formulas, you reference the cells that contain those numbers. This way, if any number changes, the formula automatically recalculates the result for you.

There are three types of cell references you will encounter:

H3: 1. Relative Cell Reference

This is the default type. When you copy a formula that uses a relative reference to another cell, the reference adjusts automatically based on the new position.

Example: If you type =A1+B1 in cell C1 and then copy it to C2, it automatically becomes =A2+B2. The formula shifts relative to where it is pasted.

This is very useful when you have the same type of calculation for multiple rows, such as adding scores for many different students.

H3: 2. Absolute Cell Reference

Sometimes you do not want a cell reference to change when you copy a formula. In that case, you use an absolute reference by placing a dollar sign ($) before the column letter and row number.

Example: =$A$1+B1 — the $A$1 part will never change no matter where you copy the formula, but B1 will adjust relatively.

Absolute references are useful when one value — like a tax rate or discount percentage — stays the same across all calculations.

H3: 3. Mixed Cell Reference

This is a combination. You lock either the column or the row, but not both.

Example: $A1 locks the column A but allows the row number to change. A$1 locks row 1 but allows the column letter to change.

Mixed references are used in more advanced spreadsheet work but it helps to know they exist.

BASIC FORMULAS IN SPREADSHEET APPLICATIONS

Formulas are where the real power of spreadsheets comes alive. Instead of manually adding, subtracting, or multiplying numbers, you let the spreadsheet do the work.

Remember: every formula in a spreadsheet must start with the equal sign (=). If you forget it, Excel will treat your entry as plain text.

H3: Arithmetic Operators

These are the symbols used in spreadsheet formulas:

  • Addition: + (e.g., =A1+B1)
  • Subtraction: - (e.g., =A1-B1)
  • Multiplication: * (e.g., =A1*B1)
  • Division: / (e.g., =A1/B1)
  • Exponentiation (power): ^ (e.g., =A1^2 means A1 squared)

H3: Built-In Functions

Spreadsheet applications come with pre-built formulas called functions. Here are the most basic ones every SSS 1 student must know:

SUM Function This adds up a range of numbers. Syntax: =SUM(first cell:last cell) Example: =SUM(B2:B6) adds all values from cell B2 down to B6.

Nigerian Context: Imagine your school bursar wants to find the total school fees collected from five students. She enters each amount in cells B2 to B6, then types =SUM(B2:B6) to get the total instantly.

AVERAGE Function This calculates the mean of a range of values. Syntax: =AVERAGE(first cell:last cell) Example: =AVERAGE(C2:C6)

Nigerian Context: A teacher recording Mathematics scores for JSS students can use =AVERAGE(C2:C6) to quickly find the class average without punching numbers into a calculator.

MAX Function This returns the highest value in a range. Syntax: =MAX(first cell:last cell) Example: =MAX(D2:D10)

Nigerian Context: An SS1 class teacher can use the MAX function to instantly identify the highest score in a Computer Studies test.

MIN Function This returns the lowest value in a range. Syntax: =MIN(first cell:last cell) Example: =MIN(D2:D10)

This works the opposite of MAX — it finds the smallest value. Useful for identifying the lowest price, the minimum score, or the lightest weight in a list.

COUNT Function This counts how many cells in a range contain numbers. Syntax: =COUNT(first cell:last cell) Example: =COUNT(B2:B20)

Nigerian Context: A school result processor can use COUNT to confirm how many students sat an exam — especially useful when lists are long.

PRACTICAL APPLICATIONS — HOW SPREADSHEETS ARE USED IN NIGERIA

Spreadsheets are not just for passing exams. Here is how they are actively used across Nigeria every day:

  • School Result Processing: Schools use Excel to compile, calculate, and print student report cards. The WAEC and NECO grading processes are similarly supported by spreadsheet tools.

  • Market and Business Records: Small business owners in Alaba market, Balogun market, and Onitsha Main Market use spreadsheets to track sales, stock, and profit.

  • Payroll Management: Government ministries and private companies use Excel to calculate staff salaries, tax deductions (PAYE), and net pay.

  • Budget Planning: Families and individuals use spreadsheets to plan monthly budgets — tracking income from farming, trading, or a salary against regular expenses like school fees, food, and transport.

  • Hospital Records: Clinics use spreadsheets to record patient data, track drug stock, and manage appointment schedules.

  • Agricultural Records: Farmers and cooperatives use spreadsheets to track planting seasons, harvests, and prices at different markets.

ADVANTAGES OF SPREADSHEET APPLICATIONS

  • Speed: Calculations that would take hours manually are done in seconds.
  • Accuracy: Formulas reduce human errors in arithmetic.
  • Organisation: Data is neatly arranged and easy to navigate.
  • Flexibility: You can edit data any time and all related formulas update automatically.
  • Charts and Graphs: Spreadsheets can turn your data into visual charts with a few clicks.
  • Sharing: Files can be shared via email, USB, or cloud services like Google Drive, which is especially useful in schools.

DISADVANTAGES OF SPREADSHEET APPLICATIONS

  • Learning Curve: Beginners may find functions and formulas confusing at first.
  • Error Risk: A wrong formula or incorrect cell reference can produce misleading results.
  • Large Files: Spreadsheets with thousands of rows of data can become slow and hard to manage.
  • No Internet, No Google Sheets: Cloud-based spreadsheets like Google Sheets require internet access, which can be a challenge in areas with poor network coverage in Nigeria.
  • Not a Database: For very large or complex data systems, a proper database is more appropriate than a spreadsheet.

SAFETY AND ETHICAL CONSIDERATIONS

Using spreadsheets responsibly is just as important as knowing how to use them. Here are some important points every student should keep in mind:

  • Protect sensitive data: If a spreadsheet contains personal information such as student scores, salaries, or medical records, it must be kept private and password-protected. Sharing such files carelessly is unethical and potentially harmful.

  • Do not falsify records: Using spreadsheets to manipulate or alter academic results, financial records, or official data is dishonest and can have serious legal consequences in Nigeria.

  • Back up your work: Always save copies of important spreadsheets on a USB drive or in cloud storage. Losing important data because of a system crash is avoidable.

  • Beware of macro viruses: Some spreadsheet files shared over the internet or via USB can contain malicious programs called macros. Only open spreadsheet files from trusted sources.

  • Give credit where it is due: If you use a spreadsheet template or someone else's data for a project, acknowledge it. Academic dishonesty starts from small habits.

CLASSROOM AND HOME ACTIVITIES

Activity 1 — Build a Simple Score Sheet Using Microsoft Excel or Google Sheets, create a spreadsheet for five subjects: English, Mathematics, Biology, Chemistry, and Computer Studies. Enter your scores (or imaginary scores) for each subject, then use the SUM function to find your total and the AVERAGE function to calculate your average score.

Activity 2 — Family Monthly Budget With the help of a parent or guardian, list your family's monthly income and expenses. Enter the data into a spreadsheet. Use SUM to find the total expenses and subtract it from the total income to find the balance. This is a real-life budgeting exercise.

Activity 3 — Class Population Table Ask your class prefect for the number of boys and girls in at least five different SS1 classes in your school. Enter the data into a spreadsheet. Use SUM to find the total population, MAX to identify the largest class, and MIN to find the smallest.

Activity 4 — Identify Cell Addresses Open a blank Excel sheet. Your teacher will call out ten different cell addresses (e.g., C5, G12, AA3). Click on each one and type your name. This activity helps you get comfortable navigating the spreadsheet grid quickly.

ASSESSMENT QUESTIONS

SECTION A — OBJECTIVE QUESTIONS

  1. What symbol must every spreadsheet formula begin with? a) # b) @ c) = d) $

  2. Which function is used to find the highest value in a range of cells? a) COUNT b) AVERAGE c) MIN d) MAX

  3. A cell reference that does not change when a formula is copied to another location is called a ______ reference. a) Relative b) Mixed c) Absolute d) Dynamic

  4. In the cell address D7, what does the letter D represent? a) Row b) Column c) Sheet d) Workbook

  5. Which of the following is NOT a spreadsheet application? a) Microsoft Excel b) Google Sheets c) LibreOffice Calc d) Microsoft Word

SECTION B — THEORY QUESTIONS

  1. Explain the difference between a relative cell reference and an absolute cell reference. Give one example of each.

  2. Describe five components of the Microsoft Excel interface and state the function of each one.

  3. A school bursar has the following fee payments from six students (in Naira): 45,000 — 38,500 — 50,000 — 42,000 — 47,500 — 39,000. Show how you would set up a spreadsheet to calculate the total amount collected and the average payment per student. Write the formulas you would use.

SUMMARY

In this lesson, we covered the foundational concepts of spreadsheet applications. Here is a quick recap:

  • A spreadsheet is a grid-based program used to organise, calculate, and analyse data. Common examples include Microsoft Excel and Google Sheets.
  • A workbook contains worksheets, which are made up of rows (numbered), columns (lettered), and cells.
  • Each cell has a unique address formed by its column letter and row number (e.g., B4, G12).
  • The three main types of data in a spreadsheet are text, numbers, and formulas.
  • Cell referencing allows formulas to point to specific cells. Relative references adjust when copied; absolute references (using $) stay fixed; mixed references lock either the row or the column.
  • Basic functions include SUM, AVERAGE, MAX, MIN, and COUNT.
  • Spreadsheets are widely used in Nigerian schools, businesses, government offices, markets, hospitals, and homes.

CONCLUSION

Spreadsheet applications are among the most practical digital tools you will ever learn. In a country like Nigeria — where businesses are growing, schools are expanding, and government agencies are digitising their operations — knowing how to use Excel or Google Sheets fluently is no longer optional. It is a competitive advantage.

As an SSS 1 student, the concepts you have learned here — cell referencing, basic formulas, and spreadsheet structure — are your building blocks. Master them well, practice consistently on a computer at school or at a cyber café, and you will find that spreadsheet work becomes second nature before you know it. The students who take these foundational lessons seriously today are the same ones who will handle financial reports, data analysis, and business operations with confidence tomorrow.

Keep practising, keep exploring, and never be afraid to make mistakes on a blank spreadsheet — that is exactly how you learn.

FREQUENTLY ASKED QUESTIONS (FAQ)

Q1: What is the difference between a spreadsheet and a database? A: A spreadsheet is best for simple data entry, calculations, and small-scale record keeping. A database (like Microsoft Access or MySQL) is designed to handle much larger volumes of data with more complex relationships between records. For everyday school and small business use, a spreadsheet is usually sufficient.

Q2: Can I use Google Sheets instead of Microsoft Excel for my schoolwork? A: Yes. Google Sheets performs most of the same functions as Excel and is free to use with a Google account. The main difference is that Google Sheets requires an internet connection to access, although you can enable offline mode. Many schools in Nigeria use Excel because it comes installed on desktop computers, but Google Sheets is a great alternative, especially on mobile phones.

Q3: What happens if I forget to put the = sign before a formula? A: Without the equal sign, the spreadsheet treats your entry as plain text rather than a formula. For example, if you type SUM(A1:A5) without the = sign, the cell will simply display the text "SUM(A1:A5)" instead of calculating a result.

Q4: How do I fix a wrong formula in Excel? A: Click on the cell containing the formula. The formula will appear in the Formula Bar at the top. You can click inside the Formula Bar, make your corrections, and press Enter to confirm. You can also press the Delete key to clear the cell and start over.

Q5: Is spreadsheet knowledge useful for WAEC and NECO exams? A: Absolutely. Computer Studies questions on spreadsheets appear regularly in WAEC and NECO examinations. Understanding how to write formulas, identify cell addresses, and explain spreadsheet features can earn you valuable marks in both objective and theory sections.

Q6: What is the maximum number of rows in Microsoft Excel? A: A single Microsoft Excel worksheet can hold up to 1,048,576 rows and 16,384 columns, which is more than enough for any school or small business task you will ever need to handle.

Tags
Sir George For --GeoWeb Tech Ltd.--

Posted by Sir George For --GeoWeb Tech Ltd.--

Post a Comment

0 Comments