Kushandisa Point uye Chofoza Kuti Uumbe Mafomu mu Excel

Kushandisa nheyo uye cheka mu Excel uye Google Spreadsheets inokubvumira kushandisa purogiramu yeguru kuti uwedzere masero ezvinyorwa kune chirevo chete nekunyanya pane imwe sero inoda sezvinoratidzwa mumuenzaniso uri mumufananidzo uri pamusoro.

Pano nekodha kazhinji ndiyo nzira inoshandiswa yekuwedzera masero ekutaura kune chirevo kana basa sezvo inoderedza kukanganisa kwezvikanganiso zvakatangwa nekusaverenga kana kuisa pane zvisina kururama sechitsiko chese.

Iyi nzira inogonawo kuchengetedza nguva yakawanda nekuedza paunenge uchigadzira mapepa sezvo vanhu vakawanda vachiona dhenda ravanoda kuwedzera pane chirevo panzvimbo pekutsanangurwa kwekero.

Kugadzira Mufaira Kushandisa Nzvimbo uye Chefa

1. Tora chikamu chakaenzana (=) mumusero kutanga fomu;
2. Dzvanya pamusero wekutanga kuti uwedzerwe kumushonga. Tsanangudzo yesero ichaonekwa mumutsetse, uye ruvara rwebhuruu rwakasvibiswa ruchaonekwa nepamusoro pechitsetse chetaundi;
3. Dhinda purogiramu yemathematical pane keyboard (zvakadai sokuwedzera kana kusina chiratidzo) kupinda mupurisa muyamuro mushure mekutanga kero-reta;
4. Dzvanya pachikamu chechipiri kuti chiwedzerwe kumutsetse. Tsanangudzo yesero ichaoneka mumutsetse, uye ruvara rutsvuku rwakaratidza rutivi rwechipiri rakataridzirwa sero;
5. Ramba uchinge uine maitiro uye zvinyorwa zvinoshandiswa kusvikira magetsi apera;
6. Dhinda Udza pakibhodi kuti upedze fomu uye uone mhinduro yacho muchitokisi.

Point and Click Variation: Kushandisa Arrow Keys

Kusiyana kwechinhu uye kubhadhara kunosanganisira kushandisa mitsara yemiseve pabhobhoyo kuti upinde majekesiti mumanyorerwo. Zvigumisiro izvi zvakafanana, uye inongova nyaya yenyaya yekusarudza nzira yakasarudzwa.

Kushandisa mitsara yemiseve kuti upinde majekiti ezvinyorwa:

1. Tora chikamu chakaenzana (=) mujeri kuti utange fomu;
2. Shandisai miseve yemiseve pabhobhoyo kuti uende kumusero wekutanga unoshandiswa mumutsetse - sero rekuyera yeiyo cell rinowedzerwa kumushandisi mushure mechiratidzo chakaenzana;
3. Dhinda purogiramu yemathematical paikbhobho - yakadai sechiratidzo chekuwedzera kana chinopfurikidza - kupinda mufambisi mumushure mushure mekutanga kwesero rekutsvaga (iyo inoshandiswa sechinyorwa chekusimudza ichadzoka kusero iri rine fomu);
4. Shandisai mitsara yemiseve pabhobhoyo kuti uende kune imwe yechipiri sero inoshandiswa mumutsetse - wechipiri sero reference inowedzerwa muyamuro mushure mekuita masvomhu;
5. Kana zvichidikanwa, pinda mazamu akawedzera mashematiki achishandisa keyboard ikatevedzerwa nesero rinoshandiswa ye data ye formula
6. Kana imwe shanduro yacho yapera, pinda muIngiiyo pikicha kuti upedze fomu uye uone mhinduro yacho mumusero.