Wani fasali mai mahimmanci a cikin Microsoft Excel shine zaɓi na zabin. Amma, ba kowane mai amfani san game da damar wannan kayan aiki ba. Tare da shi, zaka iya karɓar darajar asali, fara daga sakamakon karshe da kake so ka cimma. Bari mu ga yadda zaka iya amfani da aikin zaɓin saiti a cikin Microsoft Excel.
Dalilin aikin
Idan yana da sauƙi don magana game da ainihin aikin Zaɓin fasalin, to, shi ke cikin gaskiyar cewa mai amfani zai iya ƙididdige bayanan shigar da ya dace don cimma wani sakamako na musamman. Wannan fasali yana kama da Magani Mai Neman Magani, amma shine mafi sauki. Ana iya amfani dashi a cikin takamammen tsari guda ɗaya, wato, don ƙididdiga a kowane tantanin halitta, kana buƙatar gudu wannan kayan aiki a kowane lokaci. Bugu da ƙari, aikin zaɓin zabin yanayi zai iya aiki tare da ɗaya shigarwar, da ɗayan da ake so, wanda yake nufin shi a matsayin kayan aiki tare da iyakacin aiki.
Aikace-aikacen aikin a aiki
Don fahimtar yadda wannan aikin yake aiki, ya fi kyau ya bayyana ainihin ainihin abin da ya dace. Za mu bayyana aikin kayan aiki a kan misalin Microsoft Excel 2010, amma algorithm na ayyuka ya kusan kusan a cikin sassan karshe na wannan shirin kuma a cikin 2007 version.
Muna da tebur na biya biya da kari ga ma'aikatan kamfanin. Abokan ƙwarewar ma'aikata ne kawai aka sani. Misali, kyautar daya daga cikin su, Nikolaev A. D, tana da 6,035.68 rubles. Bugu da ƙari, an san cewa an ƙaddara mafi yawan kuɗi ta hanyar ninka albashi da kashi 0.28. Dole ne mu sami sakamakon ma'aikata.
Domin fara aikin, kasancewa a cikin "Data" tab, danna "Yi nazari" idan "button, wanda yake a cikin" Yin aiki tare da Data "kayan aiki a kan rubutun.Kayan menu ya bayyana inda kake buƙatar zaɓar" Zaɓin zaɓi ... " .
Bayan haka, maɓallin zaɓi na maɓallin ya buɗe. A cikin filin "Sanya cikin tantanin salula" kana buƙatar saka adireshinsa, wanda ya ƙunshi bayanan karshe da aka sani da mu, wanda za mu daidaita lissafi. A wannan yanayin, shi ne tantanin halitta inda aka kafa lambar yabo na ma'aikacin Nikolaev. Adireshin za a iya ƙayyade ta hannu ta hanyar buga ɗawainiyarsa a filin da ya dace. Idan kuna da wuyar yin wannan, ko kuma la'akari da shi maras kyau, to, ku danna kan tantanin da ake son, kuma adireshin zai shiga cikin filin.
A cikin "Darajar" filin dole ne ku ƙayyade takamaiman lambar yabo. A halinmu, zai zama 6035.68. A cikin "Canjin Canjin dabi'u", shigar da adireshin da ya ƙunshi bayanan farko da muke bukata mu ƙididdige, wato, yawan adadin ma'aikaci. Ana iya yin wannan a cikin hanyar da muka yi magana game da sama: da hannu shigar da haɗin kai, ko danna kan tantanin salula.
Lokacin da duk bayanai a cikin matakan sigogi sun cika, danna kan maballin "OK".
Bayan haka, an yi lissafi, kuma dabi'un da aka zaɓa sun shiga cikin sel, wanda aka ruwaito ta hanyar bayani na musamman.
Za a iya yin irin wannan aikin don wasu layuka na tebur, idan an san darajar yawan ma'aikatan da suka rage.
Daidaita ƙimar
Bugu da ƙari, ko da yake ba ainihin siffar wannan aikin ba, ana iya amfani dasu don magance matakan. Duk da haka, ana iya amfani da kayan zaɓin saiti kawai don amfani da daidaituwa tare da wanda ba a sani ba.
Da za a ce muna da matakan: 15x + 18x = 46. Rubuta gefen hagu, a matsayin maƙirari, a ɗaya daga cikin sel. Amma ga kowane maƙala a Excel, kafin daidaitawar sa alamar "=". Amma, a lokaci guda, maimakon alamar x, mun saita adireshin tantanin halitta inda sakamakon sakamakon da ake so shine zai fito.
A cikin yanayinmu, zamu rubuta dabarar a C2, kuma farashin da ake bukata za a nuna a B2. Saboda haka, shigarwa cikin tantanin halitta C2 zai sami nau'i mai zuwa: "= 15 * B2 + 18 * B2".
Mun fara aiki a daidai wannan hanya kamar yadda aka bayyana a sama, wato, ta danna kan "Analysis" button, idan "a kan tef", kuma danna kan abu "Zaɓin saitin ...".
A cikin maɓallin zaɓi da aka buɗe, a cikin filin "Saita a cikin tantanin halitta" muna nuna adireshin da muka rubuta jigilar (C2). A cikin filin "Darajar" mun shigar da lambar 45, tun da mun tuna cewa ƙidayar yana kama da wannan: 15x + 18x = 46. A cikin "Canjin Canjin dabi'u" filin, muna nuna adireshin inda zamanin x zai zama fitarwa, wato, a hakika, mafita na daidaitawa (B2). Bayan mun shiga wannan bayanan, danna kan maballin "OK".
Kamar yadda kake gani, Microsoft Excel samu nasarar warware matsalar. Matsayin x zai zama daidai da 1.39 a cikin lokaci.
Bayan nazarin kayan zaɓin zaɓi, za mu gane cewa wannan abu ne mai sauƙi, amma a lokaci ɗaya da amfani da kuma dace don neman lambar da ba a sani ba. Za a iya amfani dashi duka don lissafin lissafi, da kuma don daidaita daidaito tare da wanda ba'a sani ba. A lokaci guda, dangane da ayyukan, ba shi da ƙari ga ƙarin kayan aiki na Magani don Magani.
