Mada za sehemu hiiManaging spreadsheet and data presentationMada 4
- Managing components, worksheets and formatting
- Implementing conditions and data
- Implementing functions and formulas
- Implementing data visualisation with charts and tables
Managing Components, Worksheets and Formatting
A spreadsheet is a powerful tool for organizing and presenting data in rows and columns. In Microsoft Excel, you can enter data, format it for better readability, and manage multiple worksheets within a single workbook. This topic covers the fundamental components of Excel and the essential formatting skills you need to create professional-looking spreadsheets.
Cell
A cell is the smallest unit in a spreadsheet where you can enter data. Each cell can hold:
- Text (such as names or labels)
- Numbers (such as prices or quantities)
- Dates
- Formulas
Every cell is identified by a unique cell address, which combines its column letter and row number. For example, the cell in column D and row 5 has the address D5.
Active Cell
The active cell is the currently selected cell, highlighted with a thick border. Its address appears in the Name Box (address bar) at the top of the worksheet. You activate a cell by clicking on it or using the arrow keys on your keyboard.
Column
A column is a vertical set of cells running from top to bottom. Excel worksheets contain 16,384 columns, labeled alphabetically from A to XFD. You select a column by clicking its letter at the top.
Row
A row is a horizontal set of cells running from left to right. Each worksheet has 1,048,576 rows, numbered from 1 to 1,048,576. Click the row number on the left side to select it.
Fill Handle
The fill handle is a small black square at the bottom-right corner of the active cell. It automatically fills cells with data based on a pattern. To use it:
- Enter a value in a cell
- Click and drag the fill handle down or across
- Release to fill the cells
Fill Handle Options include:
- Copy Cells – copies the same value to all cells
- Fill Series – creates a sequence (1, 2, 3, 4...)
- Fill Formatting Only – copies only the formatting, not values
- Fill Days/Weekdays/Months/Years – fills sequential dates
Address Bar and Formula Bar
- Address Bar (Name Box): Shows the address of the active cell
- Formula Bar: Located below the ribbon, it displays the content of the active cell and allows you to enter or edit data and formulas
Quick Access Toolbar
Located above the ribbon, this toolbar provides quick access to frequently used commands like Save, Undo, and Redo. You can customize it by clicking the dropdown arrow on the right side.
Ribbon
The ribbon is the toolbar at the top of Excel containing tabs (Home, Insert, Formulas, Data, Review, View). Each tab contains groups of related commands.
Status Bar
The status bar at the bottom of the window shows helpful information, including the average, count, and sum of selected cells.
Starting Excel
- Click the Excel icon in the Start menu or search for it
- Excel opens to a start screen
Creating a New Workbook
- Click Blank Workbook on the start screen
- A new workbook named "Book1" opens with three default worksheets (Sheet1, Sheet2, Sheet3)
Saving a Workbook
- Click File → Save As
- Enter a filename and choose a location
- Click Save

Insert a New Sheet
- Right-click on an existing sheet tab → Insert → select worksheet type → OK
- Or click the + button next to the sheet tabs
Delete a Sheet
- Right-click on the sheet tab → Delete
- Note: Excel will prompt you to confirm if the sheet contains data
Rename a Sheet
- Double-click the sheet tab and type the new name
Enter Data in a Cell
- Click the cell to select it
- Type the data using your keyboard
- Press Enter to move to the next cell or Tab to move right
Edit Data in a Cell
- Double-click the cell, or select it and press F2, then make your changes
- You can also edit directly in the formula bar
Cut, Copy, and Paste
- Cut: Select cells → right-click → Cut (or press Ctrl + X)
- Copy: Select cells → right-click → Copy (or press Ctrl + C)
- Paste: Right-click → Paste (or press Ctrl + V)
Change Font Style and Size
- Select the cells
- On the Home tab, choose a font from the Font dropdown
- Select the font size from the Font Size dropdown
Change Cell Alignment
On the Home tab, use the alignment buttons:
- Horizontal: Left, Center, Right
- Vertical: Top, Middle, Bottom
Apply Borders
- Select the cell or range
- Go to Home → click the Borders dropdown
- Choose the border style you want
Merge and Unmerge Cells
To merge cells:
- Select the cells you want to merge
- Go to Home → Merge & Center in the Alignment group
- Click OK in the dialog box
To unmerge:
- Select the merged cells
- Click Merge & Center again to unmerge
Change Column Width or Row Height
Manual adjustment:
- Select the column or row
- Go to Home → Format → Column Width or Row Height
- Enter the desired size and click OK
Auto-fit to data:
- Select the column or row
- Double-click the boundary to auto-fit
Format Currency Values
Method 1 – Type the dollar sign:
- Double-click the cell and press Shift + $ before the number
Method 2 – Use formatting:
- Select the cells
- Go to Home → Number Format dropdown → Currency
- The currency symbol (such as TSh for Tanzanian Shillings) will be added
Scenario: You are helping a small shop owner in Arusha organize their inventory. You need to create a spreadsheet to track item prices.
Step 1: Open Excel and create a new workbook
Step 2: Enter the following data in cells A1 to B5:
| A | B |
|---|---|
| Item | Price (TSh) |
| Rice (1kg) | 1500 |
| Sugar (1kg) | 2000 |
| Cooking Oil (1L) | 3500 |
Step 3: Format the worksheet:
- Make "Item" and "Price (TSh)" bold (select → Home → Bold)
- Add currency formatting to column B: Select B2:B5 → Home → Number Format → Currency
- Adjust column width: Select column A → Home → Format → Column Width → enter 15 → OK
- Add borders: Select A1:B5 → Home → Borders → All Borders
Step 4: Save the workbook as "Inventory" in your documents folder
| Task | How to Do It |
|---|---|
| Select a cell | Click on it |
| Select a column | Click the column letter |
| Select a row | Click the row number |
| Enter data | Type and press Enter |
| Copy data | Ctrl + C |
| Cut data | Ctrl + X |
| Paste data | Ctrl + V |
| Bold text | Ctrl + B |
| Save workbook | Ctrl + S |
| Insert new sheet | Click + button |
| Delete sheet | Right-click tab → Delete |
In Tanzania, market vendors and small business owners can use spreadsheet formatting skills to organize their daily sales records. For example, a mama lisisha (vegetable vendor) at Mlimani City market can create a spreadsheet with columns for item names, quantities sold, and prices in Tanzanian shillings, then use cell borders, bold headers, and currency formatting to make a neat sales record that helps them track profits and plan restocking.
Jinsi utakavyotathminiwaTathmini ya mchakato · Tathmini ya matokeo · Tathmini ya maarifa
Tathmini ya mchakato
The student should be able to:
- Insert and adjust rows, columns, and cells in a spreadsheet
- Create, rename, and manage multiple worksheets.
- Apply formatting features such as font styles, borders, shading, and conditional formatting.
- Organize data into logical categories and use sorting andfiltering tools effectively.
Tathmini ya matokeo
The spreadsheet is well-organized, with structured worksheets and clear, visually appealing formatting.
Tathmini ya maarifa
Methods used: The trainee should explain how to:
- Format cells, rows, and columns to improve the readability of data.
- Use worksheet management tools, such as grouping and linking worksheets.
- Apply conditional formatting to emphasize important data points.
Principles: The student should explain the principle of:
- Effective data organization and visual hierarchy.
- Formatting standards for professional data presentation.
Theories: The trainee should explain: The trainee should explain:
- Visual data communication and its impact on understanding.
- The importance of consistency in spreadsheet formatting for collaboration.
Detailed knowledge about:
- Common formatting errors and how to prevent them.
- The role of templates and pre-defined styles in professional spreadsheets.
Swali
What is the address of a cell located in column AB and row 11?
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