Kullin yana da cikakkiyar darajar kowane lamba. Har ila yau ko da lambar maɓallin za ta kasance da kyakkyawan tsari. Bari mu gano yadda za a tantance darajar ɗayan a cikin Microsoft Excel.
Abubuwan ABS
Don ƙididdige darajar ɗayan a cikin Excel, akwai aikin musamman wanda ake kira ABS. Rigar wannan aikin yana da sauqi: "ABS (lambar)". Ko kuma, ƙirar zata iya ɗauka "ABS (adireshin salula da lambar)".
Domin yin lissafi, alal misali, ƙirar daga lambar -8, kuna buƙatar fitar da su a cikin takaddun tsari ko a cikin kowane tantanin halitta a kan takardar, hanyar da ake biyowa: "= ABS (-8)".
Don lissafta, latsa maɓallin ENTER. Kamar yadda kake gani, shirin yana amsawa tare da darajar darajar lamba 8.
Akwai wata hanyar da za a lissafta wannan matsala. Ya dace wa masu amfani waɗanda ba su saba da su don tunawa da ƙididdiga dabam dabam ba. Mun danna kan tantanin salula wanda muke so a adana sakamakon. Danna kan maballin "Saka aiki", a gefen hagu na tsari.
Wizard na Ɗawainiya ya fara. A cikin jerin, wanda aka samo a ciki, kana buƙatar samun aikin ABS, kuma zaɓi shi. Sa'an nan kuma danna maballin "OK".
Ƙungiyar shawara ta buɗewa ta buɗe. Ayyukan ABS ba su da hujja daya kawai - lamba. Mun shigar da shi. Idan kana so ka dauki lamba daga bayanan da aka adana a cikin tantanin salula, sannan ka latsa maɓallin da ke gefen dama na takardar shigarwa.
Bayan haka, an rage girman taga, kuma kana buƙatar danna kan tantanin halitta dauke da lambar daga abin da kake so ka lissafta wannan tsari. Bayan an ƙara lambar, sake danna maballin dama zuwa filin shigar.
An sake sake gilashi tare da bayanan aikin. Kamar yadda kake gani, filin "Lambar" ya cika da darajar. Danna maballin "OK".
Bayan haka, ana nuna adadin lambar da aka zaɓa a cikin tantanin da ka ƙayyade a baya.
Idan tamanin yana cikin teburin, to za'a iya kofe wannan tsari akan wasu ƙwayoyin. Don yin wannan, kana buƙatar ka tsaya a kan kusurwar hagu na tantanin halitta, wanda akwai rigakafi, riƙe ƙasa da maɓallin linzamin kwamfuta kuma jawo shi zuwa ƙarshen tebur. Saboda haka, a cikin wannan shafi, darajar modulo bayanin asalin bayanan zai bayyana a cikin sel.
Yana da muhimmanci a lura cewa wasu masu amfani suna kokarin rubuta wani tsari, kamar yadda ya saba a lissafin lissafi, wato, | (lambar) |, misali | -48 |. Amma, a mayar da martani, suna da kuskure, saboda Excel ba ya fahimci wannan haɗin.
Kamar yadda kake gani, babu wani abu mai wuyar ganewa a lissafin wani ƙwayar daga wani lamba a cikin Microsoft Excel, tun da wannan aikin ya yi ta amfani da aiki mai sauƙi. Abinda ya dace shi ne cewa kawai kana bukatar sanin wannan aikin.
