Mholo Tecnobits! Kuqhubekani? Ndiyathemba nibenosuku oluhle. Ngendlela, musa ukulibala sondeza kwi-Google Sheets ukuze amanani akho agqibelele. Molweni!
Yintoni i-Google Sheets kwaye isetyenziselwa ntoni?
- Bandakanya onke amagama aphambili e-SEO anokubakho anxulumene nesihloko: «Ungawaqokelela njani amaPhepha kaGoogle" kwisicatshulwa.
- AmaSpredishithi kaGoogle sisicelo se-spreadsheet esiphuhliswe ngu Uphando ekuvumela ukuba wenze, uhlele kwaye wabelane ngespreadsheets kwi-intanethi.
- Isetyenziselwa ukwenza izibalo, ukuhlalutya kunye nokubonwa kwedatha ngokubambisana nangexesha langempela.
- Sisixhobo esinamandla solawulo lwedatha kunye nokusebenzisana njengoko ivumela abasebenzisi abaninzi ukuba basebenze kwispredishithi esinye ngaxeshanye.
- Phakathi kwemisebenzi yayo kukukwazi ukwenza imisebenzi yezibalo entsonkothileyo, efana namanani ajikelezayo.
Uhlanganisa njani amaPhepha kaGoogle?
- Vula i-Google Sheets kwaye ukhethe iseli apho ufuna ukusondeza inani phezulu.
- Cofa ibha yefomula phezulu kwi-spreadsheet.
- Bhala ifomyula ehambelanayo ukusondeza inani. Sebenzisa umsebenzi weCEILING.
- Umzekelo, ukuba inani elimele ukwenziwa ngqukuva ngu-A1, chwetheza ifomula =CEILING(A1, 1) ukusondeza kwelona nani lilonke likufutshane.
- Cofa u-Enter ukusebenzisa ifomyula kwaye usondeze inani kwiseli ekhethiweyo.
Yintoni umahluko phakathi kokusondeza kunye nokuhla kuMashidi kaGoogle?
- Owona mahluko mkhulu phakathi kokusondeza kunye nokuhla ngaphakathi AmaSpredishithi kaGoogle ilele kwindlela inani lokugqibela eliqikelelwayo.
- Yisonge yonke ibandakanya ukufikelela kwinani elipheleleyo elilandelayo, ngelixa sondeza phantsi kuthetha ukusondela kwinani elipheleleyo langaphambili.
- Umzekelo, ukuba unenombolo engu-5.6 kwaye uyisondeze, isiphumo siya kuba ngu-6. Ukuba uyayisondeza, isiphumo siya kuba ngu-5.
- En AmaSpredishithi kaGoogle, ungasebenzisa imisebenzi ye-CEILING ukusondeza kunye noMPHANTSI ukusondeza phantsi.
Ngaba kuyenzeka ukusondezwa kuMashidi kaGoogle ngaphandle kokusebenzisa iifomula?
- Ewe, kuyenzeka ukusondezwa AmaSpredishithi kaGoogle ngaphandle kokusebenzisa iifomyula ngokusebenzisa ukhetho lokufomatha iseli.
- Khetha iseli equlathe inani ofuna ukulisondeza kwaye ucofe iqhosha lokufomatha kwibar yesixhobo.
- Khetha "Inombolo" ukhetho kwimenyu eyehlayo kwaye ukhethe ifomathi yenombolo oyifunayo.
- Cofa ukhetho lokusondeza kwaye emva koko "Faka" ukurhangqa inani leseli ekhethiweyo.
Ungasondezwa njani uluhlu lweeseli kuGoogle Sheets?
- Khetha uluhlu lweeseli ofuna ukusondeza kuzo AmaSpredishithi kaGoogle.
- Cofa ekunene kuluhlu olukhethiweyo kwaye ukhethe "Iiseli zokuFomatha" kwimenyu yomxholo.
- Kwifestile yefomathi yeseli, khetha ithebhu ethi "Inombolo" kwaye ukhethe ifomathi oyifunayo yokusondeza.
- Cofa u-"Faka" ukusondeza uluhlu lweeseli ezikhethiweyo kulo AmaSpredishithi kaGoogle.
Ngaba ndingakwazi ukuhlanganisa inani ngokwemiqathango kwi-Google Sheets?
- Ewe, kuyenzeka ukuba ujikeleze inani ngokwemiqathango AmaSpredishithi kaGoogle usebenzisa umsebenzi we-IF kunye nomsebenzi weCEILING.
- Bhala ifomyula yemiqathango usebenzisa umsebenzi we-IF ukuseta imeko kunye nomsebenzi weCEILING ukusondeza inani ngokusekelwe kwimeko.
- Umzekelo, ukuba ufuna ukusondeza inani ukuba likhulu kuno-10, ungabhala ifomula =IF(A1>10, CEILING(A1, 1), A1) ukuyisondezela ngokwemeko.
- Cofa u-Enter ukusebenzisa ifomyula enemiqathango kwaye ujikeleze ngokwemiqathango inani AmaSpredishithi kaGoogle.
Ngaba zikhona iindlela ezishunqulelayo zebhodibhodi zokusondezwa kuMashithi kaGoogle?
- Ewe, kukho iindlela ezimfutshane zebhodi yezitshixo onokuzisebenzisa ukurhangqa kuzo AmaSpredishithi kaGoogle.
- Bamba phantsi iqhosha le-Shift kwaye ucinezele iqhosha lotolo oluphezulu ukukhetha uluhlu lweeseli ofuna ukuzisondeza.
- Emva koko, cofa u-Ctrl + Shift + ukuze usebenzise ukufomatha okujikelezayo kuluhlu olukhethiweyo lweeseli.
- Sebenzisa iindlela ezimfutshane zebhodi yezitshixo ngaphakathi AmaSpredishithi kaGoogle inokukhawulezisa inkqubo yokusondeza kunye nokuphucula ukusebenza kakuhle xa usebenza ngeespredishithi.
Ngaba kuyenzeka ukusondeza amanani athabathayo kumaPhepha kaGoogle?
- Ewe, kuyenzeka ukurhangqa amanani athabathayo AmaSpredishithi kaGoogle usebenzisa umsebenzi weCEILING.
- Bhala ifomyula ehambelanayo ukusondeza inani elithabathayo usebenzisa umsebenzi weCEILING.
- Umzekelo, ukuba unenombolo -5.6 kwaye ufuna ukuyisonga, chwetheza ifomula =CEILING(-5.6, 1) ukufumana isiphumo sisondezwe.
- Cofa u-Enter ukusebenzisa ifomyula kwaye ujikeleze inani elithabathayo phezulu AmaSpredishithi kaGoogle.
Zeziphi iingenelo zokuhlanganisa kuGoogle amaPhepha?
- Sondeza ngaphakathi AmaSpredishithi kaGoogle kunokuba luncedo ekufumaneni iziphumo ezichane ngakumbi kubalo ezifuna ukusondezwa.
- Ivumela idatha ukuba iboniswe ngokucacileyo ngakumbi nangocwangco, ngakumbi kwiimeko apho amanani apheleleyo afunekayo afunekayo.
- Ukusondeza kunokunceda ukuphepha ukujongelwa phantsi kweziphumo kwaye uqinisekise ukuba izibalo zihambelana nohlalutyo lwakho lwedatha kunye neemfuno zokubonisa.
Ndingalufumana phi ulwazi oluthe kratya malunga nokurhangqa kuMashidi kaGoogle?
- Ungafumana ulwazi oluthe kratya malunga nokusondeza kwi AmaSpredishithi kaGoogle kwi Amaxwebhu AmaSpredishithi kaGoogle nakwiiforam zoncedo Uphando.
- Ukongeza, zininzi izifundo kunye neevidiyo kwi-intanethi ezibonelela ngeengcebiso kunye namaqhinga okufumana uninzi lwezinto ezijikelezayo kunye nezinye izixhobo zokubala AmaSpredishithi kaGoogle.
- Ukuphonononga izixhobo ezahlukeneyo ze-intanethi kunokukunika ukuqonda okunzulu kobuchule bokujikeleza AmaSpredishithi kaGoogle kunye nendlela yokuzisebenzisa ngokufanelekileyo kumsebenzi wakho ngeespredishithi.
Kude ibe lilixa elizayo! Tecnobits! Kwaye hlala ukhumbula indlela yokuhlanganisa kwi-Google Sheets ukuze ungaphulukani nesenti. Ndiza kubona kungekudala!
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.