Molo Tecnobits! Ndiyathemba ukuba akhanya ngokuqaqamba njengamagama abhalwe ngqindilili kumashidi kaGoogle. Umbuliso omnandi kunye noyilo kuwe!
Ungawaqaqambisa njani amagama kwiishiti zikaGoogle?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama.
- Cofa u-"Format" kwibar yemenyu.
- Khetha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa amagama.
- Ulungile! Ngoku amagama aya kuphawulwa kuMashidi kaGoogle.
Uwuhlengahlengisa njani umbala oqaqambileyo kunye nesimbo kuMashidi kaGoogle?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama.
- Cofa u-"Format" kwibar yemenyu.
- Khetha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa amagama.
- Unako kwakhona lungisa ukukhanya kombala okanye sebenzisa umbala oqhelekileyo usebenzisa "Eminye imibala" ukhetho.
- Ukongeza, kwi "Gcwalisa Umbala" ukhetho, unako kwakhona tshintsha isimbo sokuqaqambisa usebenzisa iipateni ezinjengemigca okanye iigridi.
Ngaba kuyenzeka ukuqaqambisa amagama kwiishiti zikaGoogle kwi-app yeselula?
- Vula i-app ye-Google Sheets kwisixhobo sakho esiphathwayo.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama.
- Cofa i icon yemenyu kwikona ephezulu ngasekunene kwesikrini.
- Khetha i "Format" kwimenyu eyehlayo.
- Thepha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa amagama.
- Ngoku amagama azakuphawulwa kuGoogle Sheets kwisixhobo sakho esiphathwayo!
Ngaba ndingagqamisa amagama athile kuMashidi kaGoogle ndisebenzisa iifomula okanye iimeko?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha iseli apho ufuna ukusebenzisa ifomula okanye imeko.
- Chwetheza ifomyula okanye imeko kwibha yefomula yeseli kwaye ucinezele "Ngena."
- Umzekelo, gxininisa amagama athile, ungasebenzisa umsebenzi we "CONDITION" kwaye usete iikhrayitheriya zokuqaqambisa kwifomula.
- Emva kokuba ifomula okanye imeko isetyenzisiwe, amagama aya kugxininiswa ngokuzenzekelayo ngokusekelwe kwiikhrayitheriya ezimiselweyo.
Ndingalususa njani uphawu lokuqaqambisa igama kwiishiti zikaGoogle?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha iseli okanye uluhlu lweeseli eziphawule amagama ofuna ukuwasusa.
- Cofa u-"Format" kwibar yemenyu.
- Khetha "Gcwalisa Umbala" kwaye ukhethe "Akukho Mbala" ukhetho lokususa imbalasane.
- Ngoku igama lokuqaqambisa liza kube lisusiwe kuMashidi kaGoogle!
Ngaba ndingahlela ukuqaqambisa igama xa sele lifakiwe kuMashidi kaGoogle?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha iseli okanye uluhlu lweeseli ezinamagama agqanyisiweyo ofuna ukuwahlela.
- Cofa u-"Format" kwibar yemenyu.
- Khetha "Gcwalisa Umbala" kwaye ukhethe "Imibala Engakumbi" ukhetho lokunyenyisa umbala oqaqambileyo kunye nesimbo.
- Ungatshintsha kwakhona umbala, ukukhanya, kunye nesimbo sokuqaqambisa nangaliphi na ixesha.
- Recuerda que ungasusa ukhanyiso nangaliphi na ixesha ngokulandela amanyathelo okususa ukuqaqambisa igama kumashidi kaGoogle.
Ngaba kuyenzeka ukuqaqambisa amagama kwiiShithi zikaGoogle ngokufomatha okubhaliweyo okongeziweyo?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama.
- Cofa u-"Format" kwibar yemenyu.
- Khetha "iFomati yokubhaliweyo" kwaye ukhethe ukhetho olufunekayo, olufana nesibindi, akekeleyo, krwela umgca, njl.
- Unako kwakhona dibanisa ukuqaqambisa igama kunye nolungiselelo lokubhaliweyo olongezelelweyo ukugxininisa ngakumbi kumagama agxininisiweyo.
Ndingawaqaqambisa njani amagama kwiishiti zikaGoogle ukucwangcisa ulwazi lwam ngokubonakalayo?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama ukucwangcisa ulwazi ngokubonakalayo.
- Cofa u-"Format" kwibar yemenyu.
- Khetha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa amagama.
- Ukuqaqambisa amagama kuya kukuvumela ukuba ulungelelanise kwaye uqaqambise ulwazi ngokubonakalayo kuMashidi kaGoogle.
Ndingabelana ngefayile ye-Google Sheets ngamagama aphawulweyo?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Khetha ifayile equlathe amagama aphawuliweyo ofuna ukwabelana ngawo.
- Cofa iqhosha elithi "Yabelana" kwikona ephezulu ngasekunene kwesikrini.
- Faka iidilesi ze-imeyile zabantu ofuna ukwabelana nabo ngefayile kwaye usete iimvume zofikelelo.
- Nje ukuba kwabelwane ngako, abantu owabelane nabo ngefayile baya kukwazi ukubona amagama agxininisiweyo kuMashidi kaGoogle.
Ngaba kukho naziphi na iiplagi okanye izongezo zokuqaqambisa amagama kuMashidi kaGoogle?
- Vula amaPhepha kaGoogle kwibhrawuza yakho.
- Cofa "Izongezo" kwibar yemenyu.
- Khetha i "Fumana ezongezo" kwimenyu eyehlayo.
- Jonga kwivenkile eyongeziweyo kuMashidi kaGoogle ukongezwa okukuvumela ukuba uqaqambise amagama ngendlela ephucukileyo.
- Ezinye iiplagi okanye izandiso zinokubonelela ngomsebenzi owongezelelweyo wokuqaqambisa amagama kuMashidi kaGoogle, njengokuqaqambisa okunemiqathango okanye ukuqaqambisa okuzenzekelayo.
Mandikubone emva kwexesha, Tecnobits! Hlala usebenza kwaye uyile njengokuqaqambisa amagama angqindilili kumashidi kaGoogle. Mandikubobe kwixesha elizayo!
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.