Makonzedwe Zokongoletsa mu MS kupambana - pang'ono odziwika mbali ya spreadsheet otchuka

Banja la mankhwala ofesi ya Microsoft Corporation pansi pa dzina kupambana ndi mndandanda wa mapurosesa wamphamvu spreadsheet ndi otchuka kwambiri kwa onse ogwiritsa ntchito wamba makompyuta ndi akatswiri yopapatiza mbiri amene amaika mphamvu choterechi cha zida mapulogalamu akhala kukhala chida chofunika kwambiri pa ntchito ya masamu, zithunzi ndipo deta zina zowerengera.

mankhwala mapulogalamu ndi luso mudziwe anaikira processing akatswiri kukukhala lalikulu deta. Excel limakupatsani automate ndi bwino formalize kukhazikitsa zosiyanasiyana computations ofanana, komanso kuti processing n'zosangalatsa kumva komanso kalembedwe zambiri mu mabuku lalikulu.

Mwachitsanzo, kuchita mofulumira, molondola ndi kothandiza kusanthula ndalama, msonkho ndalama, etc. mbali chifungulo cha pulogalamu wamphamvu kale bwino kuphunzira ndi mabungwe ena onse. Koma kupambana ali kwambiri zinsinsi ndi zidule zodziwika kokha kwa bwalo yopapatiza akatswiri. Mmodzi wa zipani za chinsinsi pokhapo titachitapo masanjidwe. Ntchito limapereka osiyanasiyana kwambiri mbali zachilendo.

The chida, wotchedwa "makonzedwe masanjidwe" limachititsa iyende chidwi kwambiri ndi zidzasintha zithunzi zinachitikira wosangalatsa deta mosiyana. Kutheka ntchito nchito imeneyi kuthetsa mavuto osiyanasiyana ndipo yosiyanasiyana. Makonzedwe masanjidwe amalola zoika ena mtundu selo malinga ndi nkhani pamene anakonzeratu zinthu. Mtundu wa masanjidwe yabwino ndi lucid kwambiri mu kusanthula deta lalikulu waika.

Makonzedwe Zokongoletsa ndi kupambana, popanda kukokomeza, ndi chida champhamvu chimene chimatsegula chiyembekezo n'kale lonse ntchito ndi spreadsheets ndi mpata zoonanso pa osiyanasiyana kanjedza youma. Chidwi mwayi imeneyi kuyang'ana pa mitundu yonse ya mapepala ulaliki. akamagwiritsa makonzedwe kophweka kupeza kuchotserapo zosiyanasiyana, kukusokonezani kwa deta chonse zino. mumaganiza ofunika komanso si kuzimiririka ndi katswiri wa. Zimenezi zingakhale zothandiza kwambiri mu processing deta zowerengera. Makonzedwe Zokongoletsa mu kupambana 2007 ali zina zosangalatsa zamakono, monga gradients mtundu, osiyana shading deta mizere, zithunzi wapadera kuti akuwonjezeka maselo ndi limakupatsani msanga mme- kuyankhulana pakati pa zizindikiro zosiyanasiyana.

Ntchito makonzedwe masanjidwe ndi lophweka - ochepa chabe mbewa kudina. Tiyeni tinene inu jambulani tebulo maselo ena kuti lili magawo. Muyenera kusintha mitundu selo kukhuta malinga ndi kusintha kwa n'zosangalatsa kumva mfundo deta ali iwo. Mwachitsanzo, ngati selo lili ndi chiwerengero zoipa, izo basi lembani mtundu zili zofiira, ndipo ngati zabwino - wobiriwira.

Kuti tichite zimenezi, basi ayenera kugwiritsa ntchito "Mtundu" menyu, dinani katunduyo imene "MAKONZEDWE Zokongoletsa". Mu chipindacho, chimene chili chofunika kukhazikitsa mtundu akufuna, ayenera anatsindika. Mu bokosi kukambirana "MAKONZEDWE Zokongoletsa" muyenera mwachindunji mkhalidwe umene selo ndi kusintha mtundu wa eti. Ndi batani "Mtundu" mofanana kukambirana bokosi kufotokoza maonekedwe ankafuna.

Ngati mukufuna kusintha masanjidwe wa khungu wina ndi mzake, malingana deta, ndiye m'pofunika adasonkhananso kwa "chilinganizo" ya kumanzere dontho-pansi mndandanda bokosi akamagwiritsa makonzedwe. Mtunda pakati pa maselo zilibe kanthu. Ndondomeko akhoza kukhala aliyense: ngakhale mawerengedwe tanthauzo zowerengera, ngakhale mtengo wa depreciation wa chuma. Mwachitsanzo, ngati mukufuna, pamene selo A1 ndi angapo a zinayi, selo kapena maselo angapo yotengedwa ndi kukhuta chikasu, ndiye, ngati chikhalidwe, kulowa chilinganizo otsatirawa: "= yamakono (A1, 4) = 0." Ndiye ntchito "Mtundu" batani mwachindunji kufunika kukhuta mtundu. Komanso, kukopera ndi masanjidwe pasting ndi kunditumiza ku selo anakhumba kapena osiyanasiyana.