Zaɓin siga a cikin Excel. "Zaɓi siga" aikin

Ayyukan "Zaɓi siga" a cikin Excel yana ba ku damar sanin menene ƙimar farko ta kasance, dangane da ƙimar ƙarshe da aka riga aka sani. Mutane kaɗan sun san yadda wannan kayan aiki ke aiki, wannan labarin-umarni zai taimake ka ka gano shi.

Yadda aikin ke aiki

Babban aikin aikin "Parameter Selection" shine don taimakawa mai amfani da littafin e-littafi ya nuna bayanan farko wanda ya haifar da bayyanar sakamako na ƙarshe. Bisa ga ka'idar aiki, kayan aiki yana kama da "Bincike don Magani", kuma "Zaɓi na Kayan aiki" ana ɗaukarsa a sauƙaƙe, tun da ko da mafari zai iya sarrafa amfani da shi.

Kula! Ayyukan aikin da aka zaɓa ya shafi tantanin halitta ɗaya kawai. Sabili da haka, lokacin ƙoƙarin nemo ƙimar farko don wasu windows, dole ne ku sake aiwatar da duk ayyukan bisa ga ka'ida ɗaya. Tunda aikin Excel na iya aiki akan ƙima ɗaya kawai, ana ɗaukarsa iyakataccen zaɓi.

Fasalolin aikace-aikacen aikin: bayyani mataki-mataki tare da bayani ta amfani da misalin katin samfur

Don ƙarin bayani game da yadda Zaɓin Parameter ke aiki, bari mu yi amfani da Microsoft Excel 2016. Idan kuna da sigar baya ko baya na aikace-aikacen da aka shigar, to kawai wasu matakai na iya bambanta kaɗan, yayin da ka'idar aiki ta kasance iri ɗaya.

1. Muna da tebur tare da jerin samfuran, wanda kawai an san adadin ragi. Za mu nemo farashi da adadin da aka samu. Don yin wannan, je zuwa shafin "Data", a cikin sashin "Forecast" mun sami kayan aikin "Analysis menene idan", danna aikin "Parameter Selection".

2. Lokacin da taga pop-up ya bayyana, a cikin filin "Set in cell", shigar da adireshin salula da ake so. A cikin yanayinmu, wannan shine adadin rangwame. Domin kada mu rubuta shi na dogon lokaci kuma ba lokaci-lokaci canza shimfidar madannai ba, muna danna tantanin halitta da ake so. Ƙimar za ta bayyana ta atomatik a daidai filin. Kusa da filin "Value" yana nuna adadin rangwame (300 rubles).

Muhimmin! Tagan “Zaɓi siga” baya aiki ba tare da saita ƙima ba.

3. A cikin filin "Canja ƙimar cell", shigar da adireshin inda muke shirin nuna ƙimar farkon farashin samfurin. Muna jaddada cewa wannan taga yakamata ya shiga cikin tsarin lissafin kai tsaye. Bayan mun tabbatar da cewa duk darajar uXNUMXbuXNUMXbare sun shiga daidai, danna maɓallin "Ok". Don samun lambar farko, gwada amfani da tantanin halitta wanda ke cikin tebur, don haka zai zama da sauƙi a rubuta dabara.

4. A sakamakon haka, muna samun farashin ƙarshe na kaya tare da lissafin duk ragi. Shirin yana lissafin ƙimar da ake so ta atomatik kuma yana nuna shi a cikin taga mai tasowa. Bugu da kari, ana kwafin ƙimar a cikin tebur, wato a cikin tantanin halitta da aka zaɓa don yin lissafin.

A bayanin kula! Ana iya yin lissafin daidaitawa zuwa bayanan da ba a san su ba ta amfani da aikin “Zaɓi siga”, koda kuwa ƙimar farko tana cikin sigar juzu'i na ƙima.

Magance ma'auni ta amfani da zaɓin sigogi

Misali, za mu yi amfani da ma’auni mai sauƙi ba tare da ƙarfi da tushe ba, ta yadda za mu iya gani a gani yadda aka yi maganin.

1. Muna da ma'auni: x+16=32. Wajibi ne a fahimci abin da lambar ke ɓoye a bayan "x" da ba a sani ba. Saboda haka, za mu same shi ta amfani da aikin "Parameter Selection". Da farko, muna rubuta lissafin mu a cikin tantanin halitta, bayan sanya alamar "=". Kuma maimakon "x" mun saita adireshin tantanin halitta wanda ba a sani ba zai bayyana. A ƙarshen tsarin da aka shigar, kada ku sanya alamar daidai, in ba haka ba za mu nuna "KARYA" a cikin tantanin halitta.

2. Bari mu fara aikin. Don yin wannan, muna aiki daidai da hanyar da ta gabata: a cikin shafin "Data" mun sami toshe "Forecast". Anan za mu danna aikin "Bincike menene idan", sa'an nan kuma je zuwa kayan aikin "Select parameter".

3. A cikin taga da ya bayyana, a cikin filin "Set value", rubuta adireshin tantanin halitta wanda muke da ma'auni. Wato wannan ita ce taga “K22”. A cikin filin "Value", bi da bi, muna rubuta lambar da ta yi daidai da ma'auni - 32. A cikin filin "Canza darajar tantanin halitta", shigar da adireshin inda ba a sani ba zai dace. Tabbatar da aikin ku ta danna maɓallin "Ok".

4. Bayan danna maballin "Ok", sabon taga zai bayyana, wanda a ciki an bayyana a fili cewa an sami darajar misalin da aka bayar. Ga alama kamar haka:

A duk lokuta lokacin da aka yi lissafin abubuwan da ba a sani ba ta hanyar "Zaɓin sigogi", ya kamata a kafa wata dabara; idan ba tare da shi ba, ba shi yiwuwa a sami ƙimar ƙima.

Shawara! Duk da haka, yin amfani da aikin "Parameter Selection" a cikin Microsoft Excel dangane da ma'auni ba daidai ba ne, tun da yake yana da sauri don warware kalmomi masu sauƙi tare da wanda ba a sani ba a kan ku, kuma ba ta hanyar neman kayan aiki masu dacewa a cikin e-book ba.

Don takaitawa

A cikin labarin, mun bincika don amfani da yanayin aikin "Parameter Selection". Amma lura cewa a cikin yanayin gano abin da ba a sani ba, za ku iya amfani da kayan aiki muddin babu wanda ba a sani ba. A cikin yanayin tebur, zai zama dole don zaɓar sigogi daban-daban don kowane tantanin halitta, tunda zaɓin ba a daidaita shi don aiki tare da kewayon bayanai gaba ɗaya.