Spreadsheet - Studies Blueprint

A spreadsheet is a computer application used to organise data, perform calculations and create charts. It stores information in a table made of rows and columns.

Common spreadsheet applications include:

Microsoft Excel
Google Sheets
LibreOffice Calc
Apple Numbers
WPS Spreadsheets

What Can You Do with a Spreadsheet?

A spreadsheet can be used to:

Create budgets
Calculate marks
Manage attendance
Record sales
Prepare bills
Track inventory
Analyse data
Create charts and reports

Real-life example: A shopkeeper can enter product prices and quantities into a spreadsheet. The spreadsheet can automatically calculate the total sales.

How Does a Spreadsheet Work?

flowchart LR
    A["Enter Data"] --> B["Organise in Cells"]
    B --> C["Apply Formula"]
    C --> D["Calculate Result"]
    D --> E["Create Report or Chart"]

When the original values change, related formula results are normally recalculated automatically.

Workbook and Worksheet

A spreadsheet file is called a workbook. A workbook can contain one or more pages called worksheets or sheets.

flowchart TD
    A["Workbook"] --> B["Worksheet 1"]
    A --> C["Worksheet 2"]
    B --> D["Rows and Columns"]
    D --> E["Cells"]

Example: A school workbook may contain separate worksheets for attendance, marks and student fees.

Rows, Columns and Cells

Rows

Rows run horizontally and are identified by numbers:

1, 2, 3, 4...

Columns

Columns run vertically and are identified by letters:

A, B, C, D...

Cells

A cell is the box created where a row and column meet. Each cell has a unique address.

	A	B	C
1	Name	Subject	Marks
2	Riya	Computer	85
3	Aman	Computer	78

In this table:

A2 contains Riya.
B3 contains Computer.
C2 contains 85.

The active cell is the cell currently selected by the user.

Types of Data in a Spreadsheet

A cell can contain different types of data.

Data Type	Example
Text	Student Name
Number	250
Date	23/08/2026
Currency	£50.00
Percentage	75%
Formula	`=A1+B1`

What Is a Formula?

A formula is an instruction used to calculate a result. A spreadsheet formula normally begins with an equals sign =.

Example

Suppose:

Cell A1 contains 10.
Cell B1 contains 20.

The formula:

=A1+B1

produces the result:

30

Common Mathematical Operators

Operator	Operation	Example
`+`	Addition	`=A1+B1`
`-`	Subtraction	`=A1-B1`
`*`	Multiplication	`=A1*B1`
`/`	Division	`=A1/B1`

What Is a Function?

A function is a ready-made formula that performs a specific calculation.

Function	Purpose	Example
`SUM`	Adds values	`=SUM(A1:A5)`
`AVERAGE`	Calculates the average	`=AVERAGE(A1:A5)`
`MAX`	Finds the largest value	`=MAX(A1:A5)`
`MIN`	Finds the smallest value	`=MIN(A1:A5)`
`COUNT`	Counts cells containing numbers	`=COUNT(A1:A5)`

The range A1:A5 means all cells from A1 to A5.

Practical Example: Calculating a Bill

Product	Quantity	Price	Total
Notebook	2	£3	`=B2*C2`
Pen	5	£1	`=B3*C3`

For the notebook:

2 × £3 = £6

Instead of calculating every total manually, the formula completes it automatically.

Important Spreadsheet Features

1. Data Entry and Editing

Users can enter, change, copy or delete information inside cells.

2. Formatting

Spreadsheet data can be formatted using:

Font styles and sizes
Bold and italic text
Cell colours
Borders
Currency symbols
Percentage and date formats
Text alignment

Formatting makes large amounts of data easier to understand.

3. Sorting

Sorting arranges data in a particular order.

Examples:

Names from A to Z
Prices from lowest to highest
Marks from highest to lowest
Dates from oldest to newest

4. Filtering

Filtering temporarily displays only the data that matches a condition.

Example: A teacher can filter a marks sheet to display only students who scored more than 80 marks.

5. Charts

Charts turn numerical data into an easy-to-understand visual form.

Common chart types include:

Column chart
Bar chart
Line chart
Pie chart

flowchart TD
    A["Spreadsheet Data"] --> B{"Choose Chart"}
    B --> C["Bar or Column Chart"]
    B --> D["Line Chart"]
    B --> E["Pie Chart"]

Example: A line chart can show how monthly sales increased or decreased during the year.

6. Multiple Worksheets

A workbook can contain several related worksheets.

For example, a yearly budget workbook may include:

January
February
March
Yearly Summary

7. Printing and Sharing

A spreadsheet can be printed, emailed, shared online or exported as a PDF.

Common Spreadsheet File Formats

Extension	Use
`.xlsx`	Common Microsoft Excel workbook format
`.ods`	OpenDocument spreadsheet format
`.csv`	Stores simple tabular data without most formatting
`.pdf`	Used for sharing or printing a final report

A CSV file can store data, but it normally does not preserve charts, colours or multiple worksheets.

Real-Life Uses of Spreadsheets

In Schools

Student marks
Attendance records
Fee details
Timetables

In Businesses

Sales reports
Employee records
Inventory tracking
Profit and loss calculations

At Home

Monthly budget
Shopping list
Expense tracking
Savings planning

Useful Keyboard Shortcuts

Shortcut	Action
`Ctrl + N`	Create a new workbook
`Ctrl + S`	Save the workbook
`Ctrl + C`	Copy selected cells
`Ctrl + V`	Paste cells
`Ctrl + Z`	Undo the last action
`Ctrl + F`	Find data
`Ctrl + P`	Open print options

Advantages of Spreadsheets

Perform calculations quickly.
Automatically recalculate changed values.
Organise large amounts of data.
Create visual charts and reports.
Reduce manual calculation errors.
Make data easier to sort and filter.

Limitations of Spreadsheets

Incorrect formulas can produce incorrect results.
Large spreadsheets may become difficult to manage.
Important data can be lost without backups.
Sensitive files need proper protection.
Spreadsheets are not always suitable for very large or complex databases.

Quick Recap

A spreadsheet organises data into rows and columns.
A workbook contains one or more worksheets.
The meeting point of a row and column is called a cell.
Formulas perform calculations and begin with =.
Functions such as SUM and AVERAGE are ready-made formulas.
Spreadsheets can sort, filter and present data through charts.