Masewera sakuyenera kukhala ovuta pamene mugwiritsa ntchito Excel
Monga momwe zilili ndi masamu onse a masamu ku Excel kuti muwonjezere ziwerengero ziwiri kapena zingapo ku Excel muyenera kupanga mayendedwe .
Zindikirani: Kuti muwonjezere ziwerengero zingapo zomwe zili mu mzere umodzi kapena mzere mu pepala la ntchito, gwiritsani ntchito Ntchito ya SUM , yomwe imapereka njira yowonjezera pakupanga njira yowonjezeredwa yakuwonjezera.
Mfundo zofunikira kukumbukira za Excel mawonekedwe:
- Mafomu mu Excel nthawi zonse amayamba ndi chizindikiro chofanana ( = );
- Chizindikiro chofanana nthawi zonse chimayikidwa mu selo kumene mukufuna yankho liwonekere;
- Chizindikiro chowonjezera ku Excel ndi chizindikiro chophatikiza (+);
- Fomuyi imatsirizidwa mwa kukanikiza fungulo lolowamo pa makiyi.
Gwiritsani ntchito Zolemba za Cell mu Zowonjezera Mafomu
Mu chithunzi pamwambapa, mzere woyamba wa zitsanzo (mizere 1 mpaka 3) amagwiritsira ntchito ndondomeko yosavuta - yomwe ili m'mbali C - kuwonjezera pamodzi deta muzithunzi A ndi B.
Ngakhale kuti n'zotheka kuika manambala mwachindunji mu njira yowonjezereka - monga momwe amachitira ndi:
= 5 + 5
mu mzere 2 wa fano - ndi bwino kuti mulowetse deta m'maselo ogwirira ntchito ndikugwiritsa ntchito maadiresi kapena maumboni a maselowo mu njirayi - monga momwe amachitira
= A3 + B3
mzere 3 pamwambapa.
Chinthu chimodzi chogwiritsa ntchito mafotokozedwe a selo m'malo mndandanda wa chidziwitso ndi chakuti, ngati patapita nthawi, pakufunika kusintha ndondomekoyi ndi chinthu chosavuta chotsatira deta mu selo m'malo molembanso njirayo.
Kawirikawiri, zotsatira za fomuyi zidzasinthidwa pokhapokha ngati deta isintha.
Kulowa Maofesi Aling'ono Ndi Cholemba ndi Dinani
Ngakhale kuti mungathe kulembera ndondomeko yomwe ili pamwambayi mu selo C3 ndikukhala ndi yankho lolondola, kawirikawiri limakhala bwino kugwiritsa ntchito mfundo ndi kubwezeretsa , kapena kuwonetsa , kuwonjezera mafotokozedwe a selo ndi ma formula kuti athe kuchepetsa zolakwika zomwe zimapangidwa ndi kulemba mulojekiti yosayenera ya selo.
Mfundo ndi phokoso zimaphatikizapo kungowang'anitsitsa pa selo yomwe ili ndi deta ndi pointer ya mouse kuti uwonjezere chiwerengero cha selo pa fomu.
Kupanga Njira Yowonjezera
Njira zomwe zimagwiritsidwa ntchito popanga ndondomeko yowonjezera mu selo C3 ndi:
- Lembani chizindikiro chofanana mu selo C3 kuti muyambe kupanga;
- Dinani pa selo A3 ndi ndondomeko ya mbewa kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chofanana;
- Lembani chizindikiro chowonjezera (+) mu njira pambuyo pa A3;
- Dinani pa selo B3 ndi ndondomeko yamagulu kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chowonjezera;
- Lembani fungulo lolowamo lolowamo mubokosilo kuti mukwaniritse fomulo;
- Yankho 20 liyenera kupezeka mu selo C3;
- Ngakhale mutayankha yankholo mu selo C3, kudumpha pa seloyo kudzawonetsa chiwongoladzanja = A3 + B3 mu kapangidwe kamene kali pamwamba pa tsamba.
Kusintha Fomu
Ngati pakufunika kukonza kapena kusintha fomu, njira ziwiri zabwino kwambiri ndizo:
- Lembani kawiri pa ndondomekoyi pa tsamba kuti mupange Excel mu Edit mode ndiyeno musinthe kusintha kwa njirayi - zimapindulitsa kusintha pang'ono.
- Dinani kamodzi pa selo yomwe ili ndi ndondomekoyi ndi kubwereranso ndondomeko yonse - yabwino pa kusintha kwakukulu.
Kupanga Mafomu Ovuta Kwambiri
Kulemba zovuta zambiri zomwe zimaphatikizapo ntchito zosiyanasiyana monga kugawa kapena kuchotsa kapena kuwonjezera - monga momwe tawonetsera m'mizere isanu ndi isanu ndi iwiri mu chitsanzo, gwiritsani ntchito ndondomeko yomwe ili pamwambayi kuti muyambe ndikuyamba kupitiriza kuwonjezera olemba masamu omwe akutsatira zolemba za selo zomwe zili ndi deta yatsopano.
Musanayambe kusinthasintha ma masamu osiyanasiyana pamodzi, komabe ndikofunikira kumvetsetsa dongosolo la ntchito yomwe Excel ikutsatila poyesa ndondomekoyi.
Kuchita, yesani chitsanzo ichi ndi sitepe ya njira yovuta kwambiri .
Kupanga Chiwerengero cha Fibonacci
Chiwerengero cha Fibonacci, chokhazikitsidwa ndi katswiri wamasamu wa ku Italy wazaka zana la khumi ndi chimodzi Leonardo Pisano, apange chiwerengero chowonjezeka cha nambala.
Mndandanda uwu nthawi zambiri amagwiritsidwa ntchito kufotokoza, masamu, pakati pa zinthu zina, machitidwe osiyanasiyana omwe amapezeka m'chilengedwe monga:
- Mitundu ya mawonekedwe a nyanja zosiyana;
- Makonzedwe a masamba pa nthambi ya mtengo;
- Njira yoberekera njuchi.
Pambuyo pa ziwerengero ziwiri zoyambira, nambala yowonjezera iliyonse mu mndandanda ndi chiwerengero cha ziwerengero ziwiri zoyambirira.
Mndandanda wosavuta wa Fibonacci, womwe ukuwonetsedwa mu chithunzi pamwambapa, umayamba ndi nambala zero ndi imodzi:
0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, 233, 377, 610, 987, 1597, 2584 ...
Fibonacci ndi Excel
Popeza mndandanda wa Fibonacci umaphatikizapo Kuwonjezerapo, ukhoza kupanga mosavuta ndi njira yowonjezera mu Excel monga momwe tawonetsera pa chithunzi pamwambapa.
Ndondomeko pansipa tsatanetsatane momwe mungapangire ndondomeko yosavuta ya Fibonacci pogwiritsa ntchito ndondomeko. Njirazi zikuphatikizapo kupanga choyamba choyamba mu selo A3 ndiyeno ndikujambula fomuyi kumaselo otsala pogwiritsa ntchito mankhwala odzaza .
Mmodzi uliwonse, kutengera, kapangidwe kameneka, akuphatikiza pamodzi nambala ziwiri zapitazo motsatira.
Masitepe omwe ali m'munsiwa amapanga ndondomeko mu gawo limodzi, osati muzitsulo zitatu zomwe zikuwonetsedwa muchitsanzo cha fano kuti zosavutazo zikhale zosavuta.
Kupanga mndandanda wa Fibonacci womwe ukuwonetsedwa muchitsanzo pogwiritsa ntchito njira yakuwonjezera:
- Mu selo A1 tchulani zero (0) ndi kukanikiza fungulo lolowamo mukibokosi;
- M'chigawo cha A2 choyimira 1 ndikusindikizira Enter key;
- Mu selo A3 tchulani fomu = A1 + A2 ndipo yesani kulowera ;
- Dinani pa selo A3 kuti mupange selo yogwira ntchito ;
- Ikani pointeru ya mbewa pamtambo wodzaza - dothi lakuda pansi pa ngodya yachinsinsi ya selo A3 - pointer imasintha ku chizindikiro choda (black) ( + ) pamene ikudutsa;
- Gwiritsani botani la mbewa pazitsulo chodzaza ndi kukokera pointer la mouse mpaka selo A31;
- A31 ayenera kukhala nambala 514229 .