Mholo Tecnobits! Ndiyathemba ukuba akhanya ngokuqaqamba njengamagama abhalwe ngqindilili kumashidi kaGoogle. Umbuliso omnandi kunye noyilo kuwe!
Ungawaqaqambisa njani amagama kwiishiti zikaGoogle?
- Vula iiGoogle Sheets kwisiphequluli sakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama.
- Cofa ku "Fomatha" 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 iiGoogle Sheets kwisiphequluli sakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama.
- Cofa ku "Fomatha" kwibar yemenyu.
- Khetha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa amagama.
- Ungaphinda 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.
- Toca el icono de menú en la esquina superior derecha de la pantalla.
- 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 iiGoogle Sheets kwisiphequluli sakho.
- Khetha iseli apho ufuna ukusebenzisa ifomula okanye imeko.
- Chwetheza ifomyula okanye imeko kwibha yefomula yeseli kwaye ucinezele "Ngena."
- Por ejemplo, para 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 iiGoogle Sheets kwisiphequluli sakho.
- Khetha iseli okanye uluhlu lweeseli eziphawule amagama ofuna ukuwasusa.
- Cofa ku "Fomatha" 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 iiGoogle Sheets kwisiphequluli sakho.
- Khetha iseli okanye uluhlu lweeseli ezinamagama agqanyisiweyo ofuna ukuwahlela.
- Cofa ku "Fomatha" 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.
- Khumbula oko ungasusa ukhanyiso nangaliphi na ixesha ngokulandela amanyathelo okususa ukuqaqambisa igama kumashidi kaGoogle.
Ngaba kuyenzeka ukuqaqambisa amagama kwiiShithi zikaGoogle ngokufomatha okubhaliweyo okongeziweyo?
- Vula iiGoogle Sheets kwisiphequluli sakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama.
- Cofa ku "Fomatha" kwibar yemenyu.
- Khetha "iFomati yokubhaliweyo" kwaye ukhethe ukhetho olufunekayo, olufana nesibindi, akekeleyo, krwela umgca, njl.
- Ungaphinda dibanisa ukuqaqambisa igama kunye nolungiselelo lokubhaliweyo olongezelelweyo ukugxininisa ngakumbi kumagama agxininisiweyo.
Ndingawaqaqambisa njani amagama kwiishiti zikaGoogle ukucwangcisa ulwazi lwam ngokubonakalayo?
- Vula iiGoogle Sheets kwisiphequluli sakho.
- Khetha iseli okanye uluhlu lweeseli apho ufuna ukuqaqambisa amagama ukucwangcisa ulwazi ngokubonakalayo.
- Cofa ku "Fomatha" 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 iiGoogle Sheets kwisiphequluli sakho.
- Khetha ifayile equlathe amagama aphawuliweyo ofuna ukwabelana ngawo.
- Haz clic en el botón de «Compartir» en la esquina superior derecha de la pantalla.
- 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 iiGoogle Sheets kwisiphequluli sakho.
- 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.