ICT
PRACTICAL
Name: Umaeer Imdad
Roll No.: 39
Class: IX (9)
Section: C
Subject: ICT (Internet and
Communication Technology)
Presentation Subject: Microsoft
Spreadsheet
SPREADSHEET
A software application that organizes and
analyzes data in rows and columns
What is a Spreadsheet?
A spreadsheet is software used
to store, organize, and analyze
data.
Data is organized in rows and
columns, forming cells.
Popular spreadsheet software:
Microsoft Excel.
Used in business, education,
and personal data management.
Key Features of Microsoft
Spreadsheet
Formulas: Automatic calculations
like addition, subtraction, averages.
Charts & Graphs: Visualize data
trends quickly.
Sorting & Filtering: Organize data
for easy analysis.
Formatting Tools: Change fonts,
colors, borders, and conditional
formatting.
Advantages of Using
Spreadsheets
Saves time and reduces manual
errors.
Can handle large datasets
efficiently.
Simplifies
data analysis and
decision-making.
Improvesproductivity in
professional and academic tasks.
Common Uses of
Spreadsheets
Budgeting and Finance: Track
expenses and income.
Attendance & Marks: Track student
attendance or grades.
Inventory Management: Manage
stock levels for businesses.
Data Analysis: Generate reports,
charts, and summaries.
Spreadsheet Layout
Workbook: Collection of
worksheets.
Worksheet: Grid of rows
(numbers) and columns (letters).
Cells: Intersection of a row and
column (e.g., A1).
Formula Bar: Displays the content
or formula of the active cell.
Basic Calculations
Addition: =A1+B1
Subtraction: =A1-B1
Multiplication: =A1*B1
Division: =A1/B1
Tip: Always start formulas with
'='.
Calculating Percentages
Formula: (Part / Total) * 100
Example: =(B2/C2)*100 → 50%
Usethe '%' button in Excel to
format results.
Common Functions
SUM(range): Adds all numbers in
the range.
AVERAGE(range): Calculates the
mean of numbers.
MAX(range)/MIN(range): Finds
highest/lowest values.
IF(condition, value_if_true,
value_if_false): Conditional logic.
Formatting Data
Change font styles, sizes, and
colors.
Apply cell borders and shading.
Useconditional formatting to
highlight important data.
Charts and Graphs
Bar Chart: Compare values across
categories.
Line Chart: Show trends over time.
Pie Chart: Show percentage
contribution.
Use charts to visualize data
quickly and clearly.
Sorting and Filtering
Sort:Arrange data ascending or
descending (A→Z,
smallest→largest).
Filter:
Display only specific rows
matching criteria.
Helps quickly analyze large
datasets.
Excel Shortcuts
Pressing “Ctrl+C” would result
copying the text
Pressing “Ctrl+V” would result
pasteing the text
Press “Ctrl+Z” to undo the last thing
Press “Ctrl+S” to save
“Alt+=” would AutoSum
Good Practices
Save your work frequently.
Useclear headings for rows and
columns.
Double-check formulas for
accuracy.
Keepdata organized and
readable.
Conclusion
Microsoft
Excel is essential for
managing data efficiently.
Helpsin saving time, improving
accuracy, and analyzing
information.
Learning spreadsheet skills
builds strong ICT competence.