Practical Exercise

Learners have learned how to:

• understand the spreadsheet interface
• enter and correct data
• use formulas and functions such as SUM, AVERAGE, MIN, MAX, and MEDIAN
• edit and format worksheets
• create charts

Create a worksheet named Student Scores with the following data:

Tasks

1. Enter the data into the worksheet.

2. Add a new column called Average.

3. Use a formula to calculate the average score for each student.

4. At the bottom, calculate:

• minimum average
• maximum average
• median average
• overall class average

5. Format the table neatly 

• Using your own creativity - Interesting and yet professional

6. Create a chart that is relevant and explain why you use this type of chart

Creating a Chart

What is a Chart?

A chart is a visual representation of data.

Common Types of Charts

1. Column chart: compares values
2. Bar chart: compares categories
3. Pie chart: shows proportions
4. Line chart: shows trends over time

Steps to Create a Chart

1. Select the data.
2. Click Insert.
3. Choose a chart type.
4. Add a chart title.
5. Edit labels if needed.

Example

Questions

1. What is the best Chart for This Data
2. Which item has the highest sales

Editing and formatting a worksheet

Editing a Worksheet

Editing means changing the worksheet content or layout.

Common Editing Actions

1. insert rows or columns
2. delete rows or columns
3. copy and paste data
4. cut and move data
5. rename sheet tabs

Formatting a Worksheet

Formatting makes the worksheet easier to read and more attractive.

Common Formatting Actions

1. bold text
2. change font size
3. change text color
4. fill cell color
5. add borders
6. center align text
7. format numbers as currency, percentage, or date

Example of Good Formatting

For a sales table:

1. make headings bold
2. add borders to the table
3. highlight headings with color
4. format prices as currency
5. adjust column width

Exercise 5: Editing and Formatting

Use the table from previous Exercise

Task

1. Make the headings bold.
2. Change the heading row color.
3. Add borders to all cells.
4. Format the Price and Total columns as currency.
5. Center-align the headings.
6. Rename the sheet tab as Sales Data.

Using formulas and functions (min, max, median, average, sum)

What is a Formula?

A formula is an equation used to calculate values in a spreadsheet. Every formula starts with =.

Example:

=B2*C2

What is a Function?

A function is a built-in formula.

Common Functions

SUM = adds values

AVERAGE = finds the mean

MIN = finds the smallest value

MAX = finds the largest value

MEDIAN = finds the middle value

Example Data

Enter this in cells A1:B6:

How to Use Functions

Assume marks are in cells B2:B6.

1. Total marks: =SUM(B2:B6)
2. Average marks: =AVERAGE(B2:B6)
3. Minimum marks: =MIN(B2:B6)
4. Maximum marks: =MAX(B2:B6)
5. Median marks: =MEDIAN(B2:B6)

Exercise 3: Functions Practice

Using the marks table above, calculate:

1. Total marks
2. Average marks
3. Highest marks
4. Lowest marks
5. Median marks

Exercise 4: Formula Practice

Enter this table in cells A1:C5:

Task

1. In column D, create a heading called Total.
2. In cell D2, enter a formula to calculate Quantity × Price.
3. Copy the formula down to D5.
4. In D6, calculate the grand total using SUM.

Entering and Correcting Data

How to Enter Data

1. Click on a cell.
2. Type the data.
3. Press Enter.

Types of Data

1. Text: names, subjects, items
2. Numbers: marks, prices, quantities
3. Dates: 12/4/2026
4. Formulas: =A1+B1

How to Correct Data

Method 1: Double-click the cell

Double-click the cell and edit the content.

Method 2: Use the formula bar

Click the cell, then edit the content in the formula bar.

Method 3: Replace the data

Click the cell, type new data, and press Enter.

Exercise 2: Enter and Correct Data

Enter the following table into a worksheet starting from cell A1:

Task

1. Change the quantity of Book from 5 to 7.
2. Change the price of Ruler from 2.00 to 2.50.
3. Correct Eraser to Pencil.

Spreadsheet Interface What is a Spreadsheet?

 What is a Spreadsheet?

A spreadsheet is a computer program used to organize data in rows and columns. It helps users calculate values, present information neatly, and create charts.

Examples of spreadsheet software:

• Microsoft Excel
• Google Sheets
• LibreOffice Calc

Spreadsheets are useful for students, teachers, businesses, and anyone who works with numbers or lists.

Main Parts of the Interface

a) Workbook

A workbook is the whole spreadsheet file.

b) Worksheet

A worksheet is one page inside the workbook.

c) Rows

Rows run horizontally and are numbered: 1, 2, 3, and so on.

d) Columns

Columns run vertically and are labeled: A, B, C, and so on.

e) Cell

A cell is the box where a row and column meet, such as A1 or B3.

Example:

• A1 = Column A, Row 1
• C5 = Column C, Row 5

f) Formula Bar

This shows the content or formula in the selected cell.

g) Sheet Tabs

These are found at the bottom and allow you to move between worksheets.

h) Ribbon / Toolbar

This contains commands such as save, format, insert chart, and functions.

Exercise 1: Identify the Interface (Explain to the person next to you)

Open a spreadsheet application and identify:

1. Workbook
2. Worksheet
3. Row
4. Column
5. Cell A1
6. Formula bar
7. Sheet tabs
8. Toolbar or ribbon
9. Task

Write down the cell reference for:

1. the cell in column C and row 5
2. the cell in column A and row 10
3. the cell in column E and row 2

Conclusion

Spreadsheets are very useful for organizing information, doing calculations, and presenting data clearly. By learning the interface, entering data, using formulas and functions, formatting worksheets, and creating charts, students can perform many basic tasks more easily and accurately.

Step-by-Step Guide with Exercises: Introduction to Spreadsheets

Step-by-Step Guide with Exercises: Introduction to Spreadsheets

By the end of this guide, learners should be able to:

• identify the main parts of a spreadsheet interface
• enter and correct data
• use basic formulas and functions
• edit and format a worksheet
• create a chart