Mholo Tecnobits! Ndiyathemba ukuba ukhazimle njengeseli egxininisiweyo kwi-Google Sheets Ngendlela, ukugqamisa iseli engqindilili kwi-Google Sheets, khetha ngokulula iseli, yiya kwibar yesixhobo, kwaye ucofe i-icon "B". Molweni!
1. Ndingayiqaqambisa njani iseli kwi-Google Sheets?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashithi kaGoogle.
- Khetha iseli ofuna ukuyiqaqambisa ngokucofa kuyo.
- Cofa kwi "Format" menu phezulu kwesikrini.
- Khetha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa iseli.
- Cofa kumbala owufunayo kwaye iseli iyakuphawulwa ngokuzenzekelayo ngombala okhethiweyo.
2. Ndingagqamisa iiseli ezininzi ngexesha elinye kuMashidi kaGoogle?
- Ngema kwiakhawunti yakho kaGoogle kunye ufikelele AMashidi kaGoogle.
- Bamba phantsi iqhosha elithi "Ctrl" kwikhibhodi yakho ukuba usebenzisa iPC, okanye "Yalela" ukuba ukuMac.
- Ngelixa ubambe isitshixo, cofa kwiiseli ofuna ukuziqaqambisa ukuze uzikhethe zonke ngaxeshanye.
- Cofa kwimenyu ethi "Format" phezulu kwesikrini.
- Khetha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa zonke iiseli ezikhethiweyo.
- Cofa kumbala owufunayo kwaye zonke iiseli ezikhethiweyo ziyakuphawulwa ngombala okhethiweyo.
3. Ngaba ndingaqaqambisa iiseli kuGoogle waMashidi ngokusekwe kwimeko?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashidi kaGoogle.
- Khetha iiseli ofuna ukufaka kuzo imeko.
- Cofa kwi "Format" menu phezulu kwesikrini.
- Khetha "iMithetho eneMiqathango" kwaye emva koko "Umgaqo omtsha oseti."
- Kwifestile evelayo, khetha uhlobo lwemeko oyifunayo, umzekelo, "Ukuba iyalingana" okanye "Ukuba inkulu kuno."
- Faka ixabiso elifunekayo kwaye ukhethe umbala ofuna ukuqaqambisa ngawo iiseli ezihlangabezana naloo meko.
- Cofa ku “Kwenziwe” kwaye iiseli ziya kuphawulwa ngokuzenzekelayo ngokusekelwe kwimeko yokumisela.
4. Ngaba kunokwenzeka ukugqamisa iseli kwi-Google Sheets usebenzisa iifomula?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashidi kaGoogle.
- Khetha iseli apho ufuna ukufaka khona ifomula.
- Chwetheza ifomula ofuna ukuyisebenzisa, umzekelo, =IF(A1>50;»Phakamisa»;»Sukuqaqambisa»).
- Ifomula iya kuvavanya imeko kwaye igxininise iseli ukuba idibene, ngaphandle koko ayiyi kuqaqambisa.
- Cinezela u-»Faka» kwikhibhodi yakho ukuze usebenzise ifomula kunye iseli izakuphawulwa ngokuzenzekelayo ngokwemeko esekwe kwifomula.
5. Ndingangayikhanyisi njani iseli kwi-Google Sheets?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuGoogle Sheets.
- Khetha iseli ofuna ukuyisusa uphawulo ngokucofa kuyo.
- Cofa kwimenyu ethi "Format" phezulu kwesikrini.
- Khetha "Gcwalisa Umbala" kwaye ukhethe "Transparent" ukhetho.
- Cofa ku "Transparent" kwaye iseli izakuphulukana nokuqaqambisa, ibuyela kumbala wayo wokuqala.
6. Ngaba kunokwenzeka ukugqamisa yonke imiqolo okanye iikholamu kwiiShedi zikaGoogle?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashidi kaGoogle.
- Khetha umqolo okanye ikholamu ofuna ukuyiqaqambisa ngokucofa inombolo yomqolo okanye unobumba wekholamu.
- Cofa kwi "Foomat" menu phezulu kwesikrini.
- Khetha "Gcwalisa Umbala" kwaye ukhethe umbala ofuna ukuwugqamisa wonke umqolo okhethiweyo okanye ikholamu.
- Cofa kumbala owufunayo kwaye umqolo okanye ikholamu iya kuphawulwa ngombala okhethiweyo.
7. Ndingasebenzisa ukufomatha okunemiqathango ukugqamisa iiseli kuMashidi kaGoogle?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashidi kaGoogle.
- Khetha iiseli ofuna ukuziqaqambisa ngokwemeko.
- Cofa kwimenyu ethi "Format" phezulu kwesikrini.
- Khetha u- "Conditional Formatting" kwaye ukhethe uhlobo lomgaqo ofuna ukuwusebenzisa, umzekelo, "Ukuba kuyalingana" okanye "Ukuba mkhulu kuno."
- Faka ixabiso elifunekayo kwaye ukhethe umbala ofuna ukuqaqambisa ngawo iiseli ezihlangabezana naloo meko.
- Cofa ku “Kwenziwe” kwaye iiseli ziya kuphawulwa ngokuzenzekelayo ngokusekelwe kwimeko yokumisela.
8. Ndingenza iindlela ezimfutshane zebhodi yezitshixo ukuqaqambisa iiseli kuMashidi kaGoogle?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashidi kaGoogle.
- Cofa kwimenyu ethi "Izixhobo" phezulu kwesikrini.
- Selecciona «Atajos de teclado».
- Kwifestile evelayo, fumana intshukumo ethi “Gcwalisa Umbala” kwaye unike isinqumli se-keyboard ukulungiselela wena.
- Gcina utshintsho kwaye ungasebenzisa indlela emfutshane yebhodi yezitshixo ukuqaqambisa iiseli kuMashidi kaGoogle.
9. Ngaba ndingayenza imibala ekhoyo yokuqaqambisa iiseli kuMashidi kaGoogle?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashidi kaGoogle.
- Cofa ku imenyu ethi “Fomatha” phezulu kwesikrini.
- Khetha "Gcwalisa Umbala" kwaye emva koko "Eminye Imibala."
- Kwiphalethi evelayo, unako khetha kwiintlobo ngeentlobo zemibala ukwenza ezo zikhoyo ziqaqambise iiseli kuMashidi kaGoogle.
10. Ngaba ndingathumela ngaphandle okanye ndiprinte i-spreadsheet sikaGoogle esineeseli eziphawulweyo?
- Ngema kwiakhawunti yakho kaGoogle kwaye ufikelele kuMashidi kaGoogle.
- Cofa kwimenyu ethi "Ifayile" phezulu kwesikrini.
- Khetha "Khuphela" kwaye ukhethe ifomathi ofuna ukuyithumela ngaphandle kwespredishithi, umzekelo, iPDF okanye i-Excel.
- Nje ukuba zithunyelwe ngaphandle, iiseli eziphawulweyo ziya kuhlala kuxwebhu lokugqibela.
- Ukuba ufuna ukuprinta i-spreadsheet, ngokulula cofa ku “Printa” kwaye iiseli ezikhankanyiweyo ziya kuprinta njengoko zibonwa kwiscreen.
Ndiza kubona kamva, bafana Tecnobits! Khumbula ukuba ukuqaqambisa iseli kuGoogle Sheets kulula njengokuyenza iqine. 👋🏼🔍 #GoogleSheets #Tecnobits
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.