Applying spreadsheet manipulation skills is essential for office administration professionals in Kenya, as spreadsheets facilitate data organization, analysis, and reporting tasks critical to effective office management. Mastery of spreadsheet window elements and the ability to efficiently open new workbooks enable users to navigate and utilize spreadsheet software such as Microsoft Excel or Google Sheets with confidence. These skills support diverse administrative functions including budgeting, scheduling, and record keeping across various sectors such as county government offices, banks, and healthcare institutions.

13.1 Spreadsheet window elements

A spreadsheet program such as Microsoft Excel opens a workbook in a window made of several elements. Knowing them makes it quicker to move around, enter data and find commands. The description follows Excel for Windows; Google Sheets and LibreOffice Calc have equivalent elements.

Other elements of the window

• Title bar: shows the workbook's name.
• Quick Access Toolbar: Save, Undo, Redo and any added commands.
• Formula bar: shows and edits the contents of the active cell (the formula itself, not only its result).
• Column headings: the letters A, B, C ... across the top of the grid.
• Active cell: the selected cell, with a thick border; its address appears in the Name box.
• Status bar and zoom slider: at the bottom of the window.

13.1.1 Name box

The Name box is at the left end of the formula bar. It shows the address of the active cell (for example C5) or the name of a selected range. Typing an address in it and pressing Enter jumps straight to that cell (for example typing Z500 in a large sheet). It is also used to name a range: select the cells, type a name such as Expenses (no spaces) in the Name box and press Enter; the name can then be used in formulas, for example =SUM(Expenses). Names are managed in Formulas, Name Manager.

13.1.2 Ribbon

The ribbon is the band of commands across the top of the window, arranged in tabs (File, Home, Insert, Page Layout, Formulas, Data, Review, View, Help), each divided into groups. For example, the Home tab holds the Clipboard, Font, Alignment, Number, Styles, Cells and Editing groups; the Formulas tab holds the Function Library; the Data tab holds Sort and Filter. Hovering over a button shows a tooltip; pressing Alt shows the keyboard key letters for each command; Ctrl + F1 collapses or shows the ribbon.

13.1.3 Sheet tabs

Sheet tabs at the bottom left show the worksheets in the workbook (Sheet1, Sheet2 ...). Clicking a tab opens that sheet; the + button adds a new sheet. Right-clicking a tab gives commands to rename, insert, delete, move or copy, hide and colour the tab. Giving sheets meaningful names (January, February, Summary) makes a workbook easy to follow. Ctrl + Page Down and Ctrl + Page Up move between sheets.

13.1.4 Row headings

Row headings are the numbers 1, 2, 3 ... down the left side of the grid, identifying each row (columns are identified by letters). Together they give each cell its address, such as B4 (column B, row 4). Clicking a row heading selects the whole row; dragging the border below a row heading changes its height; right-clicking it gives Insert, Delete, Hide and Unhide. Freezing panes (View, Freeze Panes) keeps heading rows visible while scrolling.

13.1.5 Calculated items

Spreadsheets show calculated results in several places:

• Formula results in cells: a cell containing a formula displays its calculated value, while the formula bar shows the formula.
• Status bar calculations: when several cells with numbers are selected, the status bar shows their Average, Count and Sum at once, without writing a formula; right-clicking the status bar adds Minimum, Maximum and Numerical Count.
• Calculated items and fields in PivotTables: in a PivotTable report, a calculated field or calculated item is a formula added to the PivotTable (PivotTable Analyze, Fields, Items and Sets), for example to show the total of two product groups or a commission on sales.

Calculation is automatic by default (Formulas, Calculation Options: Automatic), so results update when the data changes.

Chapter Summary

This chapter provided a detailed overview of spreadsheet manipulation skills, beginning with the identification and understanding of key spreadsheet window elements such as the name box, ribbon, sheet tabs, row headings, and calculated items. It then explained the process of opening a new workbook to initiate spreadsheet work. The chapter explored essential spreadsheet features including formulas and functions, worksheets, workbooks, and individual cells, emphasizing their roles in organizing and processing data. Keyboard techniques were covered to enhance efficiency when navigating and editing spreadsheets. The step-by-step approach to creating formulas and functions was outlined, from selecting a cell, starting the formula, adding functions, completing the formula, to pressing Enter to execute calculations. Finally, the chapter addressed the presentation of data through tables and charts, highlighting how these visual tools improve data interpretation and reporting. This comprehensive guide equips learners with the foundational skills necessary for effective spreadsheet use in various professional settings.