Aikin Kasuwancin Are Excel

A module cikakken darajar daraja na kowane lamba. Ko da a lambar mara kyau, ko koyaushe module zai zama tabbatacce. Bari mu gano yadda ake kirga girman module a Microsoft Excel.

Sifar

Don lissafin girman module a Excel, akwai wani fasali na musamman da ake kira "Abs". Syntax na wannan aikin yana da sauqi qwarai: Abs (lamba). Ko dai dabara na iya ɗaukar wannan nau'in: Abs (adireshin (adireshin_children_s_ch). Don yin lissafi, alal misali, module daga lamba -8, kuna buƙatar tuƙi cikin tsarin kirtani ko kuma kowane sel a jerin dabaru: "= Abs (-8)".

Don aiwatar da lissafin, latsa kan shigar - shirin ya ba da cikakken darajar a amsa.

Akwai wata hanya don yin lissafin module. Ya dace da waɗancan masu amfani waɗanda ba su saba da ci gaba da tsari daban-daban a kai ba.

1. Danna kan tantanin halitta wanda muke son ci gaba da sakamakon. Latsa maɓallin "Saka bayanai", sanya shi a gefen hagu na kirtani.



2. "Ayyukan" Wizard na Wizard "suna farawa. A cikin jeri, wanda yake a ciki, sami Abs fasali kuma zaɓi shi. Na tabbatar da lafiya.



3. Ayyukan muhawara sun buɗe. Abs yana da hujja guda ɗaya kawai - lamba, don haka muke gabatar da shi. Idan kana son ɗaukar lamba daga bayanan da aka adana a cikin kowane kwayar daga cikin daftarin aiki, danna maɓallin an sanya shi a hannun dama na shigarwar shigarwar.



4. Tagar za ta zo, kuma kuna buƙatar danna kan tantanin halitta, inda mutum ya ƙunshi lambar daga abin da kake son yin lissafin module. Bayan ƙara shi kuma, danna maballin zuwa dama ga filin shigarwar.



5. Apess taga tare da gardama na aikin, inda "lambar" za ta riga ta cika da darajar. Danna Ok.



6. Biyo wannan, ƙimar medule na lamba da aka zaɓa yana nuna a cikin sel da ka zaɓa.



7. Idan darajar tana cikin tebur, za a iya kwafa dabara ta a cikin sel. Don yin wannan, kuna buƙatar kawo siginan ƙananan kusurwar hagu na tantanin halitta, wanda akwai tsari, maɓallin linzamin kwamfuta kuma ku kashe shi har zuwa ƙarshen tebur. Saboda haka, a cikin sel na wannan shafi Akwai zai zama darajar kayan aikin tushen tushen.

Yana da mahimmanci a lura cewa wasu masu amfani suna ƙoƙarin yin rikodin tsarin, kamar yadda al'ada ce a cikin lissafi, wannan shine | (Lambar) | , misali | -48 | . Amma a cikin irin wannan yanayin, kawai kuskure ne kawai zai bayyana maimakon amsa, tunda Excel ba ya fahimtar irin wannan syntax.

A cikin lissafin module daga lambar ta lambar ta Microsoft Excel, babu wani abu mai rikitarwa, tunda an yi wannan aikin ta amfani da aiki mai sauƙi. Kawai yanayin shine wannan fasalin kawai kuna buƙatar sani.