01 ye 01
Tsanangudzo yeSera uye Zvishandiso zvayo muExcel neGoogle Spreadsheets
Tsanangudzo
Sero ndiyo inonyanya kuchengetedza chikwata chinowanikwa muprogram yepaspiritsi yekare seExcel kana Google Spreadsheet. Dhiyabhorosi yakapinda muchirongwa chepasiteteti inogara yakachengetwa muchitokisi.
Pachikwereti, sero rinoratidzika sebhokisi-sechimiro uye rimwe nerimwe riri panopotanidza nzvimbo yemutsara wakavhara uye mutsara unopenya uri mune pepa rekushanda.
Nehurukuro dzinodarika 16,000 nemiromo inodarika mamiriyoni ega pepa pepaji , pane mabhiriyoni anopfuura mabhiriyoni 17 pamashizha ekuExpcel. Google Spreadsheet inenge iri duku kudarika 400 000 masero pamushandi webheji.
Zvishandiso
- Sezvakataurwa, masero anoshandiswa kuchengeta deta uye anoshandiswawo kuratidza data - kazhinji nemakoroni nemitsetse ye data yakabatana yakabatana pamwechete kuumba matafura.
- Mitsara inogona kuchengetedza maitiro mana ezvinyorwa zvemashoko (data types):
- Numeri - iyo inosanganisira maitiro, mazuva, uye nguva;
- Nyora zvinyorwa - zvinowanzozonzi seyimbo dzinyorwa kana zvingori;
- Boolean maitiro (dzimwe nguva anonzi maonero akanaka ) - Echokwadi kana FALSE chete;
- Kukanganisa mazano - akadai se #NULL !, #REF !, uye # DIV / 0! - izvo zvinobudiswa nepurogiramu iyo inosangana nechinetso ne data iri muchitokisi.
- Maseji ane mafomu ndiwo mwoyo wepurogiramu yepaspiritsi sezvo iri iyi kuverenga kunonyoresa kushanda nehuwandu hwemashoko. Kazhinji, masero anoratidza mhinduro yemafungiro, asi Excel inoratidzira mafomu yemamiriro ezvinhu inogona kushandurirwa uye kuvharwa sezvinodiwa kuona chimiro panzvimbo pemhinduro muchitokisi.
Cell References
Zvichipa nhamba yemasero pamushandi webasa, chirongwa chekuzivisa kana kugadzirisa chinotarisirwa kuitira kuti data iite nokukurumidza uye nyore nyore painodiwa.
Shanduro inoshandiswa mumapaparishita emazuva ano ndeyezvikamu zvinyorwa, izvo zvinosanganiswa netsamba yemutsara uye mutsara we nhamba yesero. Mune izvi zvinyorwa zvinyorwa , tsamba yemutsara inogara yakanyorwa pakutanga seA1, B12, kana AA2345.
Maferensi emapoka anoita sevashandi vemagetsi kana anoshandiswa mune zvinhu zvakadai semafomu nemasharu uye kuvepo kwavo anoita kuti zvive nyore kuvandudza mafomu aya nemataiti, sezvo chero chipi zvacho chiripo chiri muchitokisi chinongoerekana chapinda munzvimbo yakakodzera mumutambo kana chati .
Cell Formatting
- Mamwe masero ari mune pepa rekushandisa anoshandisa maitiro akafanana nekusavapo, izvo zvinoita kuti mabhizimisi makuru ebasa ane data yakawanda yakaoma kuverenga. Kuwedzera kuumbwa kune nzvimbo dzakasiyana dzepepa rekushandisa kunogona kuisa pfungwa kune zvikamu zvakasiyana uye kuita kuti zvive nyore kuverenga nekuzvinzwisisa.
- Kufambisa kwemafoni kunopesana nehuwandu hwemajeri . Kuisa masero kunosanganisira kuchinja kune sero pachako - zvakadai sekuchinja sero remavara, kuwedzera miganhu, kana kushandura kuenzaniswa kwedata. Nhamba yehuwandu hwemhando inobatanidza nenzira iyo nhamba mumasero inoratidzirwa - zvakadai semari, mapeji, kana kuratidza nhamba dzisina kunaka mumavhudzi.
Kuratidzwa vs. Kusimwa Numeri
Mune zvose Excel neGoogle Spreadsheets, kana mafomu ematare ari kushandiswa, nhamba inoguma inoratidzwa muchitokisi inogona kusiyanana nenhamba chaiyo yakachengetwa muchitokisi uye inoshandiswa mukuverenga.
Apo kuenzanisa kuchinja kunoitwa kumatairi muchitokisi izvo zvinoshandiswa zvinongobatsira chete kuonekwa kwenhamba uye kwete nhamba yacho pachayo. Semuenzaniso, kana nhamba 5.6789 mune imwe kero yakagadziridzwa kuratidzira mbiri mbiri dzepamusoro (madivi maviri kusvika kune kodzero ye decimal), sero ringaratidza nhamba se 5.68 nekuda kwekukomberedza nhamba yechitatu.
Maverengero uye Maverengedhi Akaumbwa
Kana zvasvika pakushandisa masero akaenzaniswa akaita deta muhuwandu, zvisinei, nhamba yose - muchiitiko ichi 5.6789 - ingashandiswa pane zvose kuverengwa kwete nhamba yakakomberedza inowanikwa musero.
Kuwedzera Masekeri kune Pepa Rokushanda mu Excel
Cherechedza: Google Spreadsheets haibvumiri kuwedzera kana kubviswa kwemasero masere - chete kuwedzera kana kubviswa kwemitsara yakazara kana ma column.
Apo masero ega ega akawedzerwa pane pepa rekushanda, masero aripo uye data yavo inotamirwa kana pasi kana kune kodzero yekuita nzvimbo yekamuri idzva.
Maseji anogona kuwedzerwa
- Nekibhokisi zvishoma zvitsva;
- Nokukanda zvakananga ne mouse
- Nokushandisa iyo Insert option paImba yebhu yebhoni;
Kuti uwedzere kanopfuura imwe kero panguva imwe, sarudza masero akawanda sechitsika chekutanga mune nzira dziri pasi apa.
Kuisa Masero ne Shortcut Keys
Iko kemikisi huru yekubatanidzwa kwekuisa masero mupepaiti ndeyokuti:
Ctrl + Shift + "+" (pamwe nechiratidzo)Cherechedza : Kana iwe uine kadhibhokisi neNhamba Pad kune kurudyi kwebhodhi rekugara, unogona kushandisa chiratidzo + ipapo pasina Shift key. Iko inosanganiswa inowanikwa chete:
Ctrl + "+" (pamwe nechiratidzo)Right Click neMouse
Kuwedzera sero:
- Kona pajeri apo sero idzva rinofanira kuwedzerwa kuzarura mamiriro ekutenderera;
- Mune menyu, chengeta paIndai kuti uzarure Insert dialog box ;
- Mubhokisi rebhokisi, sarudza kuva nemasero akavapoteredza achidzoka pasi kana kurudyi kuti awane nzvimbo yesero idzva;
- Dzvanya OK kuti uise seni uye vhura bhokisi rebhokisi.
Zvimwe, iyo Insert dialog box inogona kuvhurwa kuburikidza neIndaneti icon paImba yebhu yebhoni sezvinoratidzwa mumufananidzo uri pamusoro.
Kana uchinge wasvinuka, tevera matanho matatu ne4 kumusoro pamusoro pekuwedzera masero.
Kusvuta Masero uye Muchiri Mukati
Masero ega ega uye zviri mukati maro anogonawo kubviswa kubva pahwhepa. Kana izvi zvichiitika, masero uye data yavo kubva pasi apa kana kuti kurudyi rwechifuro chakabviswa ichaenda kuti izere gomba.
Kuchenesa masero:
- Simbisa rimwe kana masero masere kuti abudiswe;
- Kona pajeri masero akasarudzwa kuti uzarure mamiriro ekutenderera;
- Mune menyu, tora paChenesa kuti uzarure Delete dialog box;
- Mubhokisi rebhokisi, sarudza kuva nemasero anodonha kumusoro kana kubva kuruboshwe kuti atore nzvimbo dzakabviswa;
- Dzvanya OK kuti usiye masero uye uvhare bhokisi rebhokisi.
Kuchenesa zviri mukati rimwechete kana mamwe masero, pasina kubvisa sero pachayo:
- Simbisai masero ane zvinyorwa zvinofanira kubviswa;
- Dzvanya Chororo rekusiya pane keyboard.
Cherechedza: Ikey Backspace inogona kushandiswa kubvisa zviri mukati memusero imwe chete panguva. Mukuita kudaro, inoisa Excel muHarimi mode. Kuchenesa key ndiyo nzira yakanakisisa yokubvisa zviri mukati memasero akawanda.