Math haafaniri kunge yakaoma paunoshandisa Excel
Sezvo nezvose zvidzidzo zvemasvomhu muEexcel kuwedzera nhamba mbiri kana kupfuura kuExcel unoda kugadzira fomu .
Cherechedza: Kuwedzera pamwe nhamba dzinoverengeka dzinowanikwa muhomwe imwechete kana mumutsara mune pepa rekushanda, shandisa SUM Function , iyo inopa nzira yekutsvaga pakuumba fomu yakawedzerwa yekuwedzera.
Pfungwa dzinokosha kuti uyeuke nezveExcel formula:
- Mifananidzo iri muExcel inotanga nguva dzose nechiratidzo chakaenzana ( = );
- Chiratidzo chakafanana chinogara chichiiswa muchitokisi umo unoda kuti mhinduro ioneke;
- Chiratidzo chekuwedzera muExcel ndicho chinosanganisira chiratidzo (+);
- Icho chinyorwa chinopedzerwa nekudhinda Enter key pane keyboard.
Shandisa Cell Referencing muAdding Formulas
Mumufananidzo wepamusoro, sarudzo yekutanga ye mienzaniso (mitsetse 1 kusvika ku3) inoshandisa fomu iri nyore - iri muhomwe C - kuwedzera pamwechete data mumakoronike A uye B.
Kunyange zvazvo zvichikwanisika kuisa nhamba zvakananga mumusanganiswa wekuwedzera - sezvinoratidzwa nemurairo:
= 5 + 5
mumutsara wechipiri wemufananidzo - zviri nani zvikuru kupinda ma data mumashandisi ekushanda uye zvino shandisa maateri kana zvinyorwa zvemasero aya mufomula - sezvinoratidzwa nemutemo
= A3 + B3
mumutsara 3 pamusoro.
Rimwe ruzivo rwekushandisa masero ezvinyorwa panzvimbo pezvakanyorwa mumagadzirirwo ndeokuti, kana pane imwe nguva inotevera, inenge yakadikanwa kuchinja dambudziko iri chinhu chisiri nyore chekutsvaga deta iri muchitokisi pane kunyorazve chirevo.
Kazhinji, migumisiro yechipfuva ichadzoka pakarepo kana data ichichinja.
Kupinda Maferensi emunzvimbo nePoint and Click
Kunyange zvazvo zvichikwanisika kungonyora fomu iri pamusoro apa muchitsetse C3 uye kuti mhinduro yakarurama ioneke, kazhinji kazhinji zviri nani kushandisa nhomwe uye kuvhara , kana kuratidzira , kuwedzera sero zvinyorwa zvemafomu kuitira kuti kuderedze kukanganisa kwezvikanganiso zvakasikwa ne kunyora mune zvisina kururama cell reference.
Pano nechokuita zvinosanganisira kungovhara pachitokisi chine data pamwe nehope pointer kuti uwedzere kutarisa kwesekeri kweromusi.
Kuumba kuwedzera Moutha
Nhanho dzinoshandiswa kugadzira fomu yekuwedzera muchitokisi C3 ndeiyi:
- Tora chikamu chakaenzana muchitokisi C3 kuti utange fomu;
- Dzvanya pachitokisi A3 ine mouse pointer kuti uwedzere kuti sero rinotarisa kumutsetse mushure mokunge chiratidzo chakaenzana;
- Tora iyo plus chiratidzo (+) mu formula pashure peA3;
- Dzvanya pachitokisi B3 neine mouse pointer kuti uwedzere kuti sero rinotarisa mushure mushure mekuwedzera kwechiratidzo;
- Dhinda pikicha inopinda mubhokisi kuti upedze fomu;
- Mhinduro 20 inofanira kuva iri muchitokisi C3;
- Kunyangwe iwe uchiona mhinduro yacho muchitokisi C3, kutarisa pane iyo seni kucharatidza rondedzero = A3 + B3 mubhadha yepamusoro pane pepa rekushanda.
Kuchinja Mutemo
Kana zvichizodiwa kugadzirisa kana kushandura chirevo, zviviri zvezvakanakisisa zvinosarudzwa ndezvi:
- Tora kaviri pane mazano mumushandi webasa kuti uise Excel muHarimi mode uye wobva waita shanduko pamutemo - unoshanda zvakanakisisa kuchinja kuduku.
- Dzokorora kamwe chete pane sero rine chinyorwa uye wodzokorora zvakare fomu yose - yakanakisisa nokuda kwekuchinja kukuru.
Kuumba Zvimwe Zvinyorwa Zvakawanda
Kunyora mazano akawanda anowanzobatanidza maitiro akawanda - akadai sokuparadzanisa kana kubvisa kana kuwedzera - sezvinoratidzwa mumitsara mashanu kusvika kune vanomwe mumuenzaniso, shandisa matanho ari pamusoro apa kuti utange uye ipapo ramba uchinge uwedzere mhando yakarurama yemasvomhu inotevera sero rekufananidzira rine zvinyorwa zvitsva.
Pamberi kusanganisa mahedheni akasiyana-siyana kushanda pamwe chete mumurairo, zvakadaro, zvakakosha kunzwisisa mutemo wekushanda iyo Excel inotevera kana uchitarisa fomu.
Kuti uite tsika, edza muenzaniso uyu wedanho nechikamu chekunyanya kwakaoma .
Kuumba Fibonacci Sequence
Chirevo cheFibonacci, chakagadzirwa nechechi yechipiri chemazana emutauro weItaly anonzi Leonardo Pisano, iite rutsva rinopfuurira rune nhamba dzinowedzera.
Izvi zvinowanzoshandiswa kutsanangura, masvomhu, pakati pezvimwe zvinhu, maitiro akasiyana anowanikwa mune zvakasikwa zvakadai se:
- Mhepo yakagadzikana yeakasiyana siyana egungwa;
- Urongwa hwemashizha pabazi remuti;
- Nzira yekuberekorora nyuchi.
Mushure mokutanga nhamba mbiri, nhamba imwe neimwe inowanikwa mumutsara ndeyekuverengwa kwemaviri maviri akapfuura.
Kurongeka kwakanakisisa kweFibonacci, kunoratidzwa mumufananidzo uri pamusoro, kunotanga nenhamba nhamba uye imwe:
0, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, 1597, 2584 ...
Fibonacci uye Excel
Kubva pane imwe nyaya yeFibonacci inosanganisira kuwedzera, inogona kugadziriswa nyore nyore nehomwe yekuwedzera mu Excel sezvaratidzwa mumufananidzo uri pamusoro.
Matanho ari pasi apa tsanangudzo yekuti ungagadzira sei kurongeka kwakaitwa Fibonacci nekushandisa fomu. Nhanho dzinosanganisira kusika mazai okutanga muchitsetse A3 uye zvino kuenzanisa maitiro aya kune masero akasara achishanda.
Itairi imwe neimwe, kana kopi, yemutsetse, inowedzera pamwe nhamba mbiri dzakapfuura muchidimbu.
Matanho ari pasi apa anoita kuti kugovera kuve kune imwe korombo, panzvimbo pematatu matatu anoratidzwa mumuenzaniso wemufananidzo kuitira kuti nzira yekukopa ive nyore.
Kugadzira zvinyorwa zveFibonacci zvinoratidzwa mumuenzaniso uchishandisa mufananidzo wokuwedzera:
- Muchikamu cheA1 chengetedza zero (0) uye diya Enter Enter pane keyboard;
- Muchikamu cheA2 chinyorwa 1 uye pinda paImpikicha;
- Muchikamu cheA3 chinyorwa chirevo = A1 + A2 uye shandisa Enter key;
- Dzvanya pane sero A3 kuti uite iyo inoshandiswa seki ;
- Isai peinter mouse pamusoro pemiti yekuzadza - iyo yakazara dot muzasi yekona yekona yesero A3 - iyo pointer inoshanduka kune chiratidzo chekunyama ( + ) kana iri pamusoro pemubati wakakwana;
- Tora pasi bundu rekipi pane chigadziro chozadza uye shandisai pointer mouse kumusasa A31;
- A31 inofanira kuva nenhamba 514229 .