Mada za sehemu hiiWorking with spreadsheetsMada 5
- Performing spreadsheet creation, formatting, data entry, organization, sort and filter
- Performing basic calculations and formulas
- Performing data validation and conditional formatting
- Performing data import and export
- Performing page setup and printing
A spreadsheet is an electronic document that organizes data in rows and columns, making it easy to calculate, analyze, and manage information. In this topic, you will learn how to create a spreadsheet, enter data, format it for better appearance, and use sort and filter tools to organize your data efficiently.
A spreadsheet is made up of:
- Rows — horizontal lines numbered 1, 2, 3, ...
- Columns — vertical lines labeled A, B, C, ...
- Cells — the boxes where rows and columns meet (like cell A1, cell B2)
- Worksheet — a single page of rows and columns
- Workbook — a file that can contain multiple worksheets
Microsoft Excel is the most common spreadsheet program used in offices and schools.
To create a new spreadsheet in Excel:
- Open Excel from the Start menu or desktop shortcut
- Select Blank Workbook to start with an empty sheet
- Save your file by clicking File > Save As, choose a location, and give your file a meaningful name (for example, "Class1_Sales")
Always save your work frequently to avoid losing data.
Data can be entered directly into cells by clicking on a cell and typing:
- Click on the cell where you want to enter data
- Type the information using your keyboard
- Press Enter to move to the next row, or Tab to move to the next column
- To edit existing data, double-click the cell or press F2
Types of data you may enter:
- Text — names, descriptions (e.g., "Mwinyi", "Dar es Salaam")
- Numbers — quantities, prices (e.g., 1500, 25000)
- Dates — calendar dates (e.g., 01/01/2025)
- Formulas — calculations that begin with "=" (e.g., =B2+C2)
Formatting makes your spreadsheet easier to read and understand.
Basic Cell Formatting
- Select the cells you want to format
- Right-click and choose Format Cells, or use the formatting toolbar
- You can change:
- Font — size, bold, italic, color
- Number format — currency, decimal places, percentage
- Alignment — left, center, right
- Borders — lines around cells
- Fill color — background color for cells
Creating a Table
To format your data as a table:
- Select your data range (including headers)
- Go to Home > Format as Table
- Choose a table style you like
- Make sure "My table has headers" is checked if your first row contains titles
Tables make sorting and filtering easier.
Before sorting or filtering, ensure your data is well-organized:
- Each column should have a clear heading (header row)
- No empty rows or columns within your data
- Each row should represent one record
- Keep related data together
Sorting arranges your data in order — either ascending (A to Z, smallest to largest) or descending (Z to A, largest to smallest).
To Sort Data:
- Click on any cell within your data range
- Go to Data > Sort
- Choose the column you want to sort by
- Select Ascending (A to Z) or Descending (Z to A)
- Click OK
For example, if you have a list of students with their scores, you can sort by score to see who got the highest marks.
Filtering hides rows that do not meet certain criteria, showing only the data you want to see.
To Apply Filters:
- Click on any cell in your data range
- Go to Data > Filter
- Arrow buttons appear next to each column header
- Click the arrow and uncheck the items you want to hide, or check the ones you want to see
- Click OK
To remove the filter, go to Data > Filter again to turn it off, or click Clear in the filter menu.
A small shop owner in Arusha wants to track the sales of five items over three days. Here is how the data looks:
| Item | Price (TSh) | Mon | Tue | Wed |
|---|---|---|---|---|
| Sugar | 2500 | 20 | 15 | 25 |
| Rice | 12000 | 10 | 12 | 8 |
| Flour | 3500 | 18 | 20 | 22 |
| Oil | 8000 | 5 | 7 | 6 |
| Salt | 1000 | 30 | 25 | 28 |
Task 1: Sort items by price (ascending)
After sorting by Price, the order becomes: Salt (1000), Sugar (2500), Flour (3500), Oil (8000), Rice (12000).
Task 2: Filter to show only items with price above 3000 TSh
The filter shows only Flour, Oil, and Rice — hiding Sugar and Salt because their prices are 3000 TSh or below.
- Spreadsheets organize data in rows and columns within cells
- Always save your work and use clear headings
- Formatting improves readability — use bold, colors, borders, and tables
- Sorting arranges data in order (A–Z or Z–A) by a chosen column
- Filtering shows only rows that meet your criteria, hiding the rest
- Both tools help you find and analyze information quickly
In Tanzania, market vendors and small shop owners can use spreadsheets to track their daily sales and inventory. For example, a shopkeeper in Mwanza can enter the items they sell (like rice, sugar, and cooking oil), record how many units were sold each day, and then use sort to see which item sells the most, or filter to view only items that need restocking. This helps them make better decisions about what to buy and how to price their goods.
Jinsi utakavyotathminiwaTathmini ya mchakato
Tathmini ya mchakato
Ability to work with Spreadsheet Applications
Swali
What is a cell in a spreadsheet?
Ingia ili kuwasilisha jibu lako na lihesabiwe katika umahiri wako.
Ingia ili kufanya mazoeziMwalimu
Umekwama? Niulize chochote kuhusu mada hii.
Ingia ili kumuuliza Mwalimu wa AI wa Sonza kuhusu swali hili.
Ingia ili kuulizaMajadiliano
Hakuna maswali bado