Matsakaici cikakke ne mai mahimmanci na kowane lamba. Ko da lamba mara kyau koyaushe zai sami ingantaccen abu. Bari mu bincika yadda ake yin lissafin girman module a Microsoft Excel.
Aikin ABS
Akwai aiki na musamman da ake kira ABS don ƙididdige girman module a cikin Excel. Ginin kalma na wannan aikin yana da sauqi: "ABS (lamba)". Ko kuma, dabara yana iya ɗaukar fom "ABS (cell_address_with_number)".
Don yin lissafi, alal misali, modulus na lamba -8, kuna buƙatar tuka cikin layin ƙira ko a cikin kowane sel akan takardar, ƙirar mai zuwa: "= ABS (-8)".
Don yin lissafi, danna maɓallin ENTER. Kamar yadda kake gani, shirin yana amsawa tare da ingantacciyar darajar lambar 8.
Akwai wata hanyar yin lissafin injin. Ya dace wa waɗancan masu amfani waɗanda ba a amfani da su don su saka dabaru iri-iri a cikin kawunansu. Mun danna kan tantanin da muke so a adana sakamakon. Danna maɓallin "Saka aikin" da ke gefen hagu na masarar dabara.
Ana fara kunna Wurin Aiki. A cikin jerin abubuwanda ke ciki, kuna buƙatar nemo aikin ABS, kuma ku haskaka shi. Sannan danna maballin "Ok".
Farashin muhawara na aiki zai bude. Aiki na ABS yana da hujja ɗaya kawai - lamba. Muna gabatar da shi. Idan kana son ɗaukar lamba daga bayanan da aka adana a cikin kowane sel na takaddar, to danna kan maɓallin da ke gefen dama na shigarwar shigarwar.
Bayan haka, taga an rage girman, kuma kuna buƙatar danna kan tantanin da ke ɗauke da lamba daga abin da kuke so ku lissafa koyaushe. Bayan an ƙara lamba, sake danna maɓallin zuwa dama na filin shigarwar.
Tagan tare da muhawara na aiki ya fara sakewa. Kamar yadda kake gani, filin Lambar yana cike da ƙima. Latsa maɓallin "Ok".
Ana bin wannan, a cikin tantanin da aka nuna a baya, ana nuna ƙimar lambar lambar da aka zaɓa.
Idan darajar ta kasance a cikin tebur, to za a iya kwafa dabarar kwafin zuwa wasu ƙwayoyin. Don yin wannan, kuna buƙatar tsayawa a ƙasan hagu na ƙwallon ƙwayar sel a cikin abin da ya rigaya ya sami tsari, riƙe maɓallin linzamin kwamfuta, kuma ja shi zuwa ƙarshen tebur. Saboda haka, a cikin wannan shafi a cikin sel ƙimar modulo tushen bayanan zai bayyana.
Yana da mahimmanci a lura cewa wasu masu amfani sunyi ƙoƙarin rubuta sutura, kamar yadda aka saba a lissafi, watau: (lamba) |, misali | -48 |. Amma, a cikin martani, sun sami kuskure, saboda Excel ba ta fahimci wannan fassarar ba.
Kamar yadda kake gani, babu wani abu mai rikitarwa a lissafin injin daga lamba a Microsoft Excel, tunda ana yin wannan aikin ta amfani da aiki mai sauƙi. Kawai yanayin shine kawai buƙatar sanin wannan aikin.
