Kyakkyawan fasalin da ke da kyau a cikin Microsoft Excel shine Tsarin Musanya. Amma, ba kowane mai amfani da ke da masaniya game da damar wannan kayan aikin ba. Tare da taimakonsa, yana yiwuwa a zaɓi ƙimar farko, farawa daga sakamako na ƙarshe waɗanda ke buƙatar cimma. Bari mu bincika yadda zaku iya amfani da aikin daidaita sigogi a Microsoft Excel.
Mahimmin aikin
Idan yana da sauƙi a yi magana game da mahimmin aikin Sifin zaɓi, to, ya ƙunshi gaskiyar cewa mai amfani zai iya ƙididdige mahimmancin bayanan farko don cimma sakamako na musamman. Wannan fasalin yana kama da kayan aikin mai neman mafita, amma shine mafi sauƙin zaɓi. Ana iya amfani dashi a cikin jumloli guda ɗaya, wato, yin ƙididdigewa a cikin kowane ƙwayar mutum, kuna buƙatar sake kunna wannan kayan aiki kowane lokaci. Bugu da ƙari, aikin zaɓin sigogi na iya aiki tare da shigarwar guda ɗaya da ƙimar guda ɗaya da ake so, wanda ke magana akan shi azaman kayan aiki tare da iyakantaccen aiki.
Sanya aikin a aikace
Don fahimtar yadda wannan aikin yake aiki, zai fi kyau a faɗi ainihin jigonsa tare da misali mai amfani. Zamuyi bayanin aikin kayan aiki ta amfani da misalin Microsoft Excel 2010, amma algorithm na ayyuka kusan iri daya ne a duka sigogin wannan shirin da kuma na 2007.
Muna da tebur na albashi da kuma biyan kuɗi ga ma'aikata. Kawai albarkar ma'aikaci ake sani. Misali, darajan ɗayansu - Nikolaev A. D, shine 6035.68 rubles. Hakanan an san cewa ana ƙididdige ƙimar ta hanyar ninka yawan albashi ta hanyar 0.28. Dole ne mu nemo Hakkin ma'aikata.
Don fara aikin, kasancewa a cikin "Data" tab, danna maɓallin "Idan if", wanda ke cikin "Yi aiki tare da Bayani" kayan aiki akan kintinkiri. .
Bayan haka, taga zaɓi na buɗewa. A cikin filin "Sanya a cikin tantanin halitta", kuna buƙatar tantance adireshin sa wanda ya ƙunshi bayanan ƙarshe da aka sani gare mu, wanda zamu tsara ƙididdigar. A wannan yanayin, wannan ita ce sel inda aka saita kyautar ma'aikaci Nikolaev. Za'a iya tantance adireshin da hannu ta hanyar fitar da abubuwan sarrafa shi a filin da ya dace. Idan kun yi asara yin wannan, ko kuma ba shi da wahala, kawai danna kan wayar da ake so kuma adireshin zai shiga.
A cikin filin "Darajar" dole ne a ƙayyade takamaiman darajar ƙimar. A cikin lamarinmu, zai kasance 6035.68. A fagen "Canza dabi'un tantanin halitta" muna shigar da adireshinsa dauke da bayanan tushen da muke buƙatar lissafta, wato adadin albashin ma'aikaci. Ana iya yin wannan ta hanyoyi guda ɗaya waɗanda muka yi magana game da su a sama: fitar da masu gudanarwa da hannu, ko danna kan komputa mai dacewa.
Lokacin da duk bayanan akwatin taga sun cika, danna maɓallin "Ok".
Bayan wannan, ana yin lissafin, kuma abubuwan da aka zaɓa sun dace cikin sel, kamar yadda taga bayani na musamman ya ruwaito.
Ana iya yin irin wannan aiki ga sauran layuka na teburin, idan an san ƙimar kuɗin sauran ma'aikata na kamfani.
Maganin daidaitawa
Bugu da kari, dukda cewa wannan ba fasali bane na tsarin wannan aikin, ana iya amfani dashi don magance daidaituwa. Gaskiya ne, za'a iya amfani da kayan aikin zaɓi kawai cikin nasara dangane da daidaituwa tare da wanda ba'a sani ba.
A ce muna da daidaituwa: 15x + 18x = 46. Mun rubuta gefen hagunsa, a matsayin tsari, a ɗayan sel. Kamar yadda yake tare da kowane dabara a cikin Excel, mun sanya alamar = a gaban daidaitawa. Amma, a lokaci guda, maimakon alamar x mun saita adireshin tantanin halitta inda sakamakon ƙimar da ake so za'a nuna.
A cikin yanayinmu, muna rubuta dabara a C2, kuma ƙimar da ake so za a nuna a B2. Don haka, shigarwar a cikin sel C2 zai sami tsari mai zuwa: "= 15 * B2 + 18 * B2".
Mun fara aikin daidai kamar yadda aka bayyana a sama, wato, ta danna maɓallin "Bincike", menene "a kan tef", da kuma danna kan "Maɓallin Haraji ...".
A cikin taga don zaɓar sigogi wanda zai buɗe, a cikin filin "Set a cikin tantanin halitta", saka adireshin da muka rubuta daidaito (C2). A fagen "Darajar" mun shiga lamba 45, tunda mun tuna cewa ma'auni yayi kama da haka: 15x + 18x = 46. A fagen "Canza ƙimar tantanin halitta" muna nuna adireshin da za'a nuna ƙimar x, wato, a zahiri, mafita daidaituwa (B2). Bayan mun shigar da wannan bayanan, danna maballin "Ok".
Kamar yadda kake gani, Microsoft Excel ya samu nasarar daidaita lissafin. Darajar x zata kasance 1.39 a lokacin.
Bayan bincika kayan aikin zaɓi na Parameter, mun gano cewa wannan abu ne mai sauƙi, amma a lokaci guda yana da amfani da aiki mai dacewa don nemo lambar da ba a sani ba. Ana iya amfani dashi duka don lissafin tabular, da kuma magance daidaitawa tare da wanda ba'a sani ba. A lokaci guda, cikin sharuddan ayyuka, yana da ƙasa da kayan aikin bincike mafi ƙarfi.
