Excel yana faranta wa masu amfani da shi da kayan aiki da ayyuka masu amfani da yawa. Daya daga cikin wadannan babu shakka Zaɓin siga. Wannan kayan aiki yana ba ku damar nemo ƙimar farko bisa ƙimar ƙarshe da kuke shirin karɓa. Bari mu ga yadda ake aiki tare da wannan aikin a cikin Excel.
Content
Me yasa ake buƙatar aikin
Kamar yadda aka ambata a sama, aikin aikin Zaɓin siga ya ƙunshi nemo ƙima na farko wanda za a iya samun sakamako na ƙarshe da aka bayar. Gabaɗaya, wannan aikin yana kama da Neman Magani (zaka iya karanta shi daki-daki a cikin labarinmu -), duk da haka, ya fi sauƙi.
Kuna iya amfani da aikin a cikin ƙididdiga guda ɗaya kawai, kuma idan kuna buƙatar yin lissafi a wasu sel, dole ne ku sake yin duk ayyukan a cikinsu. Hakanan, aikin yana iyakance ta adadin bayanan da ake sarrafawa - ƙima ɗaya na farko da na ƙarshe kawai.
Amfani da aikin
Bari mu ci gaba zuwa misali mai amfani wanda zai ba ku mafi kyawun fahimtar yadda aikin yake aiki.
Don haka, muna da tebur tare da jerin kayan wasanni. Mun san adadin rangwame kawai (560 rub. don matsayi na farko) da girmansa, wanda yake daidai da kowane abu. Dole ne ku nemo cikakken farashin kayan. A lokaci guda kuma, yana da mahimmanci cewa a cikin tantanin halitta, wanda daga baya zai nuna adadin rangwame, an rubuta ma'anar lissafinta (a cikin yanayinmu, ninka yawan adadin ta hanyar girman rangwame).
Don haka, algorithm na ayyuka shine kamar haka:
- Jeka shafin "Bayanai"wanda muke danna maballin "Idan" bincike a cikin rukunin kayan aiki "Hanta"… A cikin jerin zaɓuka, zaɓi "Zabin ma'auni" (a cikin sigogin farko, maɓallin yana iya kasancewa a cikin rukuni "Aiki tare da data").
- Wani taga zai bayyana akan allon don zaɓar ma'aunin da ake buƙatar cikawa:
- a darajar filin "Saita cikin cell" muna rubuta adireshin tare da bayanan ƙarshe waɗanda muka sani, watau wannan ita ce tantanin halitta mai rangwamen kuɗi. Maimakon shigar da haɗin kai da hannu, zaku iya danna kan tantanin halitta da ake so a cikin teburin kanta. A wannan yanayin, siginan kwamfuta ya kamata ya kasance a cikin filin da ya dace don shigar da bayanai.
- A matsayin darajar, muna nuna adadin rangwamen, wanda muka sani - 560 rub.
- a cikin "Canza darajar tantanin halitta" da hannu ko ta danna tare da linzamin kwamfuta, saka madaidaicin tantanin halitta (ya kamata ya shiga cikin dabara don ƙididdige adadin ragi), wanda muke shirin nuna ƙimar farko.
- danna lokacin da aka shirya OK.
- Shirin zai yi lissafin kuma ya nuna sakamakon a cikin ƙaramin taga wanda za'a iya rufe ta danna maɓallin. OK. Hakanan, ƙimar da aka samo za ta bayyana ta atomatik a cikin ƙayyadadden sel na tebur.
- Hakazalika, za mu iya ƙididdige farashin da ba a rangwame ga sauran samfuran idan mun san ainihin adadin rangwamen ga kowane ɗayan su.
Magance Daidaituwa Ta Amfani da Zaɓin Siga
Duk da cewa wannan ba shine babban jagorar yin amfani da aikin ba, a wasu lokuta, idan yazo ga wanda ba a san shi ba, yana iya taimakawa wajen warware daidaito.
Misali, muna buƙatar warware lissafin: 7x+17x-9x=75.
- Muna rubuta magana a cikin tantanin halitta kyauta, mu maye gurbin alamar x zuwa adireshin tantanin halitta wanda kimarsa kuke son samu. A sakamakon haka, dabarar ta kasance kamar haka:
=7*D2+17*D2-9*D2. - Danna Shigar kuma sami sakamakon a matsayin lamba 0, wanda yana da ma'ana sosai, tunda kawai dole ne mu ƙididdige ƙimar tantanin halitta D2, wanda shine "x" a cikin lissafin mu.
- Kamar yadda aka bayyana a sashe na farko na labarin, a cikin shafin "Bayanai" tura maɓallin "Idan" bincike kuma zaɓi "Zabin ma'auni".
- A cikin taga da ya bayyana, cika sigogi:
- A cikin darajar filin "Saita cikin cell" nuna daidaitawar tantanin halitta wanda a cikinsa muka rubuta lissafin (watau B4).
- A cikin darajar, bisa ga lissafin, muna rubuta lambar 75.
- a cikin "Canza Ƙimar Halitta" saka madaidaitan tantanin halitta wanda kimarsa kuke son samu. A wurinmu, wannan shine D2.
- Lokacin da komai ya shirya, danna OK.
- Kamar yadda a cikin misalin da aka tattauna a sama, za a yi lissafi kuma za a sami sakamakon, kamar yadda wata karamar taga ta nuna.
- Don haka, mun sami nasarar warware lissafin kuma sami darajar x, wanda ya zama 5.
Kammalawa
Daidaitawa aiki ne wanda zai iya taimaka maka nemo lambar da ba a sani ba a cikin tebur, ko ma warware ma'auni tare da wanda ba a sani ba. Babban abu shi ne ya mallaki basirar yin amfani da wannan kayan aiki, sa'an nan kuma zai zama mataimaki mai mahimmanci a yayin aiwatar da ayyuka daban-daban.