Indlela yokusebenzisa imisebenzi kwiGoogle Sheets? I-Google Sheets sisixhobo se-spreadsheet se-intanethi esinika iindidi ngeendidi zeempawu zokubala, uhlalutyo lwedatha, kunye nokunye okuninzi. Le misebenzi ingasetyenziselwa ukwenza lula imisebenzi kunye neenkqubo ezizenzekelayo, ukugcina ixesha kunye nomgudu. Kweli nqaku, siza kukubonisa indlela yokufaka imisebenzi kuGoogle Sheets ngokulula nangempumelelo. Uya kufunda indlela yokusebenzisa iintlobo ezahlukeneyo zemisebenzi, indlela yokufaka iingxoxo eziyimfuneko, kunye nendlela yokwenza izibalo kwiiseli ezizimeleyo okanye kulo lonke uluhlu lwespredishithi. Kwaye, siza kukunika imizekelo esebenzayo ukuze uqalise ukusebenzisa ezi mpawu ngoko nangoko. Masiqale!
Inyathelo ngenyathelo ➡️ Uyenza njani imisebenzi kuGoogle Sheets?
Uyisebenzisa njani imisebenzi kuMashidi kaGoogle?
- Inyathelo lesi-1: Vula iPhepha zikaGoogle kwibhrawuza yakho.
- Inyathelo 2: Yenza i-spreadsheet esitsha okanye uvule esele ikhona.
- Inyathelo lesi-3: Khetha iseli ofuna ukufaka kuyo umsebenzi.
- Inyathelo lesi-4: Chwetheza uphawu olulinganayo (=) kwiseli ekhethiweyo.
- Inyathelo lesi-5: Okulandelayo, chwetheza igama lomsebenzi ofuna ukuwusebenzisa, ulandelwe yi-parenthesis yokuvula «(«.
- Inyathelo 6: Ngenisa iingxoxo zomsebenzi phakathi kwezibiyeli, zahlulwe ziikoma ukuba kuyimfuneko.
- Inyathelo lesi-7: Phelisa umsebenzi ngokuchwetheza i-parenthesis yokuvala »)» kwaye cinezela Ngena okanye Buyela.
- Inyathelo 8: Jonga iziphumo ze umsebenzi oza kuboniswa kwiseli ekhethiweyo.
- Inyathelo lesi-9: Ukufaka umsebenzi ofanayo ku a uluhlu lweeseli, khetha uluhlu olufunekayo kwaye wenze okufanayo amanyathelo ngasentla.
- Inyathelo lesi-10: Unokusebenzisa imisebenzi eyakhelwe-ngaphakathi ye AmaSpredishithi kaGoogle, njenge-SUM, i-AVERAGE, COUNT, MAX, MIN, njl.
- Inyathelo lesi-11: Ungasebenzisa kwakhona imisebenzi yesiko eyenziwe nguwe okanye ngu abanye abasebenzisi.
Imibuzo neempendulo
1. Yintoni imisebenzi kuGoogle Sheets kwaye isetyenziselwa ntoni?
Imisebenzi kuMashidi kaGoogle ziifomula ezichazwe kwangaphambili ezisivumela ukuba senze sibalwe kwaye sisebenzisane nedatha kwi-spreadsheet. Zisetyenziselwa ukwenza lula imisebenzi ephindaphindiweyo kwaye zenze imisebenzi enzima ngokuzenzekelayo.
- Imisebenzi in iGoogle Sheets ziifomula ezichazwe kwangaphambili.
- Zisetyenziselwa ukwenza izibalo kunye nokukhohlisa idatha kwi-spreadsheet.
- Benza lula imisebenzi ephindaphindiweyo kunye nemisebenzi enzima.
- Benza ngokuzenzekelayo inkqubo yokubala idatha kunye nohlalutyo.
2. Ndiwufaka njani umsebenzi kuMashidi kaGoogle?
Ukusebenzisa umsebenzi kuGoogle Sheets kulula kakhulu ngokulandela la manyathelo:
- Khetha iseli apho ufuna ukubonisa khona isiphumo somsebenzi.
- Chwetheza uphawu olulinganayo «=» lulandelwa ligama lomsebenzi.
- Yongeza iingxoxo eziyimfuneko okanye amaxabiso kwizibiyeli.
- Cofa u-Enter ukusebenzisa umsebenzi kwaye ufumane isiphumo.
3. Zeziphi ezinye iimpawu eziluncedo kuMashidi kaGoogle?
Amashidi kaGoogle abonelela ngezinto ezininzi ezahlukeneyo eziluncedo. Ezinye zezona ziqhelekileyo kwaye ziluncedo zezi:
- I-SUM: Bala isimbuku se uluhlu lweeseli.
- I-AVERAGE: Ibala umndilili woluhlu lweeseli.
- MAX: Ibuyisela elona xabiso likhulu loluhlu lweeseli.
- MIN: Ibuyisela elona xabiso lisezantsi loluhlu lweeseli.
- COUNT: Ibala inani zeeseli ezino ziqulatho kuluhlu.
4. Ndingenza njani ukukhangela kwaye ndifunde malunga nazo zonke iimpawu ezifumanekayo kuMashidi kaGoogle?
Ukufumana nokufunda malunga neempawu ezifumanekayo kuMashidi kaGoogle, landela la manyathelo:
- Cofa ithebhu ethi "Imisebenzi" phezulu kwi-spreadsheet.
- Kwibhokisi yokukhangela, chwetheza igama elingundoqo elinxulumene nefitsha oyikhangelayo.
- Khetha inqaku ofuna ukufunda ngakumbi ngalo.
- Funda inkcazo kunye nemizekelo yokusetyenziswa enikiweyo.
5. Kufuneka ndenze ntoni ukuba umsebenzi awusebenzi kakuhle?
Ukuba into ethile ayisebenzi kakuhle, landela la manyathelo ukuyilungisa:
- Qinisekisa ukuba iingxoxo zomsebenzi zifakwe ngokuchanekileyo.
- Qinisekisa ukuba usebenzisa ifomathi efanelekileyo ingeniso yamaxabiso.
- Khangela ukuba uluhlu lweeseli luyasebenza na.
- Ukuba umsebenzi usebenzisa iimbekiselo kwamanye amaphepha, qinisekisa ukuba igama lephepha lipelwe ngokuchanekileyo.
6. Ngaba ndingakwazi ukudibanisa imisebenzi kwi-Google Sheets?
Ewe, kunokwenzeka ukudibanisa imisebenzi kwi-Google Sheets ukwenza imisebenzi enzima ngakumbi. Landela la manyathelo ukudibanisa imisebenzi:
- Bhala umsebenzi wokuqala kwiseli oyifunayo njengesiqhelo.
- Endaweni yokongeza ixabiso okanye ingxoxo ngqo, sebenzisa omnye umsebenzi njengengxoxo.
- Qhubeka le nkqubo ukuba ufuna ukongeza ezinye iimpawu.
- Cofa u-Enter ukusebenzisa imisebenzi edibeneyo kwaye ufumane isiphumo sokugqibela.
7. Ndingakopa njani umsebenzi kwezinye iiseli ezikuGoogle Amaxwebhu?
Ukukopa umsebenzi kwezinye iiseli kuGoogle Sheets, landela la manyathelo:
- Khetha iseli enomsebenzi ofuna ukuwukopa.
- Cofa kwencinci isikwere kwikona esezantsi ekunene yeseli.
- Tsala isikwere phantsi okanye ekunene ukukopa umsebenzi kwiiseli ezimeleneyo.
- Khupha isikwere ukusebenzisa umsebenzi kwiiseli ezifunwayo.
8. Ngaba zikhona iindlela ezimfutshane zokufaka imisebenzi kwi-Google Sheets?
Ewe, iiSpredishithi zikaGoogle inika iindlela ezimfutshane zebhodi yokufaka imisebenzi ngokukhawuleza. Ezinye iindlela ezimfutshane eziqhelekileyo zezi:
- Ctrl + ;: Faka umhla wangoku.
- Ctrl + Shift + ;: Faka ixesha langoku.
- Ctrl + Shift + 1: Faka ukufomatha inombolo.
- Ctrl + Shift + 4: Faka ukufomatha kwemali.
- Ctrl + Shift + 7: Faka ipesenti yokufomatha.
9. Ndingawuhlela njani umsebenzi okhoyo kuMashithi kaGoogle?
Ukuba ufuna ukuhlela umsebenzi osele ukhona kuMashidi kaGoogle, landela la manyathelo:
- cofa iseli equlathe umsebenzi ofuna ukuwuhlela.
- Hlela umsebenzi ngokuthe ngqo kwibha yefomula phezulu kwi-spreadsheet.
- Yenza naluphi na utshintsho oluyimfuneko kwiingxoxo okanye kwisakhiwo somsebenzi.
- Cofa u-Enter ukusebenzisa utshintsho kwaye ufumane isiphumo esitsha.
10. Ndingawufumana njani kwaye nditshintshe umsebenzi kuMashidi kaGoogle?
Ukuba ufuna ukufumana kwaye utshintshe umsebenzi kumashidi kaGoogle, landela la manyathelo:
- Cofa Ctrl + H kwikhibhodi yakho ukuvula i-»Fumana kwaye ubuyisele» umsebenzi.
- Chwetheza igama lomsebenzi ofuna ukuwuphendla kwi- »Khangela» indawo.
- Chwetheza igama lomsebenzi ofuna ukuwubuyisela endaweni yawo kwi Buyisela ngommandla.
- Cofa u-"Buyisela Konke" ukutshintsha yonke imizekelo yomsebenzi kwi-spreadsheet.
NdinguSebastián Vidal, injineli yekhompyuter ethanda itekhnoloji kunye ne-DIY. Ngaphaya koko, ndingumdali we tecnobits.com, apho ndabelana ngee-tutorials ukwenza itekhnoloji ifikeleleke kwaye iqondeke kumntu wonke.