Recording and Checking Information in Google Sheets

Build a small practice register, calculate totals with formulas and sort records without separating related information.

Part 6 of 10 | Email and Google Workspace for Beginners

Learning goals

Enter structured information in cells, use a simple formula and verify its result independently. Sort a complete table while keeping each record together. Explain why filtering changes what is visible rather than deleting the underlying information.

Before you begin

Use fictional session-planning data and a restricted practice spreadsheet. No real participant names, contact details or payments are needed. The lesson teaches basic spreadsheet skills rather than accounting or tax treatment. Use English function names for the examples; locale settings may affect the display of dates, decimals and some formula separators.

Understand cells rows and columns

A cell is a position where a row and column meet. In A2, the letter identifies column A and the number identifies row 2. A range such as B2:B4 means the cells from B2 through B4. A clear table uses one row for each record and one column for each type of information, which makes sorting and checking easier.

Create a blank sheet through sheets.google.com and name it Practice_Session_Register. Use row 1 for headings: Group in A1, Planned in B1, Confirmed in C1 and Remaining in D1. Keep a heading in every used column. Avoid merged cells in this small data table, because separate cells make records easier to analyse and maintain.

Enter consistent fictional data

In row 2 enter Group A, 12 and 9 in columns A to C. In row 3 enter Group B, 8 and 6. In row 4 enter Group C, 10 and 10. These are invented seat-planning figures, not actual attendees. Check each entry against this lesson before adding calculations; a formula cannot know that you typed the wrong source number.

Keep numbers as numeric entries rather than typing explanatory words into the same cell. Put units or meaning in the heading or a nearby note. For dates in future work, choose a consistent unambiguous display and verify how the sheet interprets the entry. A value that looks like a date may otherwise be treated differently from what you intended.

Calculate rather than retype results

In D2 enter =B2-C2 and press Enter. It should show 3. Enter the corresponding formulas =B3-C3 in D3 and =B4-C4 in D4, producing 2 and 0. The equals sign tells Sheets to calculate the expression. References connect the result to the input cells so a later input change can update the calculation.

Below the table, use =SUM(B2:B4) to calculate 30 planned seats and =SUM(C2:C4) to calculate 25 confirmed seats. The remaining total is 5. Check these results independently by adding the three values yourself. A plausible-looking result is not sufficient; verify that the formula includes the correct cells and excludes the headings or total row.

Test a change and restore the example

Change Group A confirmed from 9 to 10. Its remaining value should change from 3 to 2 and the confirmed total from 25 to 26. This small test shows that the result depends on the input rather than being a manually typed answer. Restore the original 9 afterward so the final table matches the lesson's expected figures.

If a formula displays an error, inspect the formula bar, references and entered values. Do not replace an unexplained error with a guessed total merely to make the sheet look complete. A blank cell, text entry or incorrect range can produce an unexpected result. Record the cause and correction so you can recognise it in future work.

Keep records together when sorting

Select the entire data table, including every related column, and use the range-sorting controls under Data. Identify the header row so it remains a heading. Sort by Confirmed and inspect all three records afterward. Group A must remain associated with 12 planned and 9 confirmed, regardless of its row position.

Sorting only one column can detach numbers from their group names. Work on a copy for practice and compare each record before and after. Keep totals outside the sorted data range. If the file is shared, understand whether your action changes the view or data arrangement for other people before applying it.

Filter and review what is hidden

A filter can show only records matching a condition. It does not delete the other records. For a private practice copy, filter to show groups with confirmed numbers below 10, then remove the filter and verify that all three groups return. Remember that an ordinary SUM of the full range still includes values hidden by a filter.

Hidden rows are not a privacy control. Someone with suitable access may reveal them or otherwise access the information. Keep real private information out of the practice sheet and use file permissions for access decisions. Before presenting a result, state whether it covers all records or only a selected subset.

Guided exercise

1. Create the four-column register and enter the three fictional groups exactly as specified.

2. Add remaining-seat formulas and planned and confirmed totals. Verify 30 planned, 25 confirmed and 5 remaining independently.

3. Test the Group A change, observe recalculation and restore the original figure.

4. Sort a practice copy by Confirmed while keeping the full records together. Check all group-number associations.

5. Apply and remove a filter. Explain why hidden rows remain part of the underlying data and why the full-range SUM is unchanged.

Knowledge check

1. What does =B2-C2 calculate in this table?

2. Why is sorting only the Confirmed column risky?

3. Does filtering remove unwanted records permanently?

Answer guide

1. Planned minus confirmed seats for the first group, initially 3.

2. It can separate counts from their correct group names and other values.

3. No. Filtering changes visibility, and the data remains.

Completion standard

Provide the correct register, working formulas, independent arithmetic check and sort-and-filter observations. The final figures must return to 30 planned, 25 confirmed and 5 remaining. Each group must retain its correct data, and no hidden row should be described as securely removed.

Sources and verification notes

Add formulas and functions. Checked 15 September 2026. Official Sheets formula entry guidance. Examples use English function names and simple cell ranges.

Sort and filter your data. Checked 15 September 2026. Official sort and filter guidance. Keep complete rows together and distinguish filtering from deletion.