Daya daga cikin fasali mai ban sha'awa a cikin shirin Microsoft Excel shine neman mafita. A lokaci guda, ya kamata a lura cewa ba za a iya danganta wannan kayan aiki ba ga mashahuri a tsakanin waɗannan aikace-aikacen. Kuma a banza. Bayan haka, wannan fasalin, ta amfani da bayanan farko, ta hanyar lalacewa, sami mafi kyawun maganin mafi kyau daga duka akwai. Bari mu gano yadda ake amfani da fasalin mafita bayani a Microsoft Excel.
Sanya Aiki
Kuna iya nemo dogon lokaci akan kintinkiri, inda mafita ke located, amma ba don nemo wannan kayan aiki ba. Kawai, don kunna wannan fasalin, kuna buƙatar kunna shi a cikin saitunan shirin.
Don kunna binciken don mafita a Microsoft Excel 2010, kuma daga baya, je zuwa "fayil" shafin. Domin 2007, ya kamata ka danna maballin Microsoft a saman kusurwar hagu na taga. A cikin taga da ke buɗe, je zuwa sashe "sigogi".
A cikin taga zaɓuɓɓuka, danna kan "Superstsructure". Bayan juyawa, a kasan taga, a gaban siga na sarrafawa, zaɓi ƙimar ƙara "Excel add, ka danna maballin" tafi ".
Tufafin yana buɗewa tare da suparsures. Mun sanya kaska gaban sunayen Add-ciki - "Magani". Latsa maɓallin "Ok".
Bayan haka, maɓallin don fara aikin bincike na mafita zai bayyana akan tef mai kyau a cikin shafin Tage.
Shiri tebur
Yanzu, bayan mun kunna aikin, bari mu tantance yadda yake aiki. Zai fi sauƙi don ƙaddamar da takamaiman misali. Don haka, muna da teburin albashi na ma'aikata na masana'antu. Ya kamata ku lissafa kyautar kowane ma'aikaci, wanda shine albashi da aka nuna a cikin tsarin daban, zuwa wani tsada. A lokaci guda, jimlar adadin kudaden da aka ware don kyauta shine 30000 rubles. Kwayar da aka samar da wannan adadin ita ce sunan manufa, tunda burinmu shine zaɓar bayanan wannan lambar.
Matsakaicin da ake amfani da shi don ƙididdige adadin kyautar, dole ne a lissafta mu ta amfani da mafita--samar da mafita. Tantanin halitta wanda aka samu ana kiranta da ake so.
Dole ne a yi amfani da kwayar da sel da ake so tare da juna ta amfani da dabara. A cikin yanayinmu, tsari yana cikin sel mai manufa, kuma yana da wannan tsari: "= C10 * $ G $ 3 shine cikakkiyar adireshin sel da ake so, da" C10 "- The Jimlar albashi daga abin da Premium ana lissafta ma'aikatan masana'antu.
Gudanar da kayan aiki
Bayan an shirya teburin ta hanyar kasancewa cikin "bayanai", danna maɓallin "Magani Search" wanda yake kan kaset ɗin a cikin "nazarin".
Window ɗin yana buɗe abin da ya kamata a ƙara bayanan. A cikin "inganta aikin na" filin, kuna buƙatar shigar da adireshin sel mai manufa, inda adadin kyautar don duk ma'aikata za su kasance. Za'a iya yin wannan ko ƙaddamar da daidaitawa da hannu, ko ta danna maɓallin Gabatarwar filin takaddar bayanai.
Bayan haka, taga kwatancen zai zo, kuma zaka iya zaɓar da kwayar da ake so. Bayan haka, kuna buƙatar danna sake tare da wannan maɓallin a gefen hagu na fom tare da bayanan da aka shigar don tura jerin kwatancen.
A karkashin taga tare da adireshin sel mai manufa, kuna buƙatar saita sigogi na ƙimar da zasu kasance a ciki. Wannan na iya zama mafi yawan m, ko takamaiman darajar. A cikin lamarinmu, zai zama zaɓi na ƙarshe. Sabili da haka, mun sanya kunnawa zuwa matsayin "darajar", kuma a cikin filin zuwa hagu na shi ana wajaba lambar 30,000. Kamar wannan yanayin da muke tunawa, wannan adadin da ya ƙunshi adadin kyautar ga dukkan ma'aikata na ma'aikata na kasuwancin.
Da ke ƙasa shine "Canje-canje na Kwamfuta". Anan kuna buƙatar tantance adireshin sel da ake so, inda, kamar yadda muke tunawa, akwai madaidaicin albashi, za a iya ƙididdige babban kyautar. Adireshin za a iya wajabta adireshin guda hanyoyi kamar yadda muka yi don sel mai manufa.
A cikin "daidai da iyakoki", zaku iya saita wasu iyakoki don bayanai, misali, yin dabi'u kamar lamba ko ba cutarwa ba. Don yin wannan, danna maɓallin "ƙara".
Bayan haka, ana buɗe hanyoyin ƙara haɓaka. A cikin "hanyar haɗi zuwa sel" filin, muna rajistar ƙwayoyin sel dangi dangi da wanda aka shigar da ƙuntatawa. A cikin lamarinmu, wannan shine sel da ake so tare da amfani. Bayan haka, sanya alamar da ake so: "Kadan ko daidai", "Sealma ko daidai", "daidai ne", "daidai", da sauransu. A cikin lamarinmu, za mu zabi "mafi girma ko daidai" don yin madaidaicin lamba mai kyau. Dangane da filin "ƙuntatawa", saka lamba 0. Idan muna son daidaita wani takaddar, sannan mu danna maɓallin ƙara. A cikin kishili, danna maɓallin "Ok" don adana iyakokin da aka shigar.
Kamar yadda muke gani, bayan wannan, ƙuntatawa ta bayyana a filin da ya dace na sigogin bincike na maganin. Hakanan, yin canzawar marasa canji, zaku iya saita akwati kusa da sigar mai dacewa kawai a ƙasa. Yana da kyawawa cewa an saita siga anan ba ya sabawa da wanda aka yi rajista a cikin iyakokin, in ba haka ba, rikici na iya faruwa.
Za'a iya saita ƙarin saitunan ta hanyar maɓallin "sigogi".
Anan zaka iya saita daidaito na ƙuntatawa da iyakancewar mafita. Lokacin da aka shigar da bayanan da ake so, danna maɓallin "Ok". Amma, ga lamarinmu, ba kwa buƙatar canza waɗannan sigogi.
Bayan an saita saiti, danna kan "Nemo mafita".
Bayan haka, shirin Excel Shafu a cikin sel yana yin lissafin da ake buƙata. Lokaci guda tare da bayar da sakamako, taga yana buɗewa wanda zaka iya ajiye mafita wanda aka samo, ko dawo da dabi'un da ya dace ta hanyar da ya dace. Ba tare da la'akari da zaɓin zaɓi ba, shigar da akwati na akwatin "dawowa zuwa akwatin maganganun sigogi", zaku iya sake zuwa saitin Binciken Exchanis. Bayan akwatunan akwati da sauya aka saita, danna maɓallin "Ok".
Idan don kowane dalili sakamakon magance mafita bai gamsar da ku ba, ko kuma lokacin da kuka lissafa wani kuskure, a wannan yanayin, mun dawo, a cikin akwatin maganganun sigogi. Gabatar da duk bayanan da aka shigar, tunda yana yiwuwa a yi kuskure. Idan an samo kuskuren ba, to sai je zuwa "zaɓi adireshin bayani" siga. Yana samar da yiwuwar zabar ɗaya daga cikin hanyoyi guda uku na lissafi ta hanyar hanyar Odo "," bincika don warware ayyukan da ke da kyau ", da" juyo ". Ta hanyar tsoho, ana amfani da hanyar farko. Muna ƙoƙarin warware aikin, zaɓi kowane irin hanyar. Idan akwai rashin nasara, muna maimaita ƙoƙarin amfani da hanyar ƙarshe. Ayyukan Algorithm har yanzu ne muka bayyana a sama.
Kamar yadda kake gani, aikin binciken don bayani ne mai ban sha'awa wanda, tare da amfani da kyau, na iya adana lokacin mai amfani akan ƙidaya da yawa. Abin takaici, ba kowane mai amfani ya san rayuwarsa ba, ba don ambaci hakkin zai iya aiki tare da wannan masara ba. A cikin wani abu, wannan kayan aiki yayi kama da aikin "zaɓi na sigogi ...", amma a lokaci guda, yana da mahimman bambance-bambance tare da shi.