Practice: Real Workplace Scenarios
Let's put everything together with hands-on exercises based on real workplace situations. Complete these to solidify your AI + Google Workspace skills.
Exercise 1: Sales Report Formula
Your manager asks for a quick sales breakdown. Write a prompt to get the formula.
Exercise 2: Data Cleanup
You received a messy contact list. Write a prompt to clean it up.
Exercise 3: Document Summary
You need to summarize a long report for your team. Write the prompt.
Quick Reference Card
Save this template for your daily Google Workspace AI interactions:
FOR FORMULAS:
My Google Sheet structure:
- Column A: [description]
- Column B: [description]
Data range: Rows 2 to [X]
Goal: [What to calculate/find?]
Please give me a Google Sheets formula for cell [X].
FOR DATA CLEANUP:
Column [X] has messy data. Examples:
- '[example 1]'
- '[example 2]'
Desired format: [describe clean format]
Give me an ARRAYFORMULA for the whole column.
FOR DOCUMENTS:
Summarize/Draft [type of document]
Audience: [who will read it]
Format: [bullets, paragraphs, sections]
Tone: [formal, casual, technical]
Length: [word count or page limit]
Congratulations!
You've completed the AI for Google Sheets & Docs course. You now know how to:
- Get AI to write Google Sheets formulas from plain English
- Clean and standardize messy data with AI-generated formulas
- Draft and summarize documents in Google Docs
- Automate repetitive categorization and formatting tasks
- Use Google's built-in AI features and add-ons
Next step: Open your most-used Google Sheet and try asking AI to automate one task you've been doing manually.

اسأل Byte عن هذا الدرس
محادثة خاصة حول هذا الدرس. قرأ Byte الدرس كاملًا، ويجيب خلال ثوانٍ، ويُظهر القسم الذي تأتي منه كل إجابة. يمكنك السؤال بأي لغة.
الأسئلة والأجوبة
أسئلة عامة حول هذا الدرس. يجيب AI Tutor فورًا بلغتك، ويراجع فريق FreeAcademy الإجابات، ويمكن لكل المتعلمين قراءتها.

