👋 Welcome to your first step into the world of Google Sheets!
If you’ve used Excel before, you’ll feel right at home. If not, no worries — this guide is designed for complete beginners 💡.

🖥️ 1. What is Google Sheets?

📌 Google Sheets is a free, cloud-based spreadsheet tool from Google. It allows you to:
✅ Store data online
✅ Collaborate in real-time
✅ Create charts & reports
✅ Automate tasks with formulas & scripts

🔗 Access here → Google Sheets

📝 2. Getting Started with the Interface

🎨 When you open Google Sheets, you’ll see:

🟩 Cells – Small boxes where you type data
🔠 Columns (A, B, C… ) – Vertical sections
🔢 Rows (1, 2, 3… ) – Horizontal sections
📊 Formula Bar – Where you write formulas

👉 Think of it as a big table where each box has a unique address (Example: B2 = Column B, Row 2).

🔤 3. Entering & Formatting Data

📥 Typing Data

Type numbers, text, or dates directly into cells.
Press Enter to move down, or Tab to move right.

🎨 Formatting Tricks

🖍️ Change text color, bold, italic → Toolbar buttons
🎯 Align text (left, center, right)
🟨 Highlight with background colors

👉 Try this: Type your name in a cell, make it bold + green, and center it!

➕ 4. Basic Formulas You Must Know

Formulas always start with =

📌 Examples:

➕ =SUM(A1:A5) → Adds numbers in cells A1 to A5
📊 =AVERAGE(B1:B10) → Finds average of numbers
🔍 =COUNT(C1:C20) → Counts how many cells have numbers
❓ =IF(D1>50,"Pass","Fail") → Checks condition

👉 Practice: Type numbers in column A and use =SUM(A1:A5)

🔎 5. Sorting & Filtering Data

📋 If you have a list (like names & marks), you can:

🔼 Sort A → Z (alphabetical or smallest to largest)
🔽 Sort Z → A (reverse order)
🎭 Use Filters to show only what you need (e.g., marks > 50)

👉 Example: Try making a list of friends’ names and ages, then sort by age.

📈 6. Creating Your First Chart

Data looks better when visualized 📊

Select your data range
Go to Insert → Chart
Choose chart type: Bar, Line, Pie

👉 Example: Enter sales data (Jan, Feb, Mar) and make a bar chart.

🌟 7. Practice Task for You

🧑‍💻 Create a small Student Marks Sheet:

Names in Column A
Marks in Column B
Use =AVERAGE(B1:B5) for class average
Highlight students who scored less than 40 in red (conditional formatting)
Create a bar chart of marks