Momwe mungagwiritsire ntchito Function Wizard mu Excel. Kuitana, kusankha ntchito, kudzaza mikangano, kuchita ntchito

Microsoft Excel Function Manager imapangitsa kukhala kosavuta kugwira ntchito ndi mawerengedwe. Zimathetsa kufunikira kolowetsa chifaniziro chimodzi pa nthawi, ndiyeno kuyang'ana zolakwika mu mawerengedwe omwe abwera chifukwa cha typos. Laibulale yolemera ya Excel Function Manager ili ndi ma templates ogwiritsira ntchito zosiyanasiyana, kupatula pamene mukufuna kupanga fomula yokhazikika. Kuti tichepetse nthawi yogwira ntchito ndi matebulo, tidzasanthula kugwiritsa ntchito chida ichi pang'onopang'ono.

Khwerero #1: Tsegulani Ntchito Wizard

Musanayambe kugwiritsa ntchito chida, sankhani selo kuti mulembe ndondomekoyi - dinani ndi mbewa kuti chimango chakuda chiwoneke mozungulira selo. Pali njira zingapo zoyambira Function Wizard:

1. Dinani batani la "Fx", lomwe lili kumanzere kwa mzere kuti mugwiritse ntchito mafomu. Njirayi ndiyofulumira kwambiri, kotero ndiyotchuka pakati pa eni Microsoft Excel.
2. Pitani ku tabu ya "Mafomu" ndikudina batani lalikulu lomwe lili ndi dzina lomwelo "Fx" kumanzere kwa gululo.
3. Sankhani gulu lomwe mukufuna mu "Library of function" ndikudina "Ikani ntchito" kumapeto kwa mzere.
4. Gwiritsani ntchito kiyi kuphatikiza Shift + F Iyi ndi njira yabwino, koma pali chiopsezo choyiwala kuphatikiza komwe mukufuna.

Khwerero #2: Sankhani Mbali

Function Manager ili ndi ma formula ambiri omwe amagawidwa m'magulu 15. Zida zofufuzira zimakulolani kuti mupeze msanga zomwe mukufuna kulowa pakati pa ambiri. Kusaka kumachitidwa ndi chingwe kapena ndi magulu apadera. Iliyonse mwa njirazi iyenera kufufuzidwa. Pamwamba pa zenera la Manager pali mzere "Sakani ntchito". Ngati mukudziwa dzina la fomu yomwe mukufuna, lowetsani ndikudina "Pezani". Ntchito zonse zomwe zili ndi dzina lofanana ndi mawu omwe adalowetsedwa zidzawonekera pansipa.

Kusaka kwamagulu kumathandiza pamene dzina lachidule mu laibulale ya Excel silikudziwika. Dinani pa muvi womwe uli kumapeto kumanja kwa mzere wa "Category" ndikusankha gulu lomwe mukufuna la ntchito ndi mutu.

Pali zingwe zina pakati pa mayina amagulu. Kusankha "Mndandanda wa zilembo zonse" kumabweretsa mndandanda wazinthu zonse za library. Njira "10 Yogwiritsidwa Ntchito Posachedwapa" imathandiza omwe nthawi zambiri amasankha njira zomwezo kuti agwiritse ntchito. Gulu la "Compatibility" ndi mndandanda wazinthu zochokera kumitundu yakale ya pulogalamuyi.

Ngati ntchito yomwe mukufuna ikupezeka m'gululi, dinani payo ndi batani lakumanzere, mzerewo udzakhala wabuluu. Onani ngati kusankha kuli kolondola ndikusindikiza "Chabwino" pawindo kapena "Lowani" pa kiyibodi.

Khwerero #3: lembani mikangano

Zenera lolemba zotsutsana za ntchito lidzawonekera pazenera. Chiwerengero cha mizere yopanda kanthu ndi mtundu wa mkangano uliwonse zimadalira zovuta za ndondomeko yosankhidwa. Tiyeni tiwunike siteji pogwiritsa ntchito njira yomveka "IF" monga chitsanzo. Mutha kuwonjezera mkangano polemba pogwiritsa ntchito kiyibodi. Lembani nambala yomwe mukufuna kapena mtundu wina wazinthu pamzere. Pulogalamuyi imakupatsaninso mwayi wosankha ma cell omwe zomwe zili mkati mwake zimakhala zotsutsana. Nazi njira ziwiri zochitira izi:

1. Lowetsani dzina la cell mu chingwe. Njirayi ndi yovuta poyerekeza ndi yachiwiri.
2. Dinani pa selo yomwe mukufuna ndi batani lakumanzere la mbewa, ndondomeko ya madontho idzawonekera m'mphepete. Pakati pa mayina a maselo, mukhoza kulowa zizindikiro za masamu, izi zimachitika pamanja.

Kuti mutchule ma cell angapo, gwiritsani lomaliza ndikulikokera m'mbali. Ndondomeko yamadontho osuntha iyenera kujambula ma cell onse omwe mukufuna. Mutha kusintha mwachangu pakati pa mizere yotsutsana pogwiritsa ntchito kiyi ya Tab.

Nthawi zina chiwerengero cha mikangano chimawonjezeka pachokha. Palibe chifukwa choopa izi, chifukwa zimachitika chifukwa cha tanthauzo la ntchito inayake. Izi zimachitika nthawi zambiri mukamagwiritsa ntchito masamu a Manager. Mtsutsowo sikuti umakhala ndi manambala - pali zolemba zomwe zigawo za mawuwa zimafotokozedwa m'mawu kapena ziganizo.

Khwerero #4: gwiritsani ntchito

Zikhalidwe zonse zikakhazikitsidwa ndikutsimikiziridwa kuti ndizolondola, dinani OK kapena Enter. Nambala kapena liwu lomwe mukufuna liziwoneka mu cell momwe formula idawonjezedwa, ngati mwachita zonse bwino.

Pakakhala cholakwika, mutha kukonza zolakwikazo nthawi zonse. Sankhani selo lomwe lili ndi ntchito ndikulowa kwa Woyang'anira, monga momwe tawonetsera mu sitepe #1. Zenera lidzawonekeranso pazenera pomwe muyenera kusintha mikangano pamizere.

Ngati njira yolakwika yasankhidwa, chotsani zomwe zili mu selo ndikubwereza masitepe am'mbuyomu. Tiyeni tiwone momwe tingachotsere ntchito patebulo:

• sankhani cell yomwe mukufuna ndikusindikiza Chotsani pa kiyibodi;
• dinani kawiri pa selo ndi ndondomeko - pamene mawu akuwonekera m'malo mwa mtengo womaliza, sankhani ndikusindikiza batani la Backspace;
• dinani kamodzi pa selo lomwe munali mukugwira ntchito mu Function Manager ndikuchotsa zomwe zili pa formula bar - ili pamwamba pa tebulo.

Tsopano ntchitoyi ikukwaniritsa cholinga chake - imapanga mawerengedwe odziwikiratu ndikukumasulani pang'ono ku ntchito yowonongeka.