Manipulating computerized spreadsheets is a fundamental skill for ICT technicians in Kenya, especially given the widespread use of spreadsheets in financial management, data analysis, and reporting across public institutions and private enterprises. Mastery of spreadsheet creation, understanding cell referencing, and efficient data manipulation enables technicians to support decision-making processes and automate routine tasks. This chapter focuses on building foundational expertise in spreadsheet workbooks, essential interface elements, and advanced editing functions that enhance productivity in environments such as county government offices, banks, and educational institutions.

2.1 Creation of Computerized Spreadsheet Workbook

Creating a computerized spreadsheet workbook is the starting point for any data analysis or reporting task. For ICT technicians, understanding the underlying concepts and interface elements is crucial to designing functional and user-friendly spreadsheets that meet organizational needs. In Kenyan contexts like SACCOs or hospitals, well-structured workbooks streamline data entry, minimize errors, and improve access to critical information.

2.1.1 Spreadsheet concepts

Spreadsheets are digital grids designed to organize, calculate, and analyze data using rows and columns. The core concept revolves around cells, each identified by a unique address combining column letters and row numbers, such as A1 or C5. These cells can contain data types including text, numbers, dates, or formulas that perform calculations automatically.

Example: a secondary school records each learner's marks in a grid, with one row per learner and one column per subject. The deputy principal can then total and rank the marks without a calculator.

Core concepts

• Spreadsheet application: The program used to build and manage spreadsheets, for example Microsoft Excel, LibreOffice Calc or Google Sheets. They share the same basic grid idea, though menus differ slightly.
• Range: A group of adjacent cells selected for operations like formatting, copying, or formula application. A range is written with its first and last cells, for example B2:B10.
• Formula: Expressions starting with an equals sign (=) that perform calculations using cell references and functions.
• Function: A ready-made calculation with a name, such as SUM or AVERAGE, which is placed inside a formula so that the user does not have to write the full calculation by hand.
• Automatic recalculation: When data in referenced cells change, formulas automatically update results, facilitating real-time data analysis.

Example: if B2 holds Ksh 1,500 and B3 holds Ksh 2,500, the formula =B2+B3 shows Ksh 4,000. If B3 is changed to Ksh 3,000, the result updates to Ksh 4,500 without retyping the formula.

Creating and saving a new workbook

A new workbook is the blank file in which all later work is done. Creating it correctly and saving it early with a clear name protects the work against power cuts, which are a real risk in many offices. Example: the accounts clerk of a cooperative society opens a new workbook to record monthly member contributions.

1. Open the spreadsheet application from the Start menu or desktop shortcut. The start screen offers blank and template workbooks.
2. Choose Blank workbook. A new file opens, usually named Book1, with Sheet1 active.
3. Identify the elements of the window: ribbon, formula bar, Name Box, worksheet grid and worksheet tabs.
4. Click cell A1 and type a title for the work, then press Enter. The active cell moves down one row.
5. Type the column headings in row 3, moving across with the Tab key, so that each column has a clear label.
6. Click File, then Save As, and choose the folder where the file will be kept.
7. Type a meaningful file name, such as Member Contributions 2025, and keep the default workbook file type.
8. Click Save. The new name replaces Book1 in the title bar, and later changes are saved with Ctrl+S.

Importance of spreadsheets in Kenyan workplaces

Spreadsheets are used in almost every organization because they combine record keeping with fast, accurate calculation.

• Financial management: In banks and SACCOs, spreadsheets track transactions, calculate interest, and generate financial statements.
• Inventory control: Retail businesses use spreadsheets to manage stock levels and reorder points.
• Human resource management: County governments maintain employee records, attendance, and payroll calculations using spreadsheets.
• Data analysis: Universities and research institutions analyze survey data or academic performance metrics.
• Reporting: Hospitals compile patient statistics and resource utilization reports efficiently.

2.1.2 Elements of spreadsheet window

The spreadsheet window is the user interface through which users interact with the workbook. Familiarity with its components enhances navigation and operational efficiency for ICT technicians who support end-users in various Kenyan organizations.

Understanding these elements allows ICT technicians to guide users in tasks ranging from entering data to creating complex formulas, improving operational efficiency in offices such as county government departments or university administrative units. The main structural elements, namely the worksheet, workbook, rows, columns and cells, are described below.

2.1.2.1 Worksheet

A worksheet is a single page within a workbook, made up of cells arranged in rows and columns for data entry and analysis. Each worksheet has its own tab at the bottom of the window, so a user can keep related but separate data on different pages of the same file. Example: a hotel can keep one worksheet for each month's room bookings, so that January, February and March are each on their own tab.

• Worksheet tabs: Located at the bottom, enabling navigation between multiple sheets within a workbook. Clicking a tab makes that sheet active.
• Active worksheet: The sheet currently displayed. Its tab is highlighted, and any entry made goes into this sheet.
• Grid: Each worksheet contains its own grid of rows and columns. Data on one sheet is independent of the other sheets unless a formula links them.
• Sheet names: Tabs carry default names such as Sheet1, which can be replaced with meaningful names so that users find data quickly.
• Tab navigation arrows: When a workbook has many sheets, the small arrows beside the tabs scroll through the tabs that do not fit on the screen.

2.1.2.2 Workbook

A workbook is the file that contains one or more worksheets; it acts as a container for organizing related data across tabs. When a user saves a spreadsheet, the whole workbook is saved as one file, and its name appears in the title bar. Example: a farm can keep a single workbook called Farm Records 2025 with separate worksheets for milk sales, feed purchases and workers' wages.

• File container: The workbook is saved as one file, for example with the extension .xlsx in Microsoft Excel.
• Contents: A workbook holds worksheets and may also hold charts and other objects that belong to the same task.
• Several workbooks: Many workbooks can be open at once, each in its own window, and users can switch between them.
• Related data together: Keeping related sheets in one workbook makes it easier to link figures between them and to share or back up a complete set of records.
• Default name: A new workbook is named Book1, Book2 and so on until the user saves it under a meaningful name.

2.1.2.3 Rows

A row is a horizontal line of cells running across the worksheet from left to right. Rows are identified by numbers shown in the row headers at the left edge of the window. In current versions of Microsoft Excel a worksheet has 1,048,576 rows. Example: in a county office staff register, row 5 may hold everything about one employee: name, job group, department and salary.

• Row header: The numbered grey button at the left of each row. Clicking it selects the whole row.
• Numbering: Rows are numbered 1, 2, 3 and so on, downwards. The row number forms the second part of every cell address.
• Records: In a table of data, each row normally holds one record, such as one customer, one learner or one item of stock.
• Heading row: The first row of a table usually carries the column titles, and the records begin on the row below it.
• Selecting several rows: Dragging down across the row headers selects a group of adjacent rows so they can be worked on together.

2.1.2.4 Columns

A column is a vertical line of cells running down the worksheet. Columns are labelled with letters in the column headers along the top of the window: A to Z, then AA, AB and so on up to XFD, which is the 16,384th column in current versions of Microsoft Excel. Example: a hardware shop's stock sheet may use column A for item name, column B for quantity and column C for unit price in Ksh.

• Column header: The lettered grey button above each column. Clicking it selects the whole column.
• Lettering: The column letter forms the first part of every cell address, so C5 is in column C.
• Fields: In a table of data, each column normally holds one kind of information, such as names, quantities or prices, so that all entries in it are of the same type.
• Selecting several columns: Dragging across the column headers selects adjacent columns for formatting or calculation.
• Column totals: Because related values sit in the same column, a total or average for the whole column can be calculated with one formula.

2.1.2.5 Cells

A cell is the intersection of a row and column where data or formulas are entered; each cell has a unique reference. The reference is the column letter followed by the row number, so the cell where column C meets row 5 is C5. Example: in a bus company's fare sheet, cell B3 may hold the Nairobi to Kisumu fare of Ksh 1,200.

• Cell address: The unique reference of a cell, such as A1. It identifies the cell in formulas and when moving about the worksheet.
• Name Box: The box at the left of the formula bar that shows the address of the selected cell and can be used to jump to another cell by typing its address.
• Active cell: Highlighted cell where data entry or editing occurs, indicated by a border and cell reference in the name box. Only one cell is active at a time.
• Cell contents: A cell can hold text, numbers, dates or a formula. The Formula Bar shows the actual content of the active cell, even when the cell displays only a calculated result.
• Cell range: A block of neighbouring cells selected together, written as first cell:last cell, for example A2:C8.

Other interface elements

Besides the worksheet grid, the window has several tools that control the file and the work being done. Knowing where each one is helps a technician to guide users quickly.

• Title Bar: Displays the workbook name and application title, helping users identify the active file.
• Menu Bar / Ribbon: Provides access to commands grouped in tabs such as Home, Insert, Formulas, and Data for editing and formatting.
• Formula Bar: Shows the content of the active cell, allowing users to enter or edit data and formulas directly.
• Scroll Bars: Vertical and horizontal bars allow movement across the worksheet to access cells outside the visible area.
• Status Bar: Displays brief information about the current state, such as sum of selected cells or editing mode.

Chapter Summary

This chapter explored the creation of computerized spreadsheet workbooks, beginning with fundamental spreadsheet concepts and the key elements of the spreadsheet window, including worksheets, workbooks, rows, columns, and cells. It then examined various types of cell referencing such as relative, absolute, and mixed references, alongside essential spreadsheet editing features like inserting and removing rows or columns, adjusting dimensions, and managing worksheets through renaming, moving, copying, or deleting. The chapter also covered data manipulation techniques focusing on data entry and the different types of data used within spreadsheets. A detailed discussion on formulas and functions followed, highlighting the syntax and common categories such as arithmetic, logical, and lookup functions, as well as formatting options for worksheets including font styles, alignment, borders, shading, and the use of headers and footers. Finally, the chapter addressed chart generation by exploring different chart types, the process of inserting charts, and how to label and edit them, before concluding with guidance on workbook printing, including print setup and the actual printing process.