Har ila yau, aikin Microsoft Excel yana aiki tare da lambobi. Lokacin yin rabo ko aiki tare da lambobin juzu'ai, shirin zai kare. Wannan ya faru ne, da farko, saboda gaskiyar cewa ana samun ƙarancin adadi na lamba, amma ba shi da sauƙin aiki da babban magana tare da wurare masu yawan gaske. Bugu da kari, akwai lambobi wadanda, a ka’ida, ba a cika zagaye suke ba. Amma a lokaci guda, daidaitaccen daidaitaccen daidaituwa zai iya haifar da babban kuskure a cikin yanayi inda ake buƙatar daidaituwa. Abin farin ciki, Microsoft Excel yana da ikon masu amfani don saita yadda lambobi ke zagaye.
Adana lambobi a ƙwaƙwalwar Excel
Duk lambobin da Microsoft Excel ke aiki da su sun kasu kashi daidai da na kimanin. Lambobi har zuwa rago 15 ana adana su a ƙwaƙwalwar, kuma ana nuna su har sai fitarwar da mai amfani da kansa ya nuna. Amma, a lokaci guda, ana yin duk lissafin gwargwadon bayanan da aka ajiye a ƙwaƙwalwar ajiya, kuma ba a nuna shi akan mai saka idanu ba.
Amfani da zagaye-zagaye, Microsoft Excel ya zubar da wasu wurare na wurare marasa kyau. Excel yana amfani da hanyar zagaye da aka karɓa baki ɗaya, lokacin da ƙasa da 5 ba ta zagaye ba, kuma mafi girma ko daidai yake da 5 ya tashi.
Zagaye tare da Bututun Ribbon
Hanya mafi sauki don sauya zagaye da lamba ita ce a zabi selula ko rukuni na sel, kuma yayin da a cikin "Gidan" shafin sai a latsa maɓallin "Bitara Bit" ko "Rage Bit" a kan kintinkiri. Duk waɗannan maɓallan suna cikin akwatin Lambar kayan aiki. A wannan yanayin, kawai lambar da aka nuna za a zagaye, amma don ƙididdigar, idan ya cancanta, to lambobi 15 lambobi zasu shiga.
Lokacin da ka danna maballin "Increara zurfin bit", yawan adadin wurare masu ƙididdigar adadinsu yana ƙaruwa ɗaya.
Lokacin da ka danna maballin "Rage zurfin kaɗan" adadin lambobi bayan an rage girman adadin adadin ɗaya.
Zagaye ta hanyar tantanin halitta
Hakanan zaka iya saita zagaye ta amfani da saitin tsarin tantanin halitta. Don yin wannan, zaɓi kewayon sel akan takardar, danna-dama, zaɓi zaɓi "Kwayoyin cuta" a menu wanda ya bayyana.
A cikin taga wanda zai buɗe, tsarin tsarin sel wanda kuke buƙatar zuwa shafin "Number". Idan tsarin bayanai ba lambobi bane, to dole ne a zabi tsarin lambobi, in ba haka ba bazaka iya daidaita zagaye ba. A tsakiyar ɓangaren window kusa da rubutun "Yawan adadin wuraren lamuni" muna kawai nuna tare da lambar adadin haruffa waɗanda muke so mu gani lokacin da muke zagaye. Bayan haka, danna maɓallin "Ok".
Tsarin daidaiton ƙididdiga
Idan a cikin lokuta na baya, sigogi da aka saita sun shafi kawai bayanan bayanan waje, kuma an yi amfani da ƙarin ƙididdigar alamu (har zuwa lambobi 15) a cikin lissafin, yanzu za mu gaya muku yadda za ku canza daidaito na lissafin.
Don yin wannan, je zuwa "Fayil" shafin. Na gaba, za mu matsa zuwa sashen "Sigogi".
Taga zabin na Excel yana buɗewa. A cikin wannan taga, je wa sashen "Ci gaba". Muna neman tsarin toshe-shiren da ake kira "Lokacin da ake karanta wannan littafin." Saitunan da ke wannan gefen sun shafi ba takarda ɗaya ba, amma ga littafin baki ɗaya, wato, ga duka fayil ɗin. Mun sanya kaska a gaban sigar "Sanya daidaito kamar yadda akan allo" siga. Danna maɓallin "Ok" da ke cikin ƙananan hagu na hagu na taga.
Yanzu, lokacin yin lissafin bayanai, za a yi la'akari da ƙimar da aka nuna akan allon, kuma ba wanda aka adana a ƙwaƙwalwar Excel ba. Saita lambar da aka nuna za a iya yin ta kowane ɗayan hanyoyi biyu, waɗanda muka yi magana game da sama.
Aikace-aikacen Aiki
Idan kuna son canza ƙimar zagaye lokacin yin lissafi dangane da ɗayan ko kuma ƙwayoyin da yawa, amma ba ku son rage ƙididdigar lissafin gaba ɗaya don takaddar, to a wannan yanayin, zai fi kyau kuyi amfani da damar da aikin ROUND yake bayarwa da kuma bambance bambancensa, da wasu abubuwan.
Daga cikin manyan ayyukan dake tsara kewaya, ya kamata a bayyani abubuwa masu zuwa:
- ROUND - zagaye har zuwa takamaiman adadin wurare, bisa ga ƙididdigar dokokin zagaye da aka karɓa;
- ROUND - zagaye-kusa zuwa lambar mafi kusa har masu saurin yanayi;
- ROUNDDOWN - zagaye-kusa zuwa lambar mafi kusa da masu saurin canji;
- ROUND - zagaye lamba tare da daidaitattun da aka bayar;
- OKRVVERH - zagaye lamba tare da daidaitaccen daidaitattun abubuwa;
- OKRVNIZ - yana sake saukar da lambar cikin girma tare da daidaiton da aka bayar;
- OTDB - zagaye bayanan zuwa lamba;
- EVEN - zagaye bayanai zuwa mafi kusa ko da lamba;
- Odd - zagaye zagaye na bayanai mafi kusa.
Don ayyukan ROUND, ROUND UP da ROUND DOWN, tsarin shigar da mai zuwa shine: "Suna na aikin (lamba; adadin rago). Wannan shine, idan, alal misali, kuna son zagaye lambar 2.56896 zuwa rago uku, sannan ayi amfani da aikin ROUND (2.56896; 3). Abinda aka fitar shine lambar 2.569.
Don ayyuka ROUND, OKRVVERH da OKRVNIZ ana amfani da tsarin mai zagaye mai zuwa: "Suna na aiki (lamba; daidaito)". Misali, don zagaye lamba 11 zuwa mafi kusa mafi yawa na 2, muna gabatar da aikin ROUND (11; 2). Fitowa shine lamba 12.
Ayyukan suna zaɓa, EVEN da Odd suna amfani da tsari mai zuwa: "Suna na aiki (lamba)". Domin tara lamba 17 zuwa mafi kusa koda, muna amfani da aikin NUMBER (17). Mun sami lamba 18.
Kuna iya shigar da aiki duka cikin tantanin halitta da kuma layin aikin, bayan an zaɓi ɗakin da zai kasance. Kowane aikin dole ne ya riga ya kasance da alamar "=".
Akwai wata hanyar wata hanya dabam don gabatar da ayyuka masu zagaye. Ya dace musamman don amfani idan akwai tebur tare da dabi'u waɗanda suke buƙatar juyawa zuwa lambobi masu zagaye a cikin keɓaɓɓen shafi.
Don yin wannan, je zuwa shafin "Kayan tsari". Danna maballin "Math". Na gaba, a cikin jerin da ke buɗe, zaɓi aikin da ake so, misali ROUND.
Bayan haka, taga muhawara na aiki yana buɗewa. A cikin filin "Number", zaku iya shigar da lambar da hannu, amma idan muna son zagaye bayanan teburin ta atomatik, sannan danna maɓallin a hannun dama na taga shigarwa.
Argumentan taga gardamar aikin ta rage. Yanzu muna buƙatar danna kan saman sel ɗin wanda bayanan da zamu zagaye. Bayan an shigar da ƙimar a cikin taga, danna maɓallin zuwa dama na wannan ƙimar.
Farashin muhawara na aiki ya sake budewa. A fagen "Yawan lambobi" muna rubuta zurfin kaɗan, wanda muke buƙatar rage rafuffuka. Bayan haka, danna maɓallin "Ok".
Kamar yadda kake gani, lambar tana zagaye. Domin kewaye sauran bayanan bayanan shafin da ake so ta hanyar, matsar da siginan kwamfuta zuwa ƙananan kusurwar dama na sel tare da ƙimar zagaye, danna maɓallin linzamin kwamfuta na hagu, da kuma ja shi zuwa ƙarshen tebur.
Bayan haka, duk dabi'u a cikin abin da ake so za a kewaye.
Kamar yadda kake gani, akwai manyan hanyoyi guda biyu don zagaye bayyanar da lamba wacce ake amfani da ita: amfani da maballin akan kintinkiri, da kuma canza sigogin tsarin sel. Bugu da kari, zaku iya canza zagaye data ainihin lissafin. Hakanan za'a iya yin wannan ta hanyoyi guda biyu: ta canza saitunan littafin gaba ɗaya, ko ta amfani da ayyuka na musamman. Zabi wani takamaiman hanya ya dogara da ko kuna niyyar aiwatar da wannan nau'in zagaye don duk bayanan da ke cikin fayil, ko don takaddar sel kawai.
