Iyo chaiyo Hofisi package kubva kuGoogle, yakabatanidzwa mukuchengetedza kwavo kwegore, yakakurumbira pakati pevashandisi vaine maonero emahara uye kusununguka kwekushandiswa. Inosanganisira zvinyorwa zvewebhu zvakadai sekuratidzwa, mafomu, magwaro, matafura. About kushanda pamwe nekupedzisira, vese vari mubrowser paPC uye pane midziyo munharaunda, ichaudzwa munyaya ino.
Gadzirisa tambo muGoogle tafura
Mahwendefa eGoogle akanyanya kuderera kumhinduro yakafanana kubva kuMicrosoft - Iyo Excel tafura processor. Nekudaro, kuchengetedza mitsara mune iyo hofori yekutsvaga, iyo inogona kudikanwa kuti igadzire tafura kana header cap, inowanikwa chete imwe chete. Panguva imwecheteyo pane sarudzo mbiri dzekuita kwayo.Shanduro yeWEBS
Izvo zvinonyanya kuve nyore kushandisa Google matafura, kunyanya kana kushanda nebasa rewebhu kunoitwa kuburikidza neCompany Computer Computer - inokwana pamakomputa neWindows, Macos naLinux.
Sarudzo 1: Kugadzirisa mutsara mumwe
Vagadziri veGoogle vakaisa basa raunoda kanenge nzvimbo isingafungidzirwe, vamwe vashandisi vazhinji vanotarisana nematambudziko. Uye zvakadaro, kugadzirisa tambo iri patafura, ingangoita mashoma clicks.
- Uchishandisa mbeva, sarudza mutsara patafura yaunoda kugadzirisa. Panzvimbo pekusarudza bhuku, unogona kungotya pane iyo nhamba yayo yekutevera pane iyo cordinate panoronga.
- Pamusoro peiyo yepamusoro Navigation Panel, tsvaga iyo maonero tab. Kudzvanya pairi, mune yekudonha-pasi menyu, sarudza "Simbisa".
- MuSubmenu iyo inoratidzika, sarudza "Tambo 1".
Mutsetse waunosimbisa uchagadziriswa - kana uchipurudzira tafura, ichagara iri munzvimbo.
ONA: Nguva pfupi yadarika, iyo Maonero Tab inonzi "maonero", kuitira kuti iwe ugofanira kuvhura iyo yekuwana iyo menyu inofarira kwatiri.
Sezvauri kuona, hapana chakaomarara mukugadzirisa tambo imwe. Kana iwe uchifanira kuzviita nekukurumidza nemitsara yakatwasuka, verenga zvakare.
Sarudzo 2: Range Kugadziriswa
Kwete nguva dzose cap of the Spreadsheet inosanganisira mumwe chete mutsetse, panogona kunge paine maviri, matatu uye anopfuura. Uchishandisa webhu application kubva kuGoogle, iwe unogona kugadzirisa iyo isina muganho nhamba yemitsara ine chero data.
- Pane iyo yedhijitari inoronga pane iyo mbeva, sarudza iyo inodiwa mhando yemitsetse yaunoronga kushandura kune tafura yakasungirirwa patafura.
- Dzokorora matanho anotsanangurwa mune yakapfuura vhezheni: Dzvanya pane iyo maonero tab - "Simbisa".
- Sarudza "Mitsara yakawanda (n)", apo panzvimbo ye "n" mumabhureki icharatidza huwandu hweakateedzana iwe wakasarudza.
- Iwe wakasimbisa iyo yakatwasuka tabular renji ichagadziriswa.
Zano: Panzvimbo pekuratidza mbeva, unogona kungoita kuti uverengere kweiyo yekutanga mutsara kubva kuBhandi, uye wozobata iyo "Shift" kiyi yekhibhodi, tinya pane yekupedzisira nhamba. Iyo renji yaunoda ichabatwa.
Teerera kune iyo subparagraph "kumutsara uripo (n)" - Inokutendera kuti ugadzirise mitsara yese yematafura ayo iyo data iri, kusvika kune yekupedzisira isina chinhu (isina kubatanidzwa).
Aya ndiwo maitiro ekuti iwe ungagona kugadzirisa sei mitsara mishoma kana huwandu hwese hwakatwasuka muGoogle matafura.
Kuregedza mitsara patafura
Kana kudiwa kwekugadzirisa mitsara kuchanyangarika, ingo tinya pane iyo maonero tab, sarudza iyo "yekumira" chinhu, uye iyo yekutanga yerondedzero "isiri yekugadzirisa tambo". Iyo gadziriso yeiyo yaimbove yakazvipira mhando ichadzimwa.
Sarudzo 2: Row Range
Kubatanidzwa kwemitsara miviri kana anopfuura muGoogle matafura kunoitwa pane yakafanana algorithm sezviri mune imwe chete. Asi, zvakare, pano, kune mumwe pane imwe chete intuitive nuance, uye inosanganisira dambudziko rekupa mitsara miviri uye / kana kutsanangura huwandu - hazvigoneke kusvika pakarepo kunzwisisa kuti zvinofanirwa kuitwa sei.
- Kana mutsara mumwe watove wakamiswa, tinya pane yayo yekuteedzera nhamba. Chaizvoizvo, zvinodikanwa kudzvanya uye pasi pekushaikwa kwe cap mu tafura.
- Pangangoita nzvimbo yekusarudza ichinge yashanda, ndiko kuti, grame yebhuruu ine dombo dzinozoonekwa, dzinoburitsa kumusoro kusvika kune yekupedzisira mutsara, iyo ichazopinda renji yakatarwa (mune yedu muenzaniso ndeyechipiri).
ONA: Izvo zvinodikanwa kuti ubudise pane yebhuruu poindi iri mumaseru nzvimbo, uye kwete yedenderedzwa ine pointha pedyo neiyo nhamba yenhamba).
- Bata chigunwe chako pane yakasarudzwa nzvimbo, uye mushure memoyo menyu ichionekwa nemirairo, tora nzira nhatu.
- Sarudza iyo "yakachengeteka" sarudzo kubva pane rondedzero yezvinhu zviripo, uye simbisa zviito zvako nekudzvanya tick. Skira kuburikidza netafura uye uve nechokwadi chekuti mitsara iri kubudirira kusunga, uye saka kusikwa kwemusoro.
- Iyi nzira yakanaka mune iyo nyaya kana chaikodzera manhamba akati wandei ari padyo anodikanwa. Asi zvekuita kana huwandu hwakanyanyisa? Usadhonza chigunwe chako pamusoro petafura yese, kuyedza kuwana mutsara waunoda. Muchokwadi, zvese zviri nyore kwazvo.
- Izvo hazvina basa kuti une mitsara kana kwete, sarudza iyo imwe yadzo, iyo ichave yekupedzisira yeiyo yakanyorwa huwandu.
- Bata chigunwe chako pane imwe nzvimbo yekusarudza, uye mushure mevadiki menyu ichionekwa, tinya pane matatu mapoinzi emakiromita. Kubva pane yekudonha-pasi rondedzero, sarudza "mira".
- Mushure mekusimbisa kuitwa kwekuvhiya nekudzvanya chiratidzo cheki kubva kune yekutanga kune yekupedzisira yakanyorwa, iwe uchasungirirwa patafura musoro, waunogona kuve nechokwadi kuti chiri kutsemuka kubva kumusoro kusvika pasi, wobva wadzoka.
ONA: Kana mhando yemitsara yakatarwa yakawandisa, ichave ichiratidzwa zvishoma pachiratidziri. Izvi zvinodikanwa kuti kuve nyore kwekufamba uye kushandira pamwe chete netafura. Zvakananga cap mune iyi kesi inogona kuve yakakwenenzverwa mune chero yakanakira nzira.
Iye zvino iwe unoziva maitiro ekugadzira musoro muGoogle tafura, ichichengetedza imwe kana yakawanda mitsara uye kunyange huwandu hwavo hwakawanda. Izvo zvakaringana kuita izvi kashoma kashoma kurangarira kwete iyo inonyanya kuona uye inonzwisisika nzvimbo yezvinhu zvinodiwa menyu.
Kupatsanura tambo
Kanzura kusunganidzwa kwemitsara mufoni yeGoogle Google Tafura inogona kuve yakafanana nenzira yataita maitiro avo.
- Simbisa tambo yekutanga yetafura (kunyangwe iyo huwandu hwacho hwakatemerwa), kuteedzera pane yakati wandei.
- Bata chigunwe chako pane yakasarudzwa nzvimbo isati yasvika menyu pop-up. Dzvanya iyo mune matatu mapoinzi ematatu.
- Mune rondedzero yechiito chinyorwa, sarudza "wana", mushure meizvozvo kusunga kwetambo (s) mumatafura ichadzimwa.
Mhedziso
Kubva pachinyorwa ichi chidiki, iwe wakadzidza nezvekugadzirisa basa rakareruka sokugadzira cap nekugadzirisa mitsara muGoogle matafura. Pasinei nenyaya yekuti algorithm yekuita izvi maitiro mune yewebhu uye mobile application yakasiyana zvakanyanya, hausi kuidaidza chaizvo. Chinhu chikuru ndechekuyeuka nzvimbo yezvisarudzo zvinodiwa uye menyu zvinhu. Nenzira, nenzira imwecheteyo, unogona kusarudza iyo colums