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

---

Click to Go Back

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)

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

Click to Go Back