Okuqukethwe
Ukunquma iphesenti lenombolo kuwumsebenzi ovamile lowo umsebenzisi we-Ecxel osebenza ngezinombolo okufanele abhekane nawo. Izibalo ezinjalo ziyadingeka ukwenza imisebenzi eminingi: ukunquma usayizi wesaphulelo, umaki, izintela, njalonjalo. Namuhla sizofunda ngokuningiliziwe ukuthi yini okufanele yenziwe ukuze siphindaphinde inombolo ngephesenti.
Ungaphindaphinda kanjani inombolo ngephesenti ku-Excel
Liyini iphesenti? Lokhu kuyingxenyana ka-100. Ngokuvumelana nalokho, uphawu lwephesenti luhunyushwa kalula lube inani eliyingxenye. Isibonelo, amaphesenti angu-10 alingana nenombolo 0,1. Ngakho-ke, uma siphindaphinda u-20 ngo-10% futhi ngo-0,1, sizogcina sinenombolo efanayo - 2, njengoba lokho kuyingxenye yeshumi yenombolo 20. Kunezindlela eziningi zokubala amaphesenti kuma-spreadsheet.
Indlela yokubala iphesenti mathupha kuseli eyodwa
Le ndlela ilula kakhulu. Kwanele ukumane unqume iphesenti lenombolo ethile usebenzisa ifomula evamile. Khetha noma yiliphi iseli, bese ubhala phansi ifomula: inombolo engu-uXNUMXd * inombolo yamaphesenti. Lena ifomula yendawo yonke. Ukuthi ibukeka kanjani ekusebenzeni kulula ukuyibona kulesi sithombe-skrini.
Siyabona ukuthi sisebenzise ifomula =20*10%. Okusho ukuthi, ukuhleleka kokubala kubhalwe kufomula ngendlela efanayo ncamashi nesibali sokubala esivamile. Yingakho le ndlela kulula ukufunda. Ngemuva kokuthi sifake ifomula mathupha, kusasele ukucindezela ukhiye wokungena, futhi umphumela uzovela esitokisini lapho sibhale khona phansi.
Ungakhohlwa ukuthi iphesenti libhalwe kokubili ngophawu % nanjengengxenye yedesimali. Awukho umehluko oyisisekelo phakathi kwalezi zindlela zokuqopha, njengoba lokhu kuyinani elifanayo.
Phindaphinda inombolo kuseli eyodwa ngephesenti kwelinye iseli
Indlela yangaphambilini ilula kakhulu ukuyifunda, kodwa ine-drawback eyodwa - asisebenzisi inani elivela kuseli njengenombolo. Ngakho-ke, ake sibone ukuthi ungayithola kanjani idatha yephesenti kuseli. Ama-mechanics ngokuvamile ayafana, kodwa isenzo esisodwa esingeziwe sidinga ukungezwa. Ukuze wenze lokhu, landela izinyathelo ezichazwe kuleli bhukwana:
- Ake sithi sidinga ukuthola ukuthi usayizi wesibonelelo uyini futhi sikubonise kukholamu E. Ukuze wenze lokhu, khetha iseli lokuqala bese ubhala ifomula efanayo kulo njengasefomini langaphambilini, kodwa esikhundleni sezinombolo, cacisa amakheli eseli. Ungenza futhi ngokulandelana okulandelayo: qala ubhale uphawu lokufaka lwefomula =, bese uchofoza kuseli yokuqala esifuna ukuthola kuyo idatha, bese ubhala uphawu lokuphindaphinda *, bese uchofoza kuseli yesibili. Ngemva kokufaka, qinisekisa amafomula ngokucindezela inkinobho ethi “ENTER”.
- Kuseli elidingekayo, sibona inani eliphelele.
Ukuze wenze izibalo ezizenzakalelayo zawo wonke amanye amanani, udinga ukusebenzisa umaka wokuqedela ngokuzenzakalela.
Ukuze wenze lokhu, hambisa ikhesa yegundane ekhoneni elingezansi kwesokunxele bese uhudulela ekugcineni kwekholomu yethebula. Idatha edingekayo izosetshenziswa ngokuzenzakalelayo.
Kungase kube nesinye isimo. Isibonelo, sidinga ukunquma ukuthi ingakanani ingxenye yesine yamanani aqukethwe kukholamu ethile. Khona-ke udinga ukwenza okufana ncamashi nanjengokusibonelo sangaphambilini, bhala kuphela u-25% njengenani lesibili esikhundleni sekheli leseli eliqukethe le ngxenye yenombolo. Hhayi-ke, noma hlukanisa ngo-4. Imishini yezenzo iyafana kulesi simo. Ngemva kokucindezela ukhiye we-Enter, sithola umphumela wokugcina.
Lesi sibonelo sibonisa ukuthi sinqume kanjani inani leziphambeko ngokusekelwe eqinisweni lokuthi siyazi ukuthi cishe ingxenye yesine yawo wonke amabhayisikili akhiqizwayo anokukhubazeka. Kukhona enye indlela elibala ngayo inani njengephesenti. Ukuze sibonise, masibonise inkinga elandelayo: kunekholomu C. Izinombolo zitholakala kuyo. Ukucaciswa okubalulekile - iphesenti liboniswa kuphela ku-F2. Ngakho-ke, lapho udlulisela ifomula, akufanele ishintshe. Yini okufanele uyenze kuleli cala?
Ngokuvamile, udinga ukulandela ukulandelana kwezenzo okufanayo nakwezimo ezidlule. Okokuqala udinga ukukhetha u-D2, beka = sayina bese ubhala ifomula yokuphindaphinda iseli C2 ngo-F2. Kodwa njengoba sinenani lephesenti kuphela kuseli eyodwa, sidinga ukulilungisa. Kulokhu, kusetshenziswa uhlobo lwekheli eliphelele. Ayishintshi lapho ukopisha iseli ukusuka kwenye indawo ukuya kwenye.
Ukuze uguqule uhlobo lwekheli lube ngokuphelele, udinga ukuchofoza inani le-F2 emugqeni wokufaka wefomula bese ucindezela ukhiye u-F4. Ngemva kwalokho, uphawu lwe-$ luzongezwa kuhlamvu nenombolo, okusho ukuthi ikheli lishintshile kusukela ekuhlotsheni kuya kokuphelele. Ifomula yokugcina izobukeka kanje: $F$2 (esikhundleni sokucindezela okuthi F4, ungakwazi ukwengeza uphawu lwe-$ ekhelini ngokwakho).
Ngemuva kwalokho, udinga ukuqinisekisa izinguquko ngokucindezela inkinobho ethi "ENTER". Ngemva kwalokho, umphumela uzobonakala esitokisini sokuqala sekholomu echaza inani lomshado.
Manje ifomula idluliselwa kuwo wonke amanye amaseli, kodwa isithenjwa esiphelele asishintshile.
Ukukhetha indlela yokubonisa amaphesenti kuseli
Kuye kwaxoxwa ngakho ngaphambilini ukuthi amaphesenti afika ngezindlela ezimbili eziyisisekelo: njengengxenye yedesimali noma kufomu % yakudala. I-Excel ikuvumela ukuthi ukhethe leyo oyithanda kakhulu esimeni esithile. Ukuze wenze lokhu, udinga ukuchofoza kwesokudla kuseli eliqukethe ingxenyenamba yenombolo, bese ushintsha ifomethi yeseli ngokukhetha into efanelekile kumenyu yokuqukethwe.
Okulandelayo, iwindi lizovela elinamathebhu amaningana. Sinentshisekelo kweyokuqala, esayindwe ngokuthi “Inombolo”. Lapho udinga ukuthola ifomethi yephesenti ohlwini olungakwesokunxele. Umsebenzisi uboniswa kusengaphambili ukuthi iseli lizobukeka kanjani ngemva kokuba lisetshenziswe kulo. Esigabeni esingakwesokudla, ungaphinda ukhethe inombolo yezindawo zamadesimali ezivunyelwe uma ubonisa le nombolo.
Uma ufuna ukuveza ingxenyenamba yenombolo njengeqhezu ledesimali, kufanele ukhethe ifomethi yenombolo. Iphesenti lizohlukaniswa ngokuzenzakalelayo ngo-100 ukwenza ingxenyenamba. Isibonelo, iseli eliqukethe inani elingu-15% lizoguqulwa ngokuzenzakalelayo libe ngu-0,15.
Kuzo zombili izimo, ukuze uqinisekise izenzo zakho ngemva kokufaka idatha efasiteleni, udinga ukucindezela inkinobho ethi OK. Siyabona ukuthi akukho okuyinkimbinkimbi ekuphindaphindeni inombolo ngephesenti. Ngikufisela inhlanhla.