Wakambodhinda here spreadsheet, ndokugumburwa pairi mwedzi mishoma gare gare, kungoshamisika kuti spreadsheet yaive yei, ripi zuva rayakadhindwa, kana kuti ndeupi ruzivo rwaunofanira hanya nezvarwo? Izvi zvakajairika, kunyanya kana uchiwanzo dhinda shanduro dzakagadziridzwa dzespredishiti rimwechete.
Kushanda nemaspredishiti, ungave uchishandisa sarudzo yeGoogle Apps, Google Sheets, kana Microsoft Office sarudzo, Microsoft Excel, inowanzoita zvikamu zviviri. Chikamu chekutanga ndechekuita kuti data yose ipinde uye yakarongeka zvakanaka, uye chikamu chechipiri ndechekugadzirisa zvose zvingasarudzwa zvekugadzirisa peji kuitira kuti spreadsheet iite seyakanaka kana yakadhindwa.
Mafaira eGoogle Sheets ari nyore kudhinda nekusarudzika, asi ese maapplication anowanzo kuda kuti iwe uwedzere ruzivo kune zita kana kugadzirisa akasiyana sarudzo kuitira kuti kudhindwa kwe data kuve nyore kunzwisisa.
Imwe nzira yekugadzirisa dambudziko iri kushandisa zita refaira mumusoro. Izvi zvinowedzera ruzivo rwekuzivisa kune peji rega rega respredishiti kana iwo mapeji akapatsanurwa, nepo achipa ruzivo rwakakosha runogona kukubatsira kuziva chakadhindwa gare gare. Nhungamiro yedu pazasi inokuratidza maitiro ekuwedzera zita rebhuku rebasa kune zita muGoogle Sheets.
Maitiro ekudhinda zita rebhuku rebasa kumusoro kwepeji muGoogle Sheets
- Vhura faira respredishiti.
- Dzvanya tebhu faira .
- Tsvaga Dhinda .
- Sarudza tab Misoro nemavara .
- check box Musoro webhuku rebasa .
- Dzvanya inotevera Ipapo Dhinda .
Matanho ari pamusoro anofungidzira kuti watopinda muGoogle account iyo ine faira raunoda kuwedzera zita kwariri mumasetin'i ekudhinda.
Nhungamiro yedu pazasi inoenderera neruzivo rwakawanda nezvekuisa kero paGoogle spreadsheet, kusanganisira mifananidzo yematanho aya.
Maitiro ekuwedzera zita refaira kune peji paunenge uchidhinda muGoogle Sheets (Nhungamiro ine Mifananidzo)
Matanho ari muchinyorwa chino achakuratidza maitiro ekushandura marongero ebhuku rako rebasa reGoogle Sheets kuitira kuti zita rebhuku rebasa ridhindwe mumusoro, pamapeji ese espredishiti. Kuseta uku kunongoshanda kubhuku rebasa razvino, saka unozofanirwa kuita shanduko iyi pane mamwe maspredishiti aunoda kudhinda zita refaira.
Danho 1: Enda kuGoogle Drive on https://drive.google.com/drive/my-drive Vhura faira rine zita rebhuku rebasa raunoda kuwedzera kumusoro kwepeji paunenge uchidhinda.
Danho rechitatu: Dzvanya pane tab faira Pamusoro pehwindo.
Danho rechitatu: Sarudza sarudzo kudhinda pazasi pechinyorwa.
Danho rechishanu: Sarudza imwe sarudzo Misoro nemavara mumbiru kurutivi rworudyi rwehwindo.
Danho rechitatu: Sarudza sarudzo Musoro webhuku rebasa . Unogona kudzvanya bhatani " inotevera kumusoro kurudyi kwehwindo uye ramba uchidhinda spreadsheet.
Mutsetse wepamusoro wespredishiti unogona kunziwo mutsara wemusoro, saka unogona kunge uchinetseka kuti wozviita sei.
Ndinogona kudhinda kero mune mamwe maGoogle maapuro seGoogle Docs?
Kuwedzera ruzivo kune zita muGoogle Docs kwakasiyana zvishoma.
Sezvo iwe uchigona kugadzirisa musoro wakananga mugwaro reGoogle Docs, hauzowana mamwe ekuwedzera ekudhinda sarudzo dzemusoro uye tsoka dzawakawana muGoogle Sheets.
Kana iwe uchida kuwedzera zita rezita muGoogle Docs, unozofanirwa kudzvanya-kaviri mukati memusoro, wobva wanyora zita regwaro mumusoro. Ruzivo rwese rwaunowedzera kuzita regwaro ruchadzokororwa pamapeji ese akadhindwa egwaro.
Google Slides haina kana nzira yekuwedzera ruzivo kune musoro, saka nzira inoshanda kwazvo yekuita izvozvo ingangove yekuenda Slide> Rongedza dingindira Wobva wawedzera bhokisi remavara pamusoro peimwe marongero aripo kusanganisira zita remasiraidhi show. Iwe unogona ipapo kudzvanya pane inotsvedza uye wosarudza sarudzo Slide> Gadzirisa App Uye sarudza marongerwo ane musoro.
Maitiro ekuwedzera mutsara wemusoro muGoogle Sheets nekuisa mutsara usina chinhu kumusoro
Kana spreadsheet yako isati yatova nemutsara wemusoro kana mutsara wemusoro asi iwe uchida kuwedzera imwe kuitira kuti ugone kudzokorodza papeji rega rega, unogona kunge uchinetseka kuti wozviita sei.
Kana ukadzvanya mutsara 1 musoro kuruboshwe rwehwindo, mutsara wese wekutanga uchasarudzwa. Iwe unogona ipapo kudzvanya-kurudyi pamutsara wakasarudzwa uye sarudza iyo Isa 1 sarudzo pamusoro kuti uwedzere isina mutsara pamusoro peiyo iripo data.
Iwe unofanira kuzowedzera musoro wekoramu kune imwe neimwe sero mumutsara inotsanangura rudzi rwe data mukoramu iyoyo.
Iwe unogona ipapo kudzvanya iyo Tarisa tabhu kumusoro kwehwindo, sarudza iyo Freeze sarudzo, uye wobva wasarudza Freeze Yepamusoro Row kana chero imwe yeimwe mitsara sarudzo kubva painodonha menyu.
Dzidza zvakawanda nezvekuisa zita paGoogle spreadsheet
Matanho ari pamusoro anokuratidza maitiro ekuchinja marongero paunenge uchidhinda muGoogle Sheets kuitira kuti zita rebhuku rebasa ribatanidzwe mumusoro wepeji rega rega rakadhindwa.
Zvimwe zvezvimwe zvinhu zvaunogona kuita kuti Google iwedzere kukero zvinosanganisira:
- Nhamba dzepeji
- Musoro webhuku rebasa
- zita repepa
- nhasi date
- nguva ino
Musoro webhuku rebasa uye zita repepa rinogona kutaridzika zvakafanana, saka zvinobatsira kuziva kuti Google inosiyanisa sei pakati pavo.
Zita rebhuku rebasa refaira reGoogle Sheets ndiro zita rinobuda pamusoro pehwindo. Unogona kugadzirisa izvi chero nguva nekungodzvanya pairi uye nekuchichinja sezvinodiwa.
Zita reshizha ndiro zita rinoonekwa patebhu pazasi pehwindo. Iwe unogona zvakare kudzvanya pairi kuti uchinje.
Kana iwe wakagadzira girafu kana chati muGoogle Sheets, senge pie chati, saka wazviita nekusarudza mutsara wemaseru muspredishiti rako uye nekusarudza chimiro chechati chekugadzira kubva kune iyo data.
Kana iwe uchida kushandura zita rechati rakashandiswa neGoogle pachati iyi, unogona kudzvanya-kaviri zita racho, iro rinovhura iyo Chart Edhinda column kurudyi rwehwindo. Iwe unogona ipapo kusarudza zita rechati kubva pane yekudonhedza rondedzero uye woisa yako yaunofarira chati yeti mundima yezvinyorwa zvinyorwa.
