01 ka-06
I-Google Spreadsheet Isinyathelo ngesinyathelo Isifundo se-Formula
I-Google Spreadsheet Tutorial Training - Uhlolojikelele
Lokhu kufundisa kuhlanganisa izinyathelo zokudala nokusebenzisa amafomula ku-Spreadsheet ye-Google Amadokhumenti. Kuhloswe kulabo abanokuhlangenwe nakho okuncane noma okungenalutho ekusebenzeni nezinhlelo zespredishithi .
Ifomu yeSpredishithi ye- Google Amadokhumenti ikuvumela ukuba wenze izibalo kudatha efakwe kuspredishithi.
Ungasebenzisa ifomula ye-crunching yenombolo eyisisekelo, njengokufaka noma ukususa, kanye nezibalo eziyinkimbinkimbi ezifana nokukhishwa kwe-payroll noma ukukala imiphumela yokuhlolwa komfundi.
Ngaphezu kwalokho, uma ushintsha idatha i -spreadsheet izophindaphinda ngokuzenzakalelayo impendulo ngaphandle kokufaka kabusha ifomula.
Ukulandela imiyalo yesinyathelo ngesinyathelo kumakhasi alandelayo kuhlanganisa indlela yokudala nokusebenzisa ifomula eyisisekelo ku-Google Doc Spreadsheet.
02 ka 06
Isitatimende se-Formula ye-Google Spreadsheet: Isinyathelo soku-1 se-3
Isitatimende se-Formula ye-Google Spreadsheet: Isinyathelo soku-1 se-3
Isibonelo esilandelayo sakha ifomula eyisisekelo. Izinyathelo ezisetshenziselwa ukwakha le fomula eyisisekelo zifanayo okumele zilandele uma ubhala amafomula amaningi ahlukene. Ifomula izofaka kuqala izinombolo 5 + 3 bese isusa 4. Ifomula yokugcina izobukeka kanje:
= A1 + A2 - A3
Isinyathelo 1: Ukufaka idatha
Qaphela : Ukuze uthole usizo ngalesi sifundo ubheke isithombe esingenhla.
Thayipha idatha elandelayo esitokisini esifanele.
A1: 3
A2: 2
A3: 4
03 ka 06
Isitatimende se-Formula ye-Google Spreadsheet: Isinyathelo sesi-2 se-3
Isitatimende se-Formula ye-Google Spreadsheet: Isinyathelo sesi-2 se-3
Lapho udala ifomula ku-Google Spreadsheet, UYAQALA ngokuqala ukuthayipha uphawu olulinganayo. Uthayipha esitokisini lapho ufuna impendulo ivele khona.
Qaphela : Ukuze uthole usizo ngalesi sibonelo ubheke isithombe esingenhla.
- Chofoza kuseli elingu-A4 (elichazwe emnyama esithombeni) nge-pointer yakho yegundane.
- Thayipha uphawu olulinganayo ( = ) esitokisini A4.
04 ka 06
Isitatimende se-Formula ye-Google Spreadsheet: Isinyathelo sesi-3 se-3
Isitatimende se-Formula ye-Google Spreadsheet: Isinyathelo sesi-3 se-3
Ukulandela isibonakaliso esilinganayo, sengeza ezinkombulweni zeseli zamaseli aqukethe idatha yethu.
Ngokusebenzisa izingcaphuno zeselula yedatha yethu kwifomula , ifomula izovuselela ngokuzenzakalelayo impendulo uma idatha kumaseli A1, A2, noma A3 ishintsha.
Indlela engcono kakhulu yokwengeza izingqikithi zeseli ngokusebenzisa isici se-Google Spreadsheets esibizwa ngokukhomba .
Ukukhomba kukuvumela ukuba uchofoze ngegundane lakho kuseli eliqukethe idatha yakho ukuze ungeze ireferensi yeseli yakho kwifomula.
Ngemuva kwesibonakaliso esilinganayo esenezwe isinyathelo 2
- Chofoza ku-cell A1 ngesinothi segundane ukufaka ireferensi yeseli kufomula.
- Thayipha uphawu lokuhlanganisa ( + ).
- Chofoza kuseli ye-A2 nge-pointer yegundane ukufaka ireferensi yeseli kufomula.
- Thayipha uphawu lokususa ( - ).
- Chofoza kuseli le-A3 nge-pointer yegundane ukufaka ireferensi yeseli kufomula.
- Cindezela inkinobho ENTER ekhibhodi.
- Impendulo 1 kufanele ivele esitokisini A4.
- Chofoza ku-cell A4. Ifomula ephelele = A1 + A2 - A3 iboniswa ebhasini lefomula ngaphezulu kwephepha lokusebenzela .
05 ka 06
Abasebenzisi beMathematika ku-Formula ye-Google Spreadsheet
Abasebenzisi beMathematika basebenzisa ifomula
Njengoba kuboniswe ezinyathelweni zangaphambilini, ukubhala ifomula ku-Google Spreadsheet akulula. Vele uhlanganise izingcaphuno zeselula zedatha yakho ne- opharetha efanele yezibalo .
Ama-opharetha wezibalo asetshenziselwa amafomu e-Excel afana nalawo asetshenziswe kwizigaba zezibalo.
- Ukususa - uphawu lokususa ( - )
- Ukwengeza - nesibonakaliso ( + )
- Isigaba - ukukhishwa phambili ( / )
- Ukuphindaphinda - i-asterisk ( * )
- I-Exponentiation - ukunakekelwa ( ^ )
06 ka-06
I-oda le-Google Spreadsheet ye-Operations
I-oda le-Google Spreadsheet ye-Operations
Uma ngabe opharetha abangaphezu kweyodwa asetshenziselwa ifomula , kunomyalelo othize we-Google Spreadsheet ozoyilandela ukwenza le misebenzi yembalo.
Le oda lomsebenzi lingashintshwa ngokufaka amabakaki ku-equation. Indlela elula yokukhumbula umyalelo wemisebenzi ukusebenzisa isichazamazwi:
BEDMAS
I-Order of Operations yilezi:
- Ama- racket B
E xponents
D ivision
Ukukhumbuza okuphezulu
I- ddition
S ukukhishwa
Indlela i-Order of Operations isebenza ngayo
Noma yikuphi ukusebenza (ama) okuqukethwe kubakaki kuzokwenziwa kuqala kulandelwa noma yikuphi okuvezwayo.
Emva kwalokho, i-Google Spreadsheet ibheka imisebenzi yokwahlukanisa noma yokubuyabuyelela ukuthi ibaluleke kakhulu, futhi yenza lokhu kusebenza ngendlela yokuthi ivele ngakwesokunxele kuya kwesokudla.
Okufanayo kuya emisebenzini emibili elandelayo - ukuhlanganisa nokususa. Babhekwa njengalingana ngokulandelana kwemisebenzi. Noma yikuphi okuvela kuqala ku-equation, noma ukufaka noma ukukhipha, umsebenzi owenziwe kuqala.