Entering Data into a Worksheet
A spreadsheet worksheet is made up of rows and columns that form individual cells. Users can enter different types of information into these cells to organise data, perform calculations and analyse information.
Understanding the different types of cell contents is essential when working with spreadsheet software such as Microsoft Excel and LibreOffice Calc.
1. Types of Cell Contents
A cell can contain three main types of content:
- Labels (Text)
- Values (Numerical Data)
- Formulas
Each type has a different purpose and is handled differently by spreadsheet software.
1.1 Labels (Text)
A label is text or another character entered into a worksheet to identify, describe or provide information about data.
Labels are commonly used for headings, names, descriptions and addresses.
Characteristics of Labels:
- Labels can contain letters, numbers and special symbols.
- They are mainly used to describe or identify information.
- They do not normally perform mathematical calculations.
- Labels are left-aligned by default in most spreadsheet applications.
- Student Name
- Total Marks
- Colombo
- January 2026
- Product A
- Class
Purpose of Labels:
Labels make a worksheet easier to understand by explaining what the entered data represents.
For example, in a student marks worksheet, headings such as Student Name, Subject and Marks help users identify the information stored in each column.
1.2 Values (Numerical Data)
A value is numerical data entered into a cell. Values can be used in mathematical calculations and data analysis.
Values are commonly used to represent quantities, measurements, dates, times and financial information.
Types of Values:
| Type | Description | Example |
|---|---|---|
| Integers | Whole numbers without decimal points | 25, 100 |
| Decimals | Numbers containing decimal points | 3.75, 12.50 |
| Fractions | Numbers representing parts of a whole | 1/2, 3/4 |
| Percentages | Values expressed as a percentage | 60%, 85% |
| Dates | Calendar dates | 2026-01-15 |
| Times | Time values | 14:30 |
| Currency | Monetary values | Rs. 1,250.00 |
Characteristics of Values:
- Values represent numerical information.
- They can be used in mathematical calculations.
- They can be processed using formulas and functions.
- They are right-aligned by default in most spreadsheet applications.
Consider a worksheet containing the marks of students:
| Student Name | Mathematics | Science |
|---|---|---|
| Kavindu | 85 | 78 |
| Nimashi | 92 | 88 |
| Sahan | 75 | 80 |
Here:
- Student Name contains labels.
- Mathematics and Science marks contain numerical values.
The marks can be used to calculate totals, averages and other results.
1.3 Formulas
A formula is an expression entered into a cell to perform a calculation using numbers, cell references, mathematical operators or functions.
A formula always begins with an equal sign (=).
Characteristics of Formulas:
- Every formula begins with an equal sign (=).
- Formulas can use numbers and mathematical operators.
- They can refer to other cells in the worksheet.
- They can use built-in functions such as SUM and AVERAGE.
- The cell displays the calculated result rather than the formula itself (unless the formula is being edited or formula display is enabled).
Common Mathematical Operators:
| Operator | Meaning | Example |
|---|---|---|
| + | Addition | =A1+B1 |
| - | Subtraction | =A1-B1 |
| * | Multiplication | =A1*B1 |
| / | Division | =A1/B1 |
| ^ | Power | =A1^2 |
Consider a worksheet containing product information:
| Item | Quantity | Price (Rs.) | Total (Rs.) |
|---|---|---|---|
| Pen | 5 | 50 | =B2*C2 |
| Book | 3 | 120 | =B3*C3 |
| Eraser | 10 | 30 | =B4*C4 |
For the first product:
- Quantity is stored in cell B2.
- Price is stored in cell C2.
- The formula
=B2*C2multiplies the quantity by the price.
The result displayed in D2 is Rs. 250.
Using Functions in Formulas
A spreadsheet also provides built-in functions to perform commonly required calculations.
Examples:
=SUM(A1:A5)โ Adds the values from A1 to A5.=AVERAGE(A1:A5)โ Calculates the average of the values from A1 to A5.=MAX(A1:A5)โ Finds the highest value.=MIN(A1:A5)โ Finds the lowest value.
2. Default Alignment of Data
Alignment determines how the contents of a cell are positioned within the cell.
Spreadsheet applications automatically apply default alignment depending on the type of content entered.
Default Alignment Types
1. Labels โ Left Alignment
Text and labels are positioned towards the left side of the cell by default.
2. Values โ Right Alignment
Numerical values, including numbers, dates and times, are generally positioned towards the right side of the cell by default.
3. Formula Results โ Right Alignment
Formula results are generally right-aligned because they are treated as numerical results.
Comparison of Default Alignment
| Type of Data | Default Alignment |
|---|---|
| Labels (Text) | Left |
| Values (Numbers, dates, etc.) | Right |
| Formula results | Right |
| Product | Price (Rs.) | Total (Rs.) |
|---|---|---|
| Pencil | 40 | 40 |
| Notebook | 120 | 120 |
| Bag | 2,500 | 2,500 |
- Product names are labels and appear left-aligned.
- Prices are numerical values and appear right-aligned.
- Total values calculated using formulas also appear right-aligned.
Important: Default alignment can be changed manually using the alignment tools available in spreadsheet software.
3. Difference Between Labels, Values and Formulas
| Feature | Labels | Values | Formulas |
|---|---|---|---|
| Main purpose | Describe information | Represent numerical data | Perform calculations |
| Content | Text or characters | Numbers and other numerical data types | Expressions |
| Begins with | No fixed symbol | No fixed symbol | Equal sign (=) |
| Used in calculations | Not normally | Yes | Yes |
| Default alignment | Left | Right | Right (result) |
4. Practical Applications
Different types of cell contents work together to create useful worksheets.
Example: Monthly Expense Worksheet| Expense | Amount (Rs.) |
|---|---|
| Electricity | 4,500 |
| Water | 1,200 |
| Internet | 3,000 |
| Total | =SUM(B2:B4) |
In this worksheet:
- Expense names are labels.
- Expense amounts are values.
- The total calculation is a formula.
The formula automatically calculates the total expenses. If an expense amount changes, the calculated total updates automatically.
This demonstrates how labels, values and formulas work together in a spreadsheet.
5. Important Examination Points
Key Idea 1: The three main types of cell contents are labels, values and formulas.
Key Idea 2: A formula always starts with an equal sign (=), and its calculated result is displayed in the cell.
Key Idea 3: Labels are left-aligned by default, while numerical values and formula results are right-aligned by default.
Quick Revision
- A label describes or identifies information.
- A value represents numerical data that can be used in calculations.
- A formula performs calculations using numbers, cell references and functions.
- Dates, times and currency values can be entered into worksheets.
=A1+B1is an example of a formula.=SUM(A1:A5)is an example of a formula using a function.- Default alignment can be changed using formatting tools.
Summary
Entering data into a worksheet involves adding labels, values and formulas to individual cells. Labels help identify information, values represent numerical data, and formulas perform calculations automatically.
Understanding these three types of cell contents and their default alignment helps students create organised, accurate and useful spreadsheets using applications such as Microsoft Excel and LibreOffice Calc.