📊 Lesson 2.2: Spreadsheets Basics

Spreadsheets Aren't Scary

A spreadsheet is a program that gives you a big grid — rows and columns of boxes — for organizing information and doing quick calculations on it. That's really all it is. If you've ever made a list on paper with columns (say, names down one side and amounts across the top), you've already made a spreadsheet by hand. The computer version just does the math for you, instantly and without errors, and lets you sort and rearrange in seconds.

Spreadsheets show up everywhere at work because they're so flexible. A few common uses:

• Budgets — listing income and expenses and totaling them up.
• Inventory — tracking how many of each item you have.
• Schedules — who works which shift, and how many hours.
• Tracking — sales, hours, mileage, attendance, tasks, or almost any list of numbers.

The two you'll most likely meet are Microsoft Excel and Google Sheets. They look very similar and work almost the same way — Google Sheets is free and runs in a web browser, while Excel is part of Microsoft Office. Learn the ideas here and you can use either one. If you're brand-new to using a computer at all, the Digital & Life Skills course covers device basics; this lesson assumes you're ready to build a work skill.

Rows, Columns & Cells

Every spreadsheet is built from the same three simple pieces. Once these click, the whole grid makes sense:

• Columns run up and down and are labeled with letters across the top: A, B, C, D, and so on.
• Rows run left to right and are labeled with numbers down the left side: 1, 2, 3, 4, and so on.
• A cell is a single box — the spot where a column and a row cross. Each cell has an address called a cell reference: the column letter plus the row number.

So the cell in column A, row 1 is called A1. The cell in column B, row 2 is B2. Column always comes first (the letter), then the row (the number). It works just like naming a square on a map or in the game of Battleship — "B2" points to exactly one box, and everyone reading the sheet knows which one you mean.

Here's a small grid described in words. Picture the column letters across the top and the row numbers down the side:

Reading that grid by cell reference: A1 holds the word Item, B1 holds Price, A2 holds Coffee, and B2 holds the number 3. The top row here is a header row — labels that tell you what each column contains. Everything below it is your data.

Two kinds of things go in cells:

• Text (also called labels) — words like Coffee or Item. Text usually lines up on the left and is not used in math.
• Numbers — like 3 or 2. Numbers usually line up on the right, and these are what formulas add, average, and calculate.

To put something in a cell, click the cell once to select it (a box highlights around it), type, and press Enter (or Tab to move to the next cell). To change a cell, click it and retype, or double-click to edit inside it. You can select a whole range at once by clicking one cell and dragging to another — that's how you'll point a formula at a group of numbers in the next section.

Simple Formulas

Here's the part that makes spreadsheets genuinely useful — and it's simpler than it looks. A formula is a little instruction that tells the spreadsheet to calculate something. The one rule to remember: every formula starts with an equals sign (=). That equals sign is how the spreadsheet knows "this is math, not just text."

You can do basic arithmetic by referring to cells. Say A1 holds 5 and B1 holds 3. Then:

The magic is that you refer to cells, not the numbers directly. Type the formula in an empty cell, press Enter, and the answer appears. Because the formula points at A1 and B1, it always uses whatever is currently in those cells.

Functions: shortcuts for common jobs

Typing =A1+A2+A3+A4 is fine for a few cells, but tedious for many. A function is a built-in shortcut. The two you'll use most:

• =SUM(...) — adds up a group of cells.
• =AVERAGE(...) — finds the average (the total divided by how many numbers).

Inside the parentheses you give a range — a start cell, a colon, and an end cell. A1:A5 means "cells A1 through A5" (A1, A2, A3, A4, and A5 — five cells). The colon (:) is read as "through."

Let's work a clean, checkable example. Suppose these four numbers are entered:

Now, in an empty cell, type these formulas:

• =SUM(A1:A4) → adds 10 + 20 + 30 + 40 = 100.
• =AVERAGE(A1:A4) → the total (100) divided by how many numbers (4) = 100 ÷ 4 = 25.

Both are worth double-checking by hand, which is a great habit: 10 + 20 = 30, plus 30 = 60, plus 40 = 100. ✔️ And 100 shared among 4 items is 25 each. ✔️ The spreadsheet does this in an instant, but knowing the answer should be about 100 helps you catch a mistake if you ever point a formula at the wrong range.

Sorting, Formatting & Reading Data

Once your data is in the grid, a few finishing skills make it clear and useful. Think of building any simple tracker — say, an expense log or a weekly hours sheet — as a short, repeatable flow:

graph TD
    A["Enter column headers (row 1)"] --> B["Type your data row by row"]
    B --> C["Format it (currency, bold headers)"]
    C --> D["Add a formula for totals (=SUM)"]
    D --> E["Sort or filter to find what you need"]
    E --> F["Read the table with confidence"]

Let's walk through the two new pieces in that flow — formatting and sorting — plus a word on reading a table.

Formatting: making numbers and headers clear

Formatting changes how a cell looks without changing the number inside it. Two everyday examples:

• Currency — turn a plain 5 into $5.00 so it's obviously money. Select the cells and choose the currency format (a $ button on the toolbar, or the Format menu). The underlying value is still 5, so formulas still work — it just displays as dollars.
• Bold headers — select your header row (row 1) and click Bold (or Ctrl+B / Cmd+B) so the labels stand out from the data below them. It's a small touch that makes a sheet far easier to read.

Sorting: putting rows in order

Sorting rearranges your rows into an order that helps you. Common choices:

• A–Z (or Z–A) to put text in alphabetical order — handy for names or item lists.
• Smallest to largest (or largest to smallest) to order numbers — for example, sort an expense list high to low to see your biggest costs at the top.

You'll find sorting under a Data menu (Data → Sort) in both Excel and Google Sheets. The important habit: sort by the right column, and make sure you include all the columns so each row stays together — you don't want to scramble which price belongs to which item. (When in doubt, undo and try again.)

Reading a table

Reading a spreadsheet is a skill in itself, and it's mostly about the header row. To find any value, match a column header (what kind of information) with the row (which item). In the small expense sheet below, to answer "how much was gas?" you find the Gas row, then read across to the Amount column: $30.00.

That Total row is a perfect job for a formula: =SUM of the three amounts. Checking by hand: 45 + 30 + 25 = 100. ✔️ If you later change the Gas amount, the total updates itself — exactly the automatic-recalculation superpower from the last section.

A Real Everyday Use

Let's put it all together with the kind of small, genuinely useful sheet you might build at work or home. Imagine tracking your weekly hours across five workdays. You'd type a header row, enter each day's hours, and let a formula total them:

If Hours sits in column B with the days in rows 2 through 6, the total is =SUM(B2:B6). Checking by hand: 8 + 7 + 8 + 6 + 5 = 34. ✔️ Want the average shift length too? =AVERAGE(B2:B6) gives 34 ÷ 5 = 6.8 hours. If you correct Wednesday from 8 to 9, both the total (35) and the average (7) update on their own.

Practice & Project

Tips & Common Mix-Ups

✅ Do's

• Start every formula with =. That's how the sheet knows to calculate.
• Point formulas at cells, not typed-in numbers, so totals update themselves.
• Use headers in row 1 and keep one record per row below.
• Double-check your range. =SUM(A1:A5) covers five cells — make sure that's what you meant.
• Sanity-check the answer. Add the numbers roughly in your head to catch a wrong range.
• Explore fearlessly. You can't break it; Ctrl+Z / Cmd+Z undoes most things.

❌ Common Mix-Ups

📓 Learning Journal

📝 Lesson Summary

🎉 What You've Accomplished

You demystified one of the most valued office skills. You can read the grid and name any cell, enter text and numbers, write real formulas with =SUM and =AVERAGE, and format and sort a table so it makes sense at a glance. Best of all, you built a real tracker on an actual computer and watched a total update itself. That's a "My First Spreadsheet" page you should be proud of. 🎉

❓ Common Questions at This Stage

🔭 Looking Ahead

You can now organize and calculate data — a powerful, portable skill. Next we round out the office-software module. In Lesson 2.3: Presentations & Cloud Collaboration, you'll build a clear slide presentation and learn how the cloud lets teams share and edit the same file together — so your documents and spreadsheets aren't just saved, but shared and worked on with others.

✅ Before the Next Lesson

• Finish your "My First Spreadsheet" toolkit page, and keep the real tracker you built.
• Practice: make one more small sheet (a mini-budget or a hours log) with a working =SUM total.
• Try =AVERAGE on your numbers and confirm the answer makes sense.
• Write your Learning Journal entry for this lesson.
• Optional: if you don't have a free spreadsheet yet, note that Google Sheets (sheets.google.com) works in a browser — a library can help you get started.