Be able to enter and modify text and numbers with total accuracy
13 Layout – Entering & Modifying Text & Numbers
📄 What you’ll learn: How to type, edit, and format text and numbers accurately in a spreadsheet, just like a digital notebook.
1️⃣ Entering Text
- Click a cell and start typing – the text appears immediately.
- Use Shift + Enter to move to the next cell down, or Tab to move right.
- To add a line break inside a cell, press Alt + Enter (Windows) or Option + Command + Enter (Mac).
🔍 Tip: Think of each cell as a Lego brick. You can stack bricks (text) one on top of another with Alt + Enter.
2️⃣ Modifying Text
- Select the cell, then type to replace the whole content.
- To change only part of the text, double‑click the cell or press F2 to edit in place.
- Use the Format Cells dialog (right‑click → Format Cells) to change font, size, colour, and alignment.
📝 Exam hint: When the question asks for “exactly” a word or phrase, double‑click to avoid accidental spaces or punctuation.
3️⃣ Entering Numbers
- Simply type the number – the spreadsheet recognises it automatically.
- Use the Number format drop‑down to set decimal places, currency symbols, or percentages.
- To force a number to be treated as text (e.g., a student ID), start the entry with an apostrophe: '12345.
🔢 Analogy: Numbers are like coins. Formatting decides whether you see them as dollars, euros, or just plain coins.
4️⃣ Using Functions for Numbers
Functions let you do quick calculations. Here are the basics:
| Function | Purpose | Example |
|---|---|---|
| =SUM(A1:A10) | Adds numbers in a range. | Adds all scores from A1 to A10. |
| =AVERAGE(B1:B5) | Finds the mean. | Calculates the average of five test scores. |
| =IF(C1>90,"A","B") | Conditional logic. | Gives an “A” if the score is above 90, otherwise “B”. |
📊 Exam tip: When a question asks for a total, use SUM rather than adding manually. It reduces errors.
5️⃣ Accuracy & Checking Work
- Always double‑check the range in a function – a missing cell can change the answer.
- Use Show Formulas (Ctrl + `) to see the underlying formula and spot mistakes.
- Apply Conditional Formatting to highlight values that are too high or too low.
- When entering long numbers, use the Number format with thousand separators (e.g., 1 234 567).
?? Exam check‑list:
- Did I use the correct function?
- Are all cell references absolute ($) or relative ( ) as required?
- Did I format numbers consistently (same decimal places, currency)?
- Have I verified the result with a quick manual calculation?
🧠 Remember: Accuracy in spreadsheets is like proofreading a story – a single misplaced comma or wrong cell reference can change the whole meaning.
Revision
Log in to practice.