Daidaito kamar akan allo a cikin Excel: yadda ake saitawa

Sau da yawa, masu amfani waɗanda ke yin lissafi a cikin Excel ba su gane cewa ƙididdige ƙididdiga a cikin sel ba koyaushe suna yarda da bayanan da shirin ke amfani da su don yin lissafi ba. Yana da game da ƙayyadaddun dabi'u. Gaskiyar ita ce, shirin na Excel yana adanawa a cikin ƙididdiga masu ƙima waɗanda ke ɗauke da har zuwa lambobi 15 bayan ma'aunin ƙima. Kuma duk da cewa, ka ce, kawai 1, 2 ko 3 lambobi za a nuna akan allon (sakamakon saitunan tsarin salula), Excel zai yi amfani da cikakken lambar daga ƙwaƙwalwar ajiya don ƙididdigewa. Wani lokaci wannan yana haifar da sakamako da sakamako mara tsammani. Don hana faruwar hakan, kuna buƙatar daidaita daidaiton zagaye, wato, saita shi daidai da kan allo.

Yadda zagaye ke aiki a Excel

Da farko, kana buƙatar la'akari da gaskiyar cewa yana da kyau kada a yi amfani da wannan saitin ba dole ba. Yana da kyau a yi tunani a hankali da yanke shawarar kanku ko yana da ma'ana don saita daidaito kamar akan allon ko a'a, tunda sau da yawa lokacin aiwatar da lissafin tare da adadi mai yawa na lambobi, abin da ake kira tasirin tarawa yana faruwa, wanda ya rage daidaiton lissafin da aka yi.

Yana da daraja saita daidaito kamar akan allo a cikin waɗannan lokuta. Alal misali, bari mu ce muna son ƙara lambobi 6,42 da 6,33, amma muna so mu nuna wuri ɗaya ne kawai, ba biyu ba.

Don yin wannan, zaɓi sel da ake so, danna-dama akan su, zaɓi abu "Format Cells ..." abu.

Kasancewa a cikin shafin "Lambar", danna tsarin "Lambobi" a cikin jerin da ke hagu, sannan saita darajar zuwa "1" don adadin wuraren decimal kuma danna Ok don fita daga cikin taga da aka tsara kuma ajiye saitunan.

Bayan ayyukan da aka yi, littafin zai nuna ƙimar 6,4 da 6,3. Kuma idan an ƙara waɗannan ƙananan lambobi, shirin zai ba da jimlar 12,8.

Yana iya zama kamar cewa shirin ba ya aiki daidai kuma ya yi kuskure a cikin lissafin, saboda 6,4 + 6,3 = 12,7. Amma bari mu gano ko da gaske haka lamarin yake, kuma me yasa irin wannan sakamakon ya kasance.

Kamar yadda muka ambata a sama, Excel yana ɗaukar ainihin lambobi don ƙididdigewa, watau 6,42 da 6,33. A cikin tsarin tattara su, sakamakon shine 6,75. Amma saboda gaskiyar cewa kafin wannan wuri ɗaya na ƙayyadaddun ƙayyadaddun ƙayyadaddun ƙayyadaddun tsari, ana yin tantanin halitta da ke haifar da shi, kuma ana nuna sakamakon ƙarshe daidai da 6,8.

Don guje wa irin wannan ruɗani, mafi kyawun mafita shine saita daidaiton zagaye kamar akan allo.

lura: Domin gano ainihin ƙimar da shirin ke amfani da shi don yin lissafi, danna kan tantanin halitta mai ɗauke da ƙimar lambobi, sannan ku kula da ma'aunin dabarar, wanda zai nuna cikakken lambar da aka adana a cikin ƙwaƙwalwar shirin.

Yadda ake daidaita daidaito kamar akan allo

Da farko, bari mu gano yadda ake daidaita daidaiton zagaye kamar yadda yake kan allo a sigar Excel 2019.

1. Muna zuwa menu "File".
2. Danna kan abin "Saituna" a cikin jeri na hagu a kasa.
3. Wani ƙarin taga tare da sigogi na shirin zai buɗe, a gefen hagu wanda muke danna sashin "Advanced".
4. Yanzu, a gefen dama na saitunan, nemi wani shinge mai suna "Lokacin da za a sake lissafin wannan littafin:" kuma duba akwatin kusa da zaɓin "Sanya ƙayyadaddun daidaito". Shirin zai faɗakar da mu cewa za a rage daidaito tare da wannan saitin. Mun yarda da wannan ta danna maɓallin Ok sannan kuma Ok sake don tabbatar da canje-canje kuma mu fita taga zaɓin.

lura: Idan ya zama dole don kashe wannan yanayin, je zuwa sigogi iri ɗaya kuma kawai cire akwati mai dacewa.

Daidaita Madaidaicin Zagayawa a Tsarin Farko

Duk da ci gaba da sabuntawa na shirin Excel, yawancin ayyuka na asali da algorithm don amfani da su suna canzawa kaɗan ko zama iri ɗaya don masu amfani, bayan sun canza zuwa sabon sigar, ba su fuskanci matsalolin yin amfani da sabon ƙirar, da sauransu.

A cikin yanayinmu, algorithm don saita daidaito kamar akan allo a cikin sigar farko na shirin kusan iri ɗaya ne da abin da muka ɗauka a sama don sigar 2019.

Microsoft Excel 2010

1. Je zuwa menu "File".
2. Danna kan abu tare da sunan "Settings".
3. A cikin saitunan saitunan da ke buɗewa, danna abu "Advanced".
4. Sanya alama a gaban zaɓin "Saita daidaito kamar akan allo" a cikin toshe saitunan "Lokacin da ake sake lissafin wannan littafin". Bugu da ƙari, muna tabbatar da gyare-gyaren da aka yi ta danna maɓallin OK, la'akari da gaskiyar cewa za a rage daidaito na lissafin.

Microsoft Excel 2007 da 2003

Siffofin waɗannan shekarun, bisa ga wasu masu amfani, sun riga sun tsufa. Wasu la'akari da su quite dace da kuma ci gaba da aiki a cikin su har yau, duk da fitowan na sabon versions.

Bari mu fara da sigar 2007.

1. Danna alamar "Microsoft Office", wanda ke cikin kusurwar hagu na sama na taga. Ya kamata lissafin ya bayyana wanda a ciki kake buƙatar zaɓar wani yanki mai suna "Excel Options".
2. Wani taga zai buɗe wanda a cikinsa kake buƙatar abu "Babba". Na gaba, a hannun dama, zaɓi rukunin saitunan "Lokacin da ake sake ƙididdige wannan littafin" kuma duba akwatin kusa da aikin "Saita daidaito kamar kan allo".

Tare da sigar farko (2013), abubuwa sun ɗan bambanta.

1. A saman menu na sama kana buƙatar nemo sashin "Service". Bayan an zaɓa, za a nuna jerin abubuwan da kuke buƙatar danna kan abin "Zaɓuɓɓuka".
2. A cikin taga da ke buɗe tare da sigogi, zaɓi "Lissafi" sannan duba akwatin kusa da zaɓin "Tsarin Daidaitawa kamar akan allo".

Kammalawa

Saita daidaito kamar akan allo a cikin Excel yana da amfani sosai, kuma a wasu yanayi, aiki mai mahimmanci wanda ba kowane mai amfani ya sani ba. Ba zai zama da wahala a yi saitunan da suka dace ba a cikin kowane juzu'in shirin, tunda babu wani bambance-bambance na asali a cikin tsarin aikin, kuma bambance-bambancen suna cikin musaya da aka gyara kawai, wanda, duk da haka, ana kiyaye ci gaba.