Google Docs aur Sheets (Saath milkar likho, Hisaab apne aap!)
Online copy aur online hisaab-kitaab ki register: dono ek hi Google Account mein 📝📊
🧭 Is Post Mein
📖 Kahani: Picnic Fund ka Galat Total aur “final_final2” File
Class 8B ki picnic tay hui! Class monitor Golu ko kaam mila: har dost se do hafte mein paise ikatthe karna aur hisaab rakhna. Golu ne copy ke ek panne par likha: Golu ₹50 + ₹50, Priya ₹50 + ₹40, Rohan ₹30 + ₹50, Simran ₹50 + ₹50… aur total nikala ₹360. 🤔
Teacher ne check kiya: “Golu, total toh ₹370 hona chahiye!” Ek jodne ki galti, aur poora hisaab kaat-kaat kar gandaa ho gaya.
Upar se, teacher ne picnic par ek report bhi maangi, jo Golu, Priya aur Rohan ko milkar likhni thi. Golu ne file banakar Rohan ko bheji, Rohan ne badlaav karke Priya ko bheji, Priya ne waapas Golu ko… Ab Golu ke paas teen files thi: report.docx, report_final.docx aur report_final_final2.docx. Kaunsi asli hai? Kisi ko nahi pata! 😵
Priya ne laptop khola: “Golu, hisaab Google Sheets mein daalo, total woh khud jodega, kabhi galti nahi karega. Aur report Google Docs mein likho: ek hi file, hum teeno ek saath apne-apne ghar se likh sakte hain!”
Rohan ne mobile uthaya: “Sach mein? Main yahan se type karunga aur tumhe wahan dikhega?” Golu ka sawaal: Sheets khud total kaise karta hai? Aur ek file mein teen log ek saath kaise likhte hain? Chaliye, aaj yahi seekhte hain. 📝📊
🎯 Is Post Mein Kya Seekhenge
- Word processor aur spreadsheet ka matlab
- Google Docs: document banana, formatting, table/image daalna, voice typing, comments, Suggesting mode, Version history, download
- Google Sheets: row, column, cell, cell address, range, formula bar, sheet tabs
- Formula aur function: =, +, −, *, / aur SUM, AVERAGE, MAX, MIN, COUNT; fill handle se formula copy karna; sort aur chart
- Collaboration: ek file par kai log ek saath, aur safe sharing ki aadatein
🧱 Basics: Pehle Yeh Aana Chahiye
1. Google Account aur Drive: Docs aur Sheets ki files aapke Google Drive mein save hoti hain. (Pichle posts: Google Kya Hai? aur Gmail aur Google Drive)
2. Share ke roles: Viewer (sirf dekhe), Commenter (dekhe + comment kare; Docs mein suggestion bhi de), Editor (badal bhi sake). Yeh Drive wale post mein padha tha; Docs aur Sheets mein bhi yahi chalte hain.
3. Maths ke chinh computer par: jodna +, ghatana − (keyboard par hyphen key), guna * (star, × nahi), bhaag / (slash, ÷ nahi). Average = sabka jod ÷ kitni cheezein.
4. Keyboard shortcut: do ya teen keys ek saath dabana, jaise Ctrl + C (copy), Ctrl + V (paste), Ctrl + Z (undo, pichla kaam waapas).
💡 Concept: Google Docs aur Google Sheets
🧾 Part 1: Word processor aur Spreadsheet kya hote hain?
Kyun do alag apps? Kyunki likhne ka kaam (shabd, paragraph) aur ginti ka kaam (numbers, formulas) alag tarah ke hain. Har kaam ke liye sahi auzaar: jaise kalam se likhte hain, calculator se jodte hain.
📝 Part 2: Google Docs
Google Docs Google ka free, online word processor hai. Ise kholne ke tareeke:
- Browser mein docs.google.com → Blank document (ya koi template).
- Shortcut address: browser mein docs.new likho, seedha naya document khulega.
- Google Drive mein + New → Google Docs.
- Mobile par Google Docs app.
• Editing: seedha badlaav.
• Suggesting: aapke badlaav sujhav ban jaate hain (rangeen, kate hue shabd). File ka maalik ya editor unhe Accept ✓ ya Reject ✗ karta hai.
• Viewing: sirf padhna, galti se kuch na badle.
Kyun? Teacher ya dost aapki report sudhaar sake, par aakhri faisla aapka rahe.
📊 Part 3: Google Sheets
Google Sheets Google ka free, online spreadsheet app hai. Kholne ke tareeke: sheets.google.com, shortcut address sheets.new, Drive mein + New → Google Sheets, ya mobile par Sheets app. Yeh bhi auto-save hota hai.
• Column: upar se neeche jaane wali khadi pankti. Pehchaan letters se: A, B, C … Z, phir AA, AB…
• Row: baayein se daayein jaane wali leti pankti. Pehchaan numbers se: 1, 2, 3…
• Cell: jahan ek column aur ek row milte hain, woh ek khaana. Har cell mein ek cheez likhte hain: naam, number, date.
• Cell address (cell reference): pehle column ka letter, phir row ka number. Column B aur row 3 ka cell = B3.
• Active cell: jis cell par abhi click kiya hai (neeli border wala).
• Range: cells ka ek samooh, colon (:) se likhte hain: B2:B5 matlab B2, B3, B4, B5.
• Sheet tabs: neeche Sheet1, Sheet2… Ek file (spreadsheet) mein kai sheets ho sakti hain, jaise ek register mein kai panne.
Kyun letter + number? Jaise cinema ki seat “D-12” se turant mil jaati hai, waise hi har cell ka ek pakka pata hota hai, taaki formula bata sake ki “kis khaane ka number lo”.
Jaise D2 mein likho =B2+C2 aur Enter dabao. D2 mein B2 aur C2 ka jod dikhega (formula upar formula bar mein dikhta hai).
Kyun “=” zaroori? = dekhkar hi Sheets samajhta hai ki “yeh hisaab hai, karke dikhao”. = ke bina B2+C2 sirf likhe hue shabd (text) maane jaayenge.
• =SUM(D2:D5): range ke saare numbers ka jod
• =AVERAGE(D2:D5): ausat (jod ÷ ginti)
• =MAX(D2:D5): sabse bada number
• =MIN(D2:D5): sabse chhota number
• =COUNT(D2:D5): kitne cells mein numbers hain
Kyun function? 100 bachchon ke marks jodne ke liye =B2+B3+B4+… 100 baar likhna thakaane wala hai. =SUM(B2:B101) ek line mein kaam kar deta hai.
🤝 Part 4: Collaboration (saath milkar kaam)
Docs aur Sheets dono mein upar daayein Share button hai. Kisi ko Editor bana do, toh woh usi waqt usi file mein kaam kar sakta hai. Har insaan ka alag rang ka cursor aur naam dikhta hai, aur upar unki photo/initial. Comments se baat-cheet, Suggesting se sujhav, aur Version history se pata ki kisne kya likha.
Kyun yeh “final_final2” waali problem khatam karta hai? Kyunki file ki ek hi copy hai, internet par. Sab usi ek copy ko kholte hain, toh “kaunsi file asli hai” ka sawaal hi nahi uthta.
🖼️ Diagrams: Picture se Samjho
🔐 Deep Concept: Formula “pata” yaad rakhta hai, number nahi
Golu ne D2 mein =B2+C2 likha. Ab usne D2 ke fill handle ko pakad kar D5 tak kheencha. Kya D3 mein bhi =B2+C2 aayega? Nahi! D3 mein apne aap =B3+C3, D4 mein =B4+C4, D5 mein =B5+C5 ban jaata hai.
✏️ Examples: Kya karoge? Kaunsa tool?
⚖️ Difference Table: Google Docs vs Google Sheets
| Baat | 📝 Google Docs | 📊 Google Sheets |
|---|---|---|
| Kis prakaar ka app | Word processor | Spreadsheet |
| Mukhya kaam | Likhna aur sajaana | Data rakhna aur hisaab |
| Chhoti ikai (unit) | Shabd, line, paragraph, page | Cell (row + column) |
| Calculation | Nahi hota (sirf likha hua) | Formulas aur functions se, apne aap |
| Khaas tools | Voice typing, Suggesting mode, spelling check, word count | SUM/AVERAGE, fill handle, sort, chart, freeze |
| Naya kholne ka shortcut address | docs.new | sheets.new |
| Microsoft wala saathi | MS Word (.docx) | MS Excel (.xlsx) |
| Udaharan | Application, essay, picnic report | Marks sheet, picnic fund, cricket scores |
| Dono mein same | Free, online, auto-save, Drive mein file, Share (Viewer/Commenter/Editor), comments, Version history, ek saath kai log | |
🚫 Misconceptions: Log aisa sochte hain… lekin
✓ Docs aur Sheets auto-save hain; Save button hota hi nahi.
✓ Formula = se shuru karna zaroori hai: =B2+C2. Warna woh sirf text hai.
✓ Pehle column letter, phir row number: B3.
✓ Sheets mein guna * aur bhaag / se: =B2*C2, =B2/C2.
✓ Sirf Editor seedha badal sakta hai. Viewer sirf dekhta hai; Commenter comment (aur Docs mein suggestion) de sakta hai, jo maalik ke Accept karne par hi lagta hai.
✓ Ctrl + Z (undo) ya Version history se waapas laa sakte ho.
✓ Naam, dates, checkbox, links sab rakh sakte ho; hisaab sirf numbers ka hota hai.
🔤 Key Terms (Exam mein English shabd hi likhna)
❓ FAQs
1. Kya Docs aur Sheets bina internet ke chal sakte hain?
Aam taur par inhe internet chahiye, kyunki file online hai. Lekin computer par Chrome browser mein offline access pehle se (internet rehte hue) on kar diya ho, toh bina internet bhi file khol kar likh sakte ho; internet aate hi badlaav sync ho jaate hain. Kyun pehle se? Kyunki offline kaam ke liye file ki copy pehle aapke device par aani zaroori hai.
2. Kya Google Docs mein MS Word ki file khul sakti hai?
Haan. .docx file Drive mein upload karke Docs mein khol aur edit kar sakte ho, aur File → Download se waapas .docx bana sakte ho. Isi tarah Sheets mein Excel (.xlsx) file. Kabhi-kabhi kuch fancy formatting thodi badal sakti hai.
3. Calculator se jodkar likh dun toh? Formula kyun?
Calculator se nikala number “mara hua” hai: data badla toh woh nahi badlega, aur aapko yaad bhi nahi rahega ki kaise nikla. Formula “zinda” hai: data badalte hi jawaab apne aap sahi ho jaata hai, aur formula bar mein dikhta hai ki hisaab kaise hua. Isse galti pakadna bhi aasaan hai.
4. Ek cell mein #NAME? ya #DIV/0! kyun aa jaata hai?
#NAME?: function ka naam galat likha, jaise =SUMM(B2:B5). #DIV/0!: kisi number ko 0 (ya khaali cell) se bhaag diya, jo maths mein sambhav nahi. #VALUE!: number ki jagah text se hisaab karne ki koshish, jaise “50 rs” + 40. Error bura nahi hai: woh Sheets ka ishaara hai ki “yahan dekho”.
5. Suggesting mode aur Comment mein kya fark hai?
Comment ek alag note hai, text nahi badalta. Suggesting mein aap text mein hi badlaav karte ho, par woh rangeen sujhav ki tarah dikhta hai; Accept karte hi asli ban jaata hai. Chhoti sudhaar (spelling, shabd) ke liye Suggesting, sawaal ya salah ke liye Comment.
6. Ek saath do log ek hi shabd badlein toh kya hoga?
Docs har insaan ke badlaav ko turant server par bhejta aur sabko dikhata hai, isliye dono ko ek doosre ka cursor dikhta hai aur takraav kam hota hai. Agar gadbad ho bhi jaaye, Version history se dekh kar theek kar sakte ho. Isliye group project mein pehle kaam baant lo: “Intro Golu, Kharcha Priya, Photos Rohan”.
🖱️ Hands-on: Docs mein Report, Sheets mein Hisaab (Click-by-click)
Note: yeh kaam parents ke saath, apne ya family ke Google Account se karein. Menus ki jagah kabhi-kabhi thodi badal sakti hai, par naam yahi rehte hain.
Part A: Google Docs mein picnic report
Kyun yeh kram? Pehle naam, phir likhna, phir sajaana, phir share: is tarah file Drive mein pehchaan mein aati hai aur doosron tak tabhi jaati hai jab taiyaar ho.
Part B: Google Sheets mein picnic fund
Kyun C4 badal kar dekha? Taaki aap khud dekh lo ki formula “zinda” hai: data badla, jawaab khud badla. Yahi spreadsheet ki asli taakat hai.
🧩 Try It Yourself
🛡️ Safety / Achhi Aadatein
🧠 Think Like a Programmer: “Total kabhi galat na ho” ka Algorithm
Programmer ki soch: badi problem → chhote steps → ek baar sahi formula → test se pakka karo → error ka matlab samajh kar theek karo.
🌍 Real Life Mein Docs aur Sheets
- 🏪 Mohalle ki dukaan: roz ki bikri aur udhaar ka hisaab Sheets mein; mahine ka total ek SUM se.
- 🏫 School: teachers marks sheet aur attendance Sheets mein, aur circulars/notices Docs mein banate hain.
- 🏏 Cricket club: har khiladi ke runs, ausat aur sabse zyada score: AVERAGE aur MAX ka kamaal.
- 🏠 Ghar ka budget: doodh, bijli, sabzi ka kharcha; mahine ke aakhir mein chart se pata ki paisa kahan zyada gaya.
- 📰 Office aur patrakaar: kai log ek hi report ek saath likhte aur Suggesting se sudhaarte hain.
- 💒 Shaadi ki taiyaari: mehmanon ki list aur kharcha, poori family ek hi shared sheet mein.
🔁 Recap: Poora Post Ek Nazar Mein
- Word processor = likhne ka software (Google Docs); spreadsheet = hisaab ka software (Google Sheets).
- Kholna: docs.google.com / docs.new, sheets.google.com / sheets.new, ya Drive → + New. Dono auto-save.
- Docs: formatting (Ctrl + B/I/U), Insert (image, table, link), Spelling and grammar, Word count (Ctrl + Shift + C), Voice typing (Ctrl + Shift + S), Comment (Ctrl + Alt + M).
- Docs ke modes: Editing, Suggesting, Viewing. Version history = time machine. File → Download se .docx / .pdf.
- Sheets: column = letter, row = number, cell address = B3, range = B2:B6, formula bar, sheet tabs.
- Formula = se shuru; + − * /. Functions: SUM, AVERAGE, MAX, MIN, COUNT.
- Fill handle se formula copy → pata apne aap badalta hai (relative reference); data badle toh jawaab khud badle.
- Errors: #NAME? (galat naam), #DIV/0! (0 se bhaag), #VALUE! (text se hisaab).
- Collaboration: Share (Viewer/Commenter/Editor), alag rang ke cursors, comments. Safe sharing, sign out, doosron ka kaam mat mitao.
✍️ Fill in the Blanks
- Spreadsheet mein columns ko ______ se pehchaana jaata hai.
- Sheets mein har formula ______ chinh se shuru hota hai.
- Column C aur row 7 ke cell ka address ______ hai.
- Docs mein text badle bina sujhav dene ke liye ______ mode hota hai.
- File ke purane roop dekhne aur restore karne ke liye ______ use hoti hai.
- Google Docs mein voice typing ka shortcut ______ hai.
Answers
1) letters (A, B, C…) · 2) = (barabar) · 3) C7 · 4) Suggesting · 5) Version history · 6) Ctrl + Shift + S
✅ True / False
- Google Docs mein kaam bachane ke liye har baar Save button dabana padta hai.
- Sheets mein rows numbers se pehchaani jaati hain.
- =SUM(A1:A3) teen cells A1, A2, A3 ke numbers jodta hai.
- Viewer role wala Google Doc mein badlaav kar sakta hai.
- D2 ka formula =B2+C2 fill handle se D3 tak kheenchne par D3 mein bhi =B2+C2 hi rahega.
- Google Docs ki file ko PDF ke roop mein download kiya ja sakta hai.
Answers (kyun ke saath)
1) False: Docs auto-save hai, har badlaav Drive mein apne aap save hota hai.
2) True: rows 1, 2, 3… aur columns A, B, C…
3) True: range A1:A3 mein yahi teen cells hain.
4) False: Viewer sirf dekh sakta hai; badlaav ke liye Editor chahiye.
5) False: relative reference ki wajah se D3 mein =B3+C3 ban jaata hai.
6) True: File → Download → PDF document.
🔘 MCQs
Q1. In mein se spreadsheet app kaunsa hai? (a) Google Docs (b) Google Sheets (c) Gmail (d) Google Meet
✅ (b) Google Sheets: rows-columns mein data aur hisaab.
(a) Docs word processor hai, likhne ke liye.
(c) Gmail email ke liye.
(d) Meet video call ke liye.
Q2. Column D aur row 4 ke cell ka sahi address? (a) 4D (b) D4 (c) D:4 (d) R4D
✅ (b) D4: pehle column letter, phir row number.
(a) Ulta kram, galat.
(c) Colon range ke liye hota hai (jaise D2:D4), ek cell ke liye nahi.
(d) Aisa koi pata Sheets mein nahi likhte.
Q3. B2 se B6 tak ke numbers jodne ka sahi formula? (a) SUM(B2:B6) (b) =SUM(B2:B6) (c) =ADD(B2-B6) (d) =TOTAL(B2:B6)
✅ (b) =SUM(B2:B6).
(a) = nahi hai, toh yeh sirf text ban jaayega.
(c) Sheets ka ADD function sirf do numbers jodta hai; aur B2-B6 ka matlab range nahi balki “B2 minus B6” hai, toh yeh error dega.
(d) TOTAL naam ka function Sheets mein nahi hai, #NAME? aayega.
Q4. B2:B6 mein runs 18, 20, 15, 17, 20 hain. =AVERAGE(B2:B6) kya dega? (a) 90 (b) 18 (c) 20 (d) 15
✅ (b) 18: jod 90 ÷ 5 = 18.
(a) 90 jod (SUM) hai, ausat nahi.
(c) 20 MAX hai.
(d) 15 MIN hai.
Q5. Google Docs mein voice typing kholne ka shortcut? (a) Ctrl + Shift + S (b) Ctrl + S (c) Ctrl + V (d) Ctrl + Shift + C
✅ (a) Ctrl + Shift + S.
(b) Ctrl + S save ka shortcut hai; Docs auto-save hai toh kuch khaas nahi karta.
(c) Ctrl + V paste hai.
(d) Ctrl + Shift + C word count kholta hai.
Q6. Kal mita hua paragraph waapas laane ke liye kaunsa feature? (a) Spelling and grammar (b) Version history (c) Word count (d) Voice typing
✅ (b) Version history: purana version Restore kar sakte hain.
(a) Sirf galtiyan pakadta hai.
(c) Sirf shabd ginta hai.
(d) Bolkar likhne ke liye hai.
Q7. Docs mein kis mode mein aapke badlaav rangeen sujhav bante hain jinhe maalik Accept/Reject karta hai? (a) Editing (b) Suggesting (c) Viewing (d) Printing
✅ (b) Suggesting.
(a) Editing mein badlaav seedha lag jaata hai.
(c) Viewing mein badlaav hota hi nahi.
(d) Printing koi mode nahi, kaagaz par nikalna hai.
Q8. Row aur column jahan milte hain, us khaane ko kya kehte hain? (a) Range (b) Cell (c) Sheet (d) Formula
✅ (b) Cell.
(a) Range kai cells ka samooh hai.
(c) Sheet poora panna (tab) hai.
(d) Formula hisaab ka hukum hai jo cell ke andar likhte hain.
🔗 Assertion–Reason
Options: (a) A aur R dono sahi, aur R, A ko samjhata hai · (b) A aur R dono sahi, par R, A ko nahi samjhata · (c) A sahi, R galat · (d) A galat, R sahi
1. A: Google Docs mein Save button dabane ki zaroorat nahi padti. R: Docs har badlaav apne aap Google Drive mein save karta rehta hai.
✅ (a): auto-save hi wajah hai ki Save button ki zaroorat nahi.
2. A: D2 ka =B2+C2 neeche kheenchne par D3 mein =B3+C3 ban jaata hai. R: Sheets mein har formula = se shuru hota hai.
✅ (b): dono sahi hain, par formula badalne ki wajah relative reference hai, = chinh nahi.
3. A: Cell address mein pehle row number, phir column letter likha jaata hai. R: Sheets mein columns letters se pehchaane jaate hain.
✅ (d): A galat hai (pehle column letter, jaise B3). R sahi hai.
📝 Very Short Answer (1 mark)
1. Google Docs kis prakaar ka software hai?
Online word processor.
2. Range A1:A4 mein kitne cells hain?
4 (A1, A2, A3, A4).
3. Sabse bada number dhoondhne wala Sheets function?
MAX
4. Naya Google Sheet turant kholne ka shortcut address?
sheets.new
5. Docs mein comment jodne ka shortcut?
Ctrl + Alt + M
📝 Short Answer (2–3 marks)
1. Word processor aur spreadsheet mein do antar likho.
(i) Word processor (Docs) likhne aur sajaane ke liye, spreadsheet (Sheets) data aur hisaab ke liye. (ii) Docs ki ikai shabd/paragraph hai, Sheets ki ikai cell hai. (iii) Sheets formulas se apne aap calculation karta hai, Docs nahi.
2. Formula aur function mein kya fark hai? Ek-ek udaharan do.
Formula = se shuru hone wala koi bhi hisaab ka hukum jo hum khud likhte hain, jaise =B2+C2. Function pehle se bana, naam wala formula hai, jaise =SUM(B2:B6) ya =AVERAGE(B2:B6). Har function formula ke andar use hota hai.
3. Suggesting mode kya hai aur kab kaam aata hai?
Docs ka woh mode jisme badlaav seedhe nahi lagte, rangeen sujhav ki tarah dikhte hain; file ka maalik/editor unhe Accept ya Reject karta hai. Kaam aata hai jab teacher ya dost aapke likhe mein sudhaar sujhayein par aakhri faisla aapka ho.
4. Version history ke do fayde likho.
(i) Galti se mitaaya ya badla hua kaam purana version Restore karke waapas laa sakte hain. (ii) Group project mein dikh jaata hai ki kisne kab kya likha, toh imaandari aur zimmedari bani rehti hai.
📝 Long Answer (5 marks)
1. Google Sheets ki banawat samjhao: row, column, cell, cell address, range, formula bar aur sheet tab, udaharan ke saath.
Sheets ek grid hai. Columns khadi panktiyan hain jinke naam letters A, B, C… hain; rows leti panktiyan hain jinke naam numbers 1, 2, 3… hain. Jahan column aur row milte hain woh cell hai, aur uska pata cell address = column letter + row number, jaise B3. Kai cells ka samooh range hai, jaise D2:D5 (D2, D3, D4, D5). Upar ki formula bar mein active cell ka asli content ya formula dikhta hai, jaise D6 mein =SUM(D2:D5) jabki cell mein 370 dikhta hai. Neeche sheet tabs (Sheet1, Sheet2) hote hain, ek file mein kai panne. Udaharan: picnic fund sheet mein A mein naam, B-C mein hafte ke paise, D mein total.
2. Google Docs mein collaboration (saath milkar kaam) ke features samjhao. Yeh email se file bhejne se behtar kyun hai?
(i) Share: kisi ko Viewer, Commenter ya Editor role dena. (ii) Real-time editing: kai log ek saath likhte hain, har ek ka alag rang ka cursor dikhta hai. (iii) Comments: text ke paas note, reply aur Resolve. (iv) Suggesting mode: badlaav sujhav ki tarah, maalik Accept/Reject kare. (v) Version history: kisne kab kya badla, aur purana version restore. Behtar kyun: file ki ek hi online copy hoti hai, toh “final_final2” jaisi kai copies ka jhagda nahi, sab hamesha latest version dekhte hain, aur auto-save se kaam kho nahi jaata.
📰 Case-Based Question
Padho: Simran ke papa ki kirana dukaan hai. Simran ne unke liye Google Sheets mein bill banaya: column A mein cheez, B mein matra (kg), C mein rate (₹ per kg), D mein amount. Row 2: Chawal, 5, 60 · Row 3: Daal, 2, 120 · Row 4: Cheeni, 3, 45. D5 mein usne kul amount nikala. Phir usne sheet papa ke accountant ke saath share ki, jo sirf dekh kar check karenge.
Q1. D2 mein amount nikalne ka formula kya hoga?
=B2*C2 (matra × rate; guna ke liye *). Jawaab 300.
Q2. D5 mein kul amount ka formula aur jawaab?
=SUM(D2:D4) = 300 + 240 + 135 = ₹675.
Q3. Cheeni ka rate ₹45 se ₹50 ho gaya. Simran ko kya-kya badalna padega?
Sirf C4 mein 50 likhna hai. D4 apne aap 150 aur D5 apne aap ₹690 ho jaayega, kyunki dono cells mein formule hain.
Q4. Accountant ko kaunsa role dena chahiye aur kyun?
Viewer: unhe sirf dekhna hai. Kam se kam zaroori access dena surakshit hai, taaki galti se bhi bill na badle. (Agar unhe galti batani ho toh Commenter.)
🚀 HOTS
1. Class ki marks sheet “Anyone with the link” ko Editor bana kar class ke WhatsApp group mein daal di gayi. Isme kya-kya khatre hain aur sahi tareeka kya hai?
Link aage forward hokar kisi bhi anjaan tak pahunch sakta hai; koi bhi marks badal ya mita sakta hai; bachchon ki niji jaankari sabko dikhegi. Sahi tareeka: sirf zaroori logon (teacher) ko email se Editor, baaki ko zarurat ho toh Viewer; aur personal data share hi na karna.
2. Golu ne D6 mein total haath se “370” type kiya. Baad mein Rohan ke paise badle par total nahi badla. Kyun? Kaise theek karein?
D6 mein formula nahi, sirf ek “mara hua” number tha, isliye Sheets ko pata hi nahi ki use D2:D5 se juda rehna hai. Fix: D6 mein =SUM(D2:D5) likho; ab koi bhi value badle, total khud sahi hoga.
3. Ek doc par 4 dost ek saath kaam kar rahe hain. Online collaboration ke do fayde aur do kamiyan socho.
Fayde: ek hi latest copy, kai versions ka jhanjhat nahi; har koi ghar baithe kaam kar sake aur Version history se zimmedari saaf. Kamiyan: achha internet chahiye (offline pehle se set na ho toh); galat share setting se privacy ka khatra, aur koi doosron ka likha mita sakta hai (isliye roles aur kaam ka bantwara zaroori).
🏆 Cyber Olympiad Corner
1. Google Sheets mein A1 = 10, A2 = 20, A3 = “abc” (text). =SUM(A1:A3) kya dega? (a) 30 (b) #VALUE! (c) 0 (d) #NAME?
✅ (a) 30: SUM range mein text wale cells ko chhod deta hai aur sirf numbers jodta hai. (b) #VALUE! tab aata hai jab =A1+A3 jaise seedhe jod mein text ho. (c) Numbers maujood hain, toh 0 nahi. (d) #NAME? galat function naam par aata hai.
2. =MAX(4,9,2)-MIN(4,9,2) ka jawaab? (a) 2 (b) 7 (c) 9 (d) 11
✅ (b) 7: MAX = 9, MIN = 2, 9 − 2 = 7. (a) 2 sirf MIN hai. (c) 9 sirf MAX hai. (d) 11 = 9 + 2, jod nahi karna tha.
3. Range B2:D5 mein kitne cells hain? (a) 8 (b) 9 (c) 12 (d) 15
✅ (c) 12: columns B, C, D = 3; rows 2, 3, 4, 5 = 4; 3 × 4 = 12. (a) 8 = 2 × 4 (ek column kam gina). (b) 9 = 3 × 3 (ek row kam gini). (d) 15 = 3 × 5 (row 1 bhi gin li).
📚 Aur Padho (External Reference)
- How to use Google Docs: Google Docs Editors Help (English)
- How to use Google Sheets: Google Docs Editors Help
- Google Sheets function list: SUM, AVERAGE, MAX, MIN aur bahut saare functions
- Type & edit with your voice: Docs mein voice typing
- Suggest edits in Google Docs: Suggesting mode
- Find what’s changed in a file: Version history
💖 CharuMam Motivation
Golu ki galti jodne mein nahi thi, galti yeh thi ki usne har baar sab kuch dobara haath se karne ka socha. Sheets ne sikhaya: ek baar sahi tareeka (formula) bana lo, phir woh hazaar baar sahi kaam karega.
Padhai mein bhi aisa hi hai, beta: ratne ki jagah concept samjho, woh “formula” ban jaata hai jo har naye sawaal par apne aap chal jaata hai. Aur Docs ne sikhaya ki milkar kaam karne mein taakat hai, bas doosron ke kaam ki izzat karo. Aaj aapne likhna aur ginna, dono digital tareeke se seekh liya! 📝📊🌱
— CharuMam
Saare chapters (Computer & AI) · Koi doubt? CharuMam AI Tutor mein 💻 Computer subject chuno aur poochho! 💬
Yeh content CharuMam ki original rachna hai. Bina permission copy, PDF ya re-upload karna mana hai.
charumam.com ek independent website hai; iska kisi publisher, Google, Adobe ya OpenAI se koi sambandh nahi hai. Products ke naam sirf samjhane ke liye liye gaye hain.
Share karna ho toh link share karein 🙏
Google, Gmail, Drive, Docs, Sheets, Slides, Forms, Calendar, Meet aur Maps Google LLC ke trademarks hain. CharuMam Google se affiliated nahi hai.
