
What is a Spreadsheet?
- A spreadsheet is a digital tool used to organize, analyze, and manipulate data.
- It consists of rows and columns, intersecting at points called cells.
- Each cell can hold text, numbers, dates, or formulas.
Parts of a Spreadsheet
- Worksheet: A single sheet within a spreadsheet.
- Workbook: A collection of worksheets.
- Cell Reference: The address of a cell, specified by its column letter and row number (e.g., A1).
- Cell Range: A group of cells, indicated by the starting and ending cell references (e.g., A1:B5).
Basic Data Types
- Text: Any combination of letters, numbers, and symbols.
- Numbers: Numerical values used for calculations.
- Dates: Represent specific points in time.
- Formulas: Perform calculations or manipulate data.
Entering Data
- Click on a cell to make it active.
- Type the desired data into the cell.
- Press Enter or Tab to move to the next cell.
Formatting Cells
- Select the desired cells.
- Use the formatting toolbar to change font, size, color, alignment, and number format.
- Apply conditional formatting to highlight cells based on specific criteria.
Autofill
- Enter data in a few cells.
- Select the range of cells.
- Drag the small square at the bottom right corner of the selection to autofill.
Navigating the Spreadsheet
- Use the scroll bars to move vertically and horizontally.
- Click on sheet tabs to switch between worksheets.
- Use keyboard shortcuts (Ctrl+Tab, Ctrl+Shift+Tab) to navigate between sheets.
Saving and Sharing
- Click “File” -> “Save” to save the spreadsheet.
- Use the “Share” button to grant access to others.
Undo and Redo
- Use Ctrl+Z to undo the last action.
- Use Ctrl+Y or Ctrl+Shift+Z to redo the last undone action.
Introduction to Google Sheets Video Example