Spreadsheets

1. Concept and Use Case

A spreadsheet is a software application used to organise, calculate, and present data in a grid of rows and columns. Within the approved notes, the spreadsheet application treated in detail is Microsoft Excel, and the surrounding material establishes the computing context in which such software operates: a computer is an electronic device capable of executing instructions, developed based on algorithms stored in its memory, to process data fed to it and produce the required results faster than human beings. Spreadsheet software is one of the system and application programs supplied with modern computers, and it exploits the defining characteristics of computers described in the notes — speed, accuracy, diligence, versatility, and the power of remembering — to handle repetitive numerical and record-keeping work reliably.

The use case for spreadsheets follows directly from these characteristics. Because a computer performs in a very few seconds the amount of work a human being could do in a year, and because it is free from monotony, tiredness, and lack of concentration, a spreadsheet is suited to tasks such as preparing bills, keeping lists of records, performing arithmetic calculations, and producing charts that summarise data. The notes describe versatility as the ability of a computer to perform various tasks with ease — searching for a letter, preparing an electricity bill, writing a report, and doing an arithmetic calculation — and a spreadsheet is precisely the kind of general-purpose tool that supports this range within a single document.

Microsoft Excel is the spreadsheet program covered by this unit. The unit proceeds from the identity and purpose of Excel, through the layout of the Excel window, the management of workbooks and worksheets, the entry of data, the formatting of a worksheet, the application of borders, the use of operators in calculations, and finally the creation of charts. Each of these subtopics builds on the previous one: data must be entered before it can be formatted, operators are needed to compute values from entered data, and charts are built from data that has already been organised in a worksheet.

2. Data, Syntax, and Core Concepts

2.1 Microsoft Excel

Microsoft Excel is the spreadsheet application studied in this unit. A spreadsheet stores information in a grid, and Excel is the program through which that grid is created, edited, calculated, and presented. The notes treat Excel as an application program — that is, software provided to the user to accomplish a particular kind of work, in contrast with system software that manages the computer itself. The core objects of Excel are the workbook, the worksheet, cells, rows, and columns, and the core activities are entering data, formatting the worksheet, applying borders, using operators to calculate, and building charts.

2.2 The Excel Window

The Excel window is the on-screen environment in which a workbook is displayed and manipulated. It presents the worksheet grid together with the controls needed to work with it. The notes identify the ribbon-based arrangement of commands, in which operations are grouped under tabs such as the Home tab, from which commands such as inserting a worksheet and deleting a sheet are issued. The window therefore provides both the working area — the grid of cells — and the command area from which actions on the workbook and its sheets are performed. Understanding the window is a prerequisite for every later operation, because inserting sheets, deleting sheets, formatting, and applying borders are all carried out through commands located in this environment.

2.3 Working with Workbooks and Worksheets

A workbook is the file-level container, and worksheets are the individual sheets within it. A workbook may contain more than one worksheet, and the notes describe the operations for managing them.

To insert a new worksheet, the procedure given in the notes is: on the Home tab, click Insert and then choose Worksheet.

To delete sheets from a workbook, the procedure given in the notes is: first select the sheets you want to delete, then on the Home tab select Delete Sheet.

These two operations establish the basic lifecycle of worksheets within a workbook: sheets are added when more working areas are needed and removed when they are no longer required. Selecting sheets before deleting them is essential, because the delete command acts on the selected sheets.

2.4 Entering Data

Entering data is the act of placing information into the cells of a worksheet. Data entered into cells becomes the raw material for all later operations: formatting changes how it appears, operators compute new values from it, and charts display it graphically. The notes also connect data entry to the idea of records and fields, describing a unique field as an identification key that identifies each record individually and noting that a unique field is required in every table. This concept of a unique identifier is relevant whenever data is entered as a list of records, because it prevents duplicated records from being created.

The principle stated in the notes is that a unique field is required in every table, functioning as an identification key like a national identity card that identifies each person individually. Where a suitable unique field does not exist in the design, a special automatically generated field containing sequential or random numbers can be included, and this field is populated automatically as new records are added. This matters during data entry because it guards against entering duplicated records.

2.5 Formatting a Worksheet

Formatting a worksheet is the process of changing the appearance of the worksheet and its contents without changing the underlying data. It is the stage that follows data entry and precedes presentation. Formatting makes a worksheet readable and gives it a consistent, professional appearance, and it is carried out through commands in the Excel window. The notes treat formatting as a distinct subtopic because the same data can be presented in many different ways, and the choice of presentation affects how easily the information can be read and interpreted.

2.6 Applying Borders

Applying borders is the operation of drawing lines around cells, ranges, or the worksheet as a whole in order to separate and delineate areas of the grid. Borders are a formatting operation, and they are treated as a subtopic in their own right because they serve a specific purpose: they make the structure of the worksheet visible, distinguishing one region of data from another and giving tables a defined outline. Like other formatting, borders change appearance only and do not alter the values held in the cells.

2.7 Operators

Operators are the symbols or commands used to combine values in order to produce a calculated result. They are the mechanism by which a spreadsheet performs the arithmetic work for which it is valued. The notes situate this within the general capability of computers to carry out arithmetic calculations with speed and accuracy, and within the versatility of the machine, which can perform an arithmetic calculation as readily as it can search for a letter or prepare a bill. In a worksheet, operators are applied to the contents of cells so that the result of a calculation is displayed in the cell where the calculation is defined. The categories of operator relevant to spreadsheet work are the arithmetic operators used for calculation and the comparison operators used to test relationships between values; the notes establish the role of operators in producing calculated results from entered data.

2.8 Working with Charts

A chart is a graphical representation of worksheet data. Working with charts is the final subtopic of the unit and depends on all the preceding ones: data must be entered, organised, and often formatted before it can be charted, and the values that a chart displays are frequently the results of calculations performed with operators. Charts convert columns of numbers into a visual form so that patterns, comparisons, and trends can be seen at a glance rather than read from individual cells. The notes place charts within the broader purpose of presentation, alongside formatting and borders, as the means by which worksheet content is communicated to a reader.