Yin ƙididdiga masu yawa a Excel, masu amfani ba koyaushe suna tunanin cewa dabi'un da aka nuna a cikin sel a wasu lokuta ba daidai ba ne da waɗanda waɗanda shirin suke amfani da shi don lissafi. Wannan shi ne ainihin gaskiya game da dabi'un ƙwararru. Alal misali, idan ka saita tsarin tsarawa, wanda ya nuna lambobi tare da wurare na biyu, amma wannan ba yana nufin cewa Excel yayi la'akari da bayanan ba. A'a, ta hanyar tsoho, wannan shirin yana ƙidayar har zuwa wurare 14, amma idan ana nuna lambobi biyu kawai a cikin tantanin halitta. Wannan hujja zai iya haifar da wani sakamako mai ban sha'awa. Don magance wannan matsala, ya kamata ka saita daidaitattun tayi daidai kamar yadda akan allon.
Tsayar da zagaye kamar a kan allon
Amma kafin yin canjin wuri, kana buƙatar gano idan kana buƙatar kunna daidaito kamar a kan allon. Lalle ne, a wasu lokuta, lokacin amfani da babban adadi na lambobi tare da wurare masu ƙadi, za a iya yin tasiri tare a lissafi, wanda zai rage cikakken daidaitattun lissafi. Sabili da haka, ba tare da buƙatar bukatar wannan wuri ba mafi kyau ba zalunci.
Haɗa ƙayyadaddun akan allon, kana buƙatar a cikin yanayi na shirin gaba. Alal misali, kana da ɗawainiya don ƙara lambobi biyu 4,41 kuma 4,34, amma yana da mahimmanci cewa guda ɗaya ne kawai bayan da aka nuna takaddama akan takardar. Bayan mun sanya tsarin dacewa na sel, adadin sun fara bayyana akan takardar. 4,4 kuma 4,3, amma idan aka kara da cewa, shirin baya nuna lambar a tantanin halitta a matsayin sakamakon 4,7da darajar 4,8.
Wannan shi ne daidai saboda gaskiyar cewa don lissafin Excel yana ci gaba da ɗaukar lambobi 4,41 kuma 4,34. Bayan lissafin, sakamakon shine 4,75. Amma, tun da mun saita tsarin don nuna lambobi tare da wuri ɗaya kawai, amma ana yin zagaye kuma an nuna lambar a cikin tantanin halitta 4,8. Saboda haka, yana haifar da bayyanar cewa shirin ya yi kuskure (ko da yake wannan ba haka bane). Amma a kan takardun buga takardar shaidar 4,4+4,3=8,8 zai zama kuskure. Saboda haka, a wannan yanayin, yana da mahimmanci don kunna daidaitattun wuri kamar yadda akan allon. Sa'an nan Excel zai lissafta ba tare da la'akari da lambobin da shirin ke riƙe a ƙwaƙwalwar ajiya ba, amma bisa ga dabi'u da aka nuna a cikin tantanin halitta.
Don gano ainihin adadin lambar da Excel ke ɗauka don ƙidaya, kana buƙatar zaɓin tantanin halitta inda yake kunshe. Bayan haka, ana nuna darajarsa a cikin ma'auni, wadda aka adana cikin ƙwaƙwalwar Excel.
Darasi: Lambobi masu tasowa Excel
Kunna daidaitattun saitunan kamar a allon a cikin sassan Excel
Yanzu bari mu gano yadda za a kunna daidaito kamar a kan allon. Na farko, la'akari da yadda za a yi haka a kan misalin Microsoft Excel 2010 da kuma sifofinta. Suna da wannan nau'in hada da haka. Kuma a koyaushe mun koyi yadda ake tafiyar da daidaito akan allo a Excel 2007 da Excel 2003.
- Matsa zuwa shafin "Fayil".
- A cikin taga wanda ya buɗe, danna maballin "Zabuka".
- An kaddamar da wani matakan sigogi na ƙarin. Matsar da shi zuwa sashe "Advanced"wanda sunansa yana cikin jerin a gefen hagu na taga.
- Bayan tafi zuwa sashen "Advanced" motsa zuwa gefen dama na taga, wanda aka saita saitunan daban-daban na shirin. Nemo wani sashi na saitunan "Lokacin da aka sake karanta wannan littafi". Saita alamar kusa da saiti "Saita daidaito akan allon".
- Bayan haka, akwatin maganganu ya bayyana, wanda ya nuna cewa za a rage adadin lissafi. Muna danna maɓallin "Ok".
Bayan haka, a Excel 2010 da daga baya, yanayin zai kunna. "on-allon daidaito".
Don musaki wannan yanayin, cire akwatin a cikin zaɓin zaɓi a kusa da saitunan. "Saita daidaito akan allon"sannan danna maballin "Ok" a kasan taga.
Kunna saitunan daidaito akan allon a Excel 2007 da Excel 2003
Yanzu bari mu dubi yadda aka canza yanayin daidai, kamar a allo a Excel 2007 da kuma a Excel 2003. Ko da yake waɗannan juzu'i sunyi la'akari da jinkirin, masu amfani da yawa suna amfani da su.
Da farko, la'akari da yadda zaka taimaka yanayin a Excel 2007.
- Danna kan alama na Microsoft Office a cikin kusurwar hagu na taga. A cikin jerin da aka bayyana, zaɓi abu "Zaɓuɓɓukan Talla".
- A cikin taga wanda ya buɗe, zaɓi abu "Advanced". A cikin ɓangaren dama na taga a cikin ƙungiyar saitunan "Lokacin da aka sake karanta wannan littafi" saita kaska kusa da saiti "Saita daidaito akan allon".
Yanayin ƙayyade kamar yadda allon zai kunna.
A cikin Excel 2003, hanya don tabbatar da yanayin da muke bukata ya bambanta fiye da haka.
- A cikin jerin kwance, danna kan abu "Sabis". A cikin jerin da ya buɗe, zaɓi matsayi "Zabuka".
- An kaddamar da matakan sigogi. A ciki, je shafin "Daidai". Kusa, saita saƙo kusa da abu "Gaskiya akan allon" kuma danna maballin "Ok" a kasan taga.
Kamar yadda kake gani, yana da sauƙi don saita yanayin daidaituwa akan allon a Excel, koda kuwa tsarin shirin. Babban abu shi ne don sanin ko za a fara wannan yanayin a cikin wani takamaiman yanayin ko a'a.
