Imathematika ayifanele ibe nzima xa usebenzisa i-Excel
Njengazo zonke izibalo zemisebenzi ezisisiseko kwi-Excel ukuze ungeze amabini okanye amaninzi kwi-Excel kufuneka udale ifom .
Qaphela: Ukongeza amanani amaninzi asekholomu enye okanye umgca kwiphepha lokusebenzela, sebenzisa umsebenzi we-SUM , onika indlela emfutshane yokudala ifom yefowuni ende.
Amaphupha abalulekileyo okumele akhumbule malunga namafomula e-Excel:
- Iifomula kwi-Excel zihlala ziqala ngophawu olulinganayo ( = );
- Uphawu olulinganayo luhlala lufakwe kwiseli apho ufuna impendulo ivele khona;
- Ukongeza uphawu kwi-Excel yisimboli esino-plus (+);
- Ifomula igqityiweyo ngokucinezela ukhiye wokungena kwikhibhodi.
Sebenzisa i-Cell Referencing kwiifomula zokongeza
Kulo mfanekiso ungentla, isethi yokuqala yemizekelo (imigangatho 1 kuya kwe-3) isebenzise ifomula elula-ekhompyutheni C - ukudibanisa idatha kunye kwiikholamu A no-B.
Nangona kunokwenzeka ukufaka manani ngqo kwifomula yofakelo - njengoko kuboniswe ngolu hlobo:
= 5 + 5
kumgca wesi-2 womfanekiso - kungcono ukufaka idatha kwiiseli zomsebenzi kwaye sebenzisa iidilesi okanye izikhokelo zala maseli kwifomu - njengoko kuboniswe yi-formula
= A3 + B3
kumqolo 3 ngasentla.
Enye inzuzo yokusebenzisa izikhokelo zeselfayile kunokuba idatha yangempela kwifom leyo kukuba, ukuba emva komhla, kuyimfuneko ukutshintsha idatha yinto elula yokutshintsha idatha kwiseli kunokubhala kwakhona ifom.
Ngokuqhelekileyo, iziphumo zefomu ziya kuhlaziya ngokuzenzekelayo xa idatha iguquka.
Ukufaka iiReferensi zeeNombolo kunye neCock kunye Cofa
Nangona kunokwenzeka ukuba uthayiphe nje ifom yelapha ngentla kwi-cell C3 kwaye uphendule impendulo echanekileyo, ngokuqhelekileyo ukusebenzisa iphoyinti kwaye ucofe , okanye ukukhomba , ukongeza iiferensi zeeseli kwiifomula ukwenzela ukunciphisa ubunokwenzeka beephene ezenziwe ukuthayipha kwifom yesalathisi engalunganga.
Iphoyinti kwaye uqhosha uquka ngokuchofoza kwiseli equle idatha kunye nekhompi ye mouse ukuze wongeze i-cell reference kwifom.
Ukudala iFomula Yongeza
Amanyathelo asetyenziswa ukudala ifomula yokufakela kwiseli C3 yile:
- Thayipha uphawu olulinganayo kwiseli C3 ukuqala ifom;
- Cofa kwifowuni A3 kunye nekhompi ye mouse ukuqinisekisa ukuba iselferensi yesalathiso kwifomula emva kwesayinwa esilinganayo;
- Thayipha uphawu lwe-plus (+) kwifom emva kwe- A3;
- Cofa kwifowuni B3 kunye nesinathisi se mouse ukuze ungeze ukuba isalathisi yesalathisi kwifom emva kwesaziso sokongeza;
- Cinezela ukhiye wokungena kwikhibhodi ukugqiba ifom;
- Impendulo ye-20 ifanele ibe khona kwiseli C3;
- Nangona ubona impendulo kwiseli C3, ukucofa kweso sisele kuya kubonisa ifom = A3 + B3 kwifom yefomula ngaphezulu kwephepha lokusebenzela.
Ukutshintsha iFormula
Ukuba kuyimfuneko ukulungisa okanye utshintshe ifomu, ezimbini zezona ndlela zikhethileyo zilandelayo:
- Chofoza kabini kwifom kwifom yokusebenzela ukubeka i-Excel kwimodi yokuHlela uze wenze utshintsho kwifom - isebenza ngcono kwiinguqu ezincinane.
- Cofa kanye kwiseli equle ifom kwaye uphinde ufake yonke ifomula - eyona nto ingcono utshintsho olukhulu.
Ukudala iifomula ezingakumbi
Ukubhala iifomula eziyinkimbinkimbi ezibandakanya imisebenzi emininzi - njengokwahlula okanye ukususa okanye ukongeza - njengoko kuboniswe kwimigangatho emihlanu ukuya kweyesixhenxe kumzekelo, sebenzisa amanyathelo alwe apha ngentla ukuze uqalise kwaye uqhubeke nje ukongeza umqhubi weemathematika olandelelweyo olandelwa izikhokelo zeeseli eziqulethe idatha entsha.
Ngaphambi kokudibanisa imisebenzi ehlukeneyo yemathematika kunye kunye nefomula, ke kubalulekile ukuqonda ukulandelwa kwemisebenzi eyenziwa ngu-Excel xa uhlola i-formula.
Ukuziqhelanisa, zama le nyathelo ngomzekelo wesisombululo sefomula eqinile .
Ukudala ukulandelelana kweFibonacci
Ulandelelwano lwe-Fibonacci, olwenziwe ngumbalo wesayensi we-Italiyali we-12 we-Italy uLeonardo Pisano, yakha uluhlu oluqhubekayo lweenombolo ezikhulayo.
Ezi ngcelele zivame ukusetyenziswa ukuchaza, izibalo, phakathi kwezinye izinto, iipatheni ezahlukeneyo ezifumaneka kwindalo efana nale:
- Ukubunjwa kwemimoya yolwandle eyahlukileyo;
- Ilungiselelo lamaqabunga kwisebe lomthi;
- Umzekelo wokuvelisa iinyosi.
Emva kwamanani amabini okuqala, inani ngalinye elongezelelweyo kulolu chungechunge lubalo lwamanani amabini angaphambili.
Ukulandelelana kweFibonacci elula, kuboniswe kumfanekiso ongentla, kuqala ngeenombolo zero kunye nenye:
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, 1597, 2584 ...
Fibonacci kunye ne Excel
Ekubeni uchungechunge lwe-Fibonacci luquka ukudibanisa, luyakwazi ukudala kalula ngefomula yokufakela kwi-Excel njengoko kuboniswe kumfanekiso ongentla.
Amanyathelo angezantsi iinkcukacha ngendlela yokwenza ukulandelelana kweFibonacci elula usebenzisa ifom. Amanyathelo afaka ukudala ifomu yokuqala kwifom ye-A3 kwaye ukukopisha loo fom kwiiseli eziseleyo usebenzisa isibambo sokuzalisa .
I-iteration nganye, okanye ikopi, yefomula, idibanisa ndawonye amanani amabini anaphambili ngokulandelelana.
Amanyathelo angezantsi enza ukulandelelana kwikholam enye, kunokuba kukho iikholamu ezintathu eziboniswe kumzekelo womfanekiso ukwenza lula ukukopisha inkqubo.
Ukwenza uchungechunge lweFibonacci luboniswe kumzekelo usebenzisa ifomula yokongeza:
- Kwi-cell A1 thayipha i-zero (0) kwaye cinezela ukungena kwekhibhodi;
- Kwiseli ye-A2 thayipha i-1 kwaye cinezela iqhosha lokungena ;
- Kwiseli A3 thayipha ifomula = A1 + A2 kwaye cinezela ukhiye wokungena ;
- Cofa kwifowuni A3 ukwenza iseli esebenzayo ;
- Beka isikhombisi semouse phezu kwesibambo sokugcwalisa - ibhola elimnyama kwicala eliphantsi lasezantsi le-cell A3 - isalathisi sitshintshela kwisibonakaliso sabantu abamnyama ( + ) xa siphezu kwesibambo sokuzalisa;
- Gcina inkinobho yemouse kwiphathi lokugcwalisa uze uhudule umboniso we mouse kwi-cell A31;
- I-A kufuneka ifake inombolo 514229 .