116937 Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets

---

A spreadsheet is a digital tool that organizes data into rows and columns, allowing users to store, sort, and analyze information easily. Spreadsheets automate repetitive calculations using formulas and functions.

• Track payments and budgets
• Link related data across sheets
• Create charts/graphs for visualization
• Store and sort data efficiently
• Automate math calculations with formula

4. Spreadsheet Properties/Components

• Ribbon: Toolbar with commands
• Sheet: The workspace/grid
• Rows: Horizontal lines (e.g., 1, 2, 3…)
• Columns: Vertical lines (e.g., A, B, C…)
• Cells: Intersection of a row and a column (e.g., A1)
• Cell Range: A group of cells (e.g., A1:C4)
• Cell Cursor: The currently selected cell

6. Use Formulas

Create at least 8 rows and 5 columns of mixed data (text, numbers, dates)

Basic Formulas: 

• Addition: =A1+B1

• Subtraction: =A1-B1

• Multiplication: =A1*B1

• Division: =A1/B1

• SUM: =SUM(A1:A4)
   

  Need help understanding Excel formulas and functions?
  Click Here to learn more.

7. Types of Cells

• Label Cell: Contains text (e.g., “Name”)

• Data Cell: Contains numbers or dates

• Formula Cell: Contains formulas (e.g., =SUM(B1:B5))

8. Audit Formulas (Error Checking)

• Show formulas: Formulas → Show Formulas

• Excel will highlight errors like #DIV/0! or #VALUE!

9. Save in Different Formats

• File → Save As

• Choose format:

  • Excel: .xlsx

  • CSV: .csv

  • Text: .txt

  • HTML: .html

  • Template: .xltx

✂️ 10. Edit a Spreadsheet

Select & Deselect Cells

• Single Cell: Click once

• Range: Click and drag

• Entire Column: Click column letter

• Entire Row: Click row number

• Entire Sheet: Click triangle at top-left

Manipulate Cells

• Move: Cut (Ctrl+X), Paste (Ctrl+V)

• Copy: Ctrl+C

• Delete: Right-click → Delete

• Auto Fill: Drag the bottom-right corner of a cell (fill handle)

11. Find and Replace Text

• Ctrl+F = Find

• Ctrl+H = Find and Replace

12. Format a Spreadsheet

Cell Style

• Change Text (General, Number, Currency, %, Date)

• Font Type/Size/Color

• Bold, Italic, Underline, etc.

• Strikethrough, Superscript, Subscript

Alignment

• Horizontal: Left, Center, Right

• Vertical: Top, Middle, Bottom

• Text Direction: Rotate or angle text

Background Colour

• Right-click cell → Format → Fill → Choose colour

Row & Column Formatting

• Row Height: Right-click → Row Height

• AutoFit Row: Double-click bottom row border

• Column Width: Right-click → Column Width

• AutoFit Column: Double-click right column border

13. Spelling & Grammar

• Check Spelling: Review → Spelling

• AutoCorrect: Common typos fixed automatically

• Add custom words to dictionary

14. Print a Spreadsheet

• Gridlines: File → Print → Page Setup → Sheet → Gridlines

• Row/Column Headings: Same as above

• Repeat Rows: Page Layout → Print Titles → Rows to repeat

• Print Options:

  • Entire Workbook

  • Active Sheet

  • Selected Are