Yin ƙididdigar daban-daban a cikin Excel, masu amfani ba koyaushe tunanin cewa ƙimar da aka nuna a sel wasu lokuta ba ta dace da waɗanda shirin ke amfani da shi don ƙididdige ba. Gaskiya ne gaskiya ga darajar kuɗi. Misali, idan kana da tsarin tsara lamba da aka sanya wanda yake nuna lambobi tare da wurare biyu masu kyau, wannan baya nuna cewa Excel yayi la'akari da irin wannan ba. A'a, ta tsohuwa wannan shirin yana kirga wurare 14 na decimal, koda kuwa haruffa biyu ne kawai aka nuna a cikin tantanin halitta. Wannan gaskiyar na iya haifar da wani lokacin mummunan sakamako. Don magance wannan matsalar, ya kamata ka saita daidaiton daidaituwa kamar yadda akan allon yake.
Saita zagaye kamar yadda akan allon
Amma kafin yin canji a cikin saiti, kuna buƙatar gano idan kuna buƙatar gaske don kunna daidaito kamar akan allon. Tabbas, a wasu halaye, lokacin da aka yi amfani da adadi mai yawa tare da wurare masu kyau, sakamako mai yuwuwu zai yiwu a cikin lissafin, wanda zai rage daidaiton lissafin gaba ɗaya. Sabili da haka, ba tare da buƙatar ba dole ba wannan yanayin shine mafi kyawun ba zagi ba.
Don haɗa daidaito kamar yadda akan allon, ya zama dole a cikin yanayi na shirin mai zuwa. Misali, kuna da aikin ƙara lambobi biyu 4,41 da 4,34, amma abin da ake bukata shi ne cewa wurin keɓaɓɓen wuri ne kawai aka nuna a kan allo. Bayan mun tsara tsarin da ya dace na sel, sai aka fara nuna abubuwan a allon 4,4 da 4,3, amma lokacin da aka kara su, shirin yana nuna sakamakon ba adadi ne a cikin tantanin halitta ba 4,7, da darajar 4,8.
Wannan shi ne daidai saboda gaskiyar cewa Excel mai faɗi ne don ƙididdigewa. 4,41 da 4,34. Bayan lissafin, sakamakon shine 4,75. Amma, tunda mun ƙayyade a cikin nuna ƙididdigar lambobi tare da wuri guda ɗaya kaɗai, ana yin zagaye kuma ana nuna lamba a cikin tantanin halitta 4,8. Sabili da haka, ya bayyana cewa shirin yayi kuskure (kodayake wannan ba haka bane). Amma a takarda da aka buga, irin wannan magana 4,4+4,3=8,8 zai zama kuskure. Sabili da haka, a wannan yanayin, yana da matuƙar hikima don kunna saiti daidai kamar yadda akan allon yake. Sannan Excel zai lissafta ba yin la’akari da lambobin da shirin ke dauke dashi a ƙwaƙwalwar ajiya ba, amma gwargwadon ƙimar da aka nuna a cikin tantanin halitta.
Don gano ƙimar ainihin lambar da Excel take ɗauka don ƙididdigewa, kuna buƙatar zaɓar tantanin da ya ƙunshi. Bayan wannan, ƙimar sa za a nuna shi a cikin mashaya dabara, wanda aka adana a ƙwaƙwalwar Excel.
Darasi: Lambobin gama-gari
Sanya saitunan daidaiton allon-allo a sigogin Excel na zamani
Yanzu bari mu gano yadda za'a kunna daidaito duka akan allon. Da farko, zamu kalli yadda ake yin wannan ta amfani da misalin Microsoft Excel 2010 da ire-irensa a gaba. Suna da wannan bangaren an kunna su a wannan hanyar. Bayan haka za mu koyi yadda ake gudanar da daidaito a kan allo a cikin Excel 2007 da kuma a cikin Excel 2003.
- Matsa zuwa shafin Fayiloli.
- A cikin taga da yake buɗe, danna maballin "Zaɓuɓɓuka".
- An ƙaddamar da ƙarin sigogi taga. Mun motsa a ciki zuwa sashin "Ci gaba"wanda sunansa ya bayyana a jeri a gefen hagu na taga.
- Bayan motsi zuwa sashin "Ci gaba" matsa zuwa gefen dama na taga, a ciki akwai saitunan shirye-shirye daban-daban. Nemo toshe saitin "Lokacin da ake karanta wannan littafin". Duba akwatin kusa da sigogi "Sanya daidaito kamar yadda akan allon".
- Bayan wannan, akwatin magana yana bayyana wanda ya ce daidaito na lissafin zai rage. Latsa maballin "Ok".
Bayan haka, a cikin Excel 2010 da sama, za a kunna yanayin "daidaito kamar yadda akan allon".
Don hana wannan yanayin, kuna buƙatar cire ƙirar zaɓuɓɓuka a kusa da saitunan "Sanya daidaito kamar yadda akan allon", saika danna maballin "Ok" a kasan taga.
Ana kunna saitunan daidaiton allo akan Excel 2007 da Excel 2003
Yanzu bari mu bincika yadda daidaitattun yanayin ke aiki duka akan allo a cikin Excel 2007 da kuma Excel 2003. Kodayake ana ɗaukar waɗannan nau'ikan jujjuyawar aiki, har yanzu da yawa masu amfani suna amfani da su.
Da farko, la'akari da yadda za'a kunna yanayin a cikin Excel 2007.
- Danna alamar Microsoft Office a saman kusurwar hagu na taga. Cikin jeri wanda ya bayyana, zaɓi Zabi na kwarai.
- A cikin taga da ke buɗe, zaɓi "Ci gaba". A cikin ɓangaren dama na taga a cikin rukunin saiti "Lokacin da ake karanta wannan littafin" duba kwalin kusa da sigogi "Sanya daidaito kamar yadda akan allon".
Yanayin daidaito kamar yadda akan allon za'a kunna.
A cikin Excel 2003, hanya don ba da damar yanayin da muke buƙata ya bambanta sosai.
- A cikin menu na kwance, danna kan kayan "Sabis". Cikin jeri dake buɗe, zaɓi matsayin "Zaɓuɓɓuka".
- Zaɓuɓɓukan taga yana farawa. A ciki, je zuwa shafin "Lissafi". Kusa, duba akwatin kusa da "Yi daidai kamar yadda akan allon" kuma danna maballin "Ok" a kasan taga.
Kamar yadda kake gani, saita yanayin daidaito daidai kamar yadda akan allon in Excel yake mai sauqi ne, komai girman tsarin. Babban abu shine sanin ko a cikin wani yanayi yana da kyau a gudanar da wannan yanayin ko a'a.
