Koyon yadda ake samun cikakkiyar ƙima a cikin Excel na iya zama da amfani sosai, musamman idan kun kasance ɗaya daga cikin mutanen da suke yawan amfani da irin wannan fayil ɗin don yin lissafin lissafi. Excel yana daya daga cikin kayan aikin a halin yanzu ana amfani da su don ƙididdiga, zane-zane da nazarin kasuwanci.
Don haka mahimmancin koyan yadda zaku iya ƙididdige cikakkiyar ƙima a cikin wannan shirin don haka ku sami damar adana kanku hanyoyin da yawa waɗanda kuke saba yi da hannu.
A cikin wannan labarin za mu bayyana abin da yake game da shi cikakken darajar Excel da yadda zaku iya samu bin wasu matakai.
Menene cikakkiyar ƙima a cikin Excel game da?
Abu na farko da ya kamata ku sani shine, a cikin Excel, cikakkiyar ƙimar ita ce wanda ba ya bambanta a cikin tsari, ba tare da la'akari da cewa tantanin halitta da aka sanya a ciki ba ya kasance daidai da sauran. Wannan yana da amfani a lokacin da kuke so amfani da takamaiman ƙima don lissafin daban-daban a cikin takardar Excel.
Idan kuna son yin amfani da wannan aikin Excel, kawai ku yi ƙara alamar $ kafin harafi da lambar tantanin halitta za ku yi nuni a cikin dabarar. Idan lamarin shine ka zaɓi cell B3, dole ne ka rubuta $B$3.
Koyaya, idan kuna son ƙididdige cikakkiyar ƙimar ainihin lamba a cikin Excel, dole ne ku amfani da aikin ABS na cewa shirin. Amfanin wannan aikin shine zaku iya amfani dashi don ayyukan lissafin lissafi wanda kawai kuna sha'awar aiki tare da ingantaccen ƙimar lamba ko sakamako.
A wasu kalmomi, idan kuna son ƙididdige cikakkiyar ƙimar bayanai a cikin Excel, kuna buƙatar amfani da aikin ABS na wannan shirin.
Menene aikin ABS a cikin Excel?
Ayyukan ABS na ɗaya daga cikin dabaru excel math, amma kuma yana ɗaya daga cikin mafi ƙarancin rikitarwa don amfani. Kamar yadda muka riga muka nuna, tare da shi zaku iya ƙididdige cikakkiyar ƙimar ainihin lamba a cikin ma'auni na Excel.
Yana da muhimmanci cewa fahimtar ma'anar aikin ABS, domin ku iya amfani da shi zuwa lissafin daban-daban da kuke son yi. Rubutun da dole ne ka yi amfani da su a cikin takardar Excel shine: ABS(Lambar).
A wannan yanayin, ABS yana gaya wa shirin aikin da kuke son amfani da shi a cikin tantanin halitta da ke rubuta shi. Sashen lamba, dole ne ka rubuta ainihin lambar ko kuma tantanin halitta wanda lambar da kake son ganin cikakkiyar darajarsa take.
Matakan da zaku iya bi don sanin yadda ake samun cikakkiyar ƙima a cikin Excel
Kamar yadda muka riga muka fada muku, koyon yadda ake samun cikakkiyar ƙima a cikin Excel yana da matukar amfani, musamman lokacin da kuke shirin yin lissafin. ba za a iya ɗauka mara kyau ba la'akari. Ga wasu matakai da zaku iya bi don yin amfani da aikin ABS.
- Abu na farko da yakamata kayi shine bude takardar Excel kuma duba bayanan da kuke so don samun cikakkiyar ƙimar. Ana ba da shawarar cewa tsara bayanai ta teburi, don sauƙin lissafi.
- Da zarar ka zaɓi cell ɗin da kake son amfani da cikakkiyar ƙimar, kawai sai ka rubuta a cikin tantanin halitta mai zuwa "= ABS (lamba ko tantanin halitta)".
- Ta yin haka za ku lura da hakan munanan dabi'u sun zama tabbatacce kuma wannan shine yadda zaku ga cewa cikakken aikin ƙimar yana aiki.
Waɗannan su ne matakai mafi sauƙi don ku iya amfani da aikin ABS a cikin kowane tebur ko lissafin da kuke yi.
Matakai don sanin yadda ake samun cikakkiyar ƙima a cikin Excel ta amfani da menu ɗin sa
Kodayake mun riga mun ba ku matakan da za ku bi kan yadda ake samun cikakkiyar ƙimar lamba a cikin Excel. Duk da haka, akwai sauran matakan da zaku iya bi don haka yi amfani da wannan aikin. Bayan haka, za mu gaya muku menene su:
- Abu na farko da yakamata kayi shine bude Excel fayil kuma zaɓi wane tantanin halitta ko sel da kuke son nuna cikakkiyar ƙimar lambar.
- Da zarar a cikin tantanin halitta, dole ne ku zaɓi sashin "Formulas"
- Da zarar a cikin sassan dabara, kuna buƙatar zaɓar zaɓi "Saka aiki".
- Danna kan wannan yana buɗe menu inda aka nemi ka rubuta bayanin aikin da kake nema. A wannan yanayin, zaka iya amfani da "ABS".
- Lokacin da shirin ya samo ABS aiki dole ne ka danna shi kuma danna karɓa.
- Yin haka yana nuna sabon menu mai suna "muhawarar aiki” kuma a ciki zaku ga sabon sashe mai suna “Lambar".
- A cikin sashin lamba, dole ne ka shigar da tantanin halitta ko lambar da kake son samun cikakkiyar ƙimar ta.
- Ta hanyar shiga tantanin halitta da latsawa karɓa, za ku lura da yadda lambar da a baya ba ta da kyau ta zama tabbatacce. Wato, kuna duban cikakkiyar ƙimar wannan lambar ko lissafin riba.
Misali wanda sanin yadda ake samun cikakkiyar ƙima a cikin excel zai iya zama da amfani
A cikin hoton mun nuna muku misali na aikin ABS a cikin Excel, kamar yadda kuke iya gani akwai dabi'u don rukunin "X"da wasu ƙididdiga don" shafiY". A shafi na gaba lissafin Babban darajar XY, amma tun da kimar ginshiƙin "X" bai kai darajar ginshiƙin "Y", za ku sami ƙima mara kyau.
Koyaya, lokacin amfani da aikin ABS kamar yadda muka bayyana a cikin matakan da suka gabata, zaku lura cewa lambobin suna tafiya daga korau zuwa tabbatacce. Wanda ke nufin cewa kuna kallon cikakkiyar ƙimar sakamakon rage ƙimar X tare da na Y.
Este yana daya daga cikin mafi sauki lokuta a cikin abin da zaku iya amfani da cikakken aikin lokacin yin lissafi a cikin takardar Excel.
Ko dai yi amfani da matakan bisa ƙa'ida ko kuma kawai rubuta aikin ABS kai tsaye a cikin tantanin halitta. za ku iya samu cikakken darajar duk lissafin ko lambobin da kuke so a cikin takardar ku na Excel muddin kuna bin matakan da muka ba ku a cikin wannan labarin.