Scribd
Upload
7 views3 pages

Here Are Well

The document provides comprehensive ICT notes on spreadsheet software, including definitions, structure, basic features, formulas, charts, data tools, and uses. It highlights key functionalities such as data entry, cell referencing, and what-if analysis, along with advantages like time-saving and visual data representation. The notes are suitable for IGCSE or general ICT studies and cover software like Microsoft Excel and Google Sheets.

Uploaded by

khushank23810
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views3 pages

Here Are Well

The document provides comprehensive ICT notes on spreadsheet software, including definitions, structure, basic features, formulas, charts, data tools, and uses. It highlights key functionalities such as data entry, cell referencing, and what-if analysis, along with advantages like time-saving and visual data representation. The notes are suitable for IGCSE or general ICT studies and cover software like Microsoft Excel and Google Sheets.

Uploaded by

khushank23810
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Here are well-organized ICT Notes on Spreadsheet Software (Excel, Google Sheets) — perfect for

IGCSE or general ICT studies:

Spreadsheet Software – ICT Notes

1. What is a Spreadsheet?

A spreadsheet is a program used to organize, analyze, and store data in tabular form (rows and
columns).

Examples:

• Microsoft Excel

• Google Sheets

• LibreOffice Calc

2. Structure of a Spreadsheet

• Workbook: A full spreadsheet file.

• Worksheet: A single sheet inside the workbook.

• Cell: Each box in the sheet (identified by column letter and row number, e.g., A1).

• Row: Horizontal line of cells.

• Column: Vertical line of cells.

• Range: A group of selected cells (e.g., A1:B5).

3. Basic Features

• Data Entry: Numbers, text, dates

• Formatting: Fonts, colors, borders, alignment

• AutoFill: Extends patterns (e.g., days, numbers)

4. Formulas and Functions

Formulas begin with = sign.

Common Formulas:

• =A1+B1 → adds values from A1 and B1

• =A1*B1 → multiplies values

Common Functions:
• =SUM(A1:A5) → adds values in A1 to A5

• =AVERAGE(B1:B5) → finds average

• =MIN(), =MAX(), =COUNT()

5. Charts & Graphs

Used to display data visually.

Types:

• Bar Chart

• Pie Chart

• Line Graph

• Column Chart

6. Data Tools

• Sorting: Alphabetical or numerical order

• Filtering: Show only selected data

• Conditional Formatting: Highlights cells based on rules

7. Cell Referencing

• Relative: Adjusts when copied (A1 → A2)

• Absolute: Fixed reference using $ (e.g., $A$1)

8. What-if Analysis

Change inputs to see effect on outputs (e.g., budget planning).

9. Uses of Spreadsheets

Budgeting and Accounting


Marksheets and Results
Business Reports
Data Analysis
Sales & Inventory

10. Advantages
Easy to analyze large data
Automatic calculations
Time-saving
Visual display of trends

Would you like all these ICT notes (Applications, Database, Word, PPT, Excel) combined into one
single PDF, or should I create separate PDFs for each topic?

You might also like