Kugwira ntchito ndi matebulo "kupambana" Njira ndi malangizo sitepe, mbali ndi ayamikira

owerenga ambiri kompyuta pa machitidwe Windows zochokera pa zimene Microsoft Office ndithu anakumana ndi MS kupambana ntchito. Mu ogwiritsa novice pulogalamu amachititsa mavuto ena mu chitukuko, koma ntchito "Eksele" ndi kachitidwe ndi matebulo si zovuta monga Zingaoneke koyamba, ngati inu mukudziwa mfundo anaika mu alumikiza lapansi.

Excel ndi chiyani?

Tinabadwa kupambana ndi wathunthu masamu makina kuchita kuchuluka kwa masamu, algebraic, trigonometric, ndi zina ntchito zovuta kwambiri zikugwira ntchito mitundu yambiri zofunika deta, si nthawi zonse zokhudzana ndi masamu.

Kugwira ntchito ndi matebulo "kupambana" akusonyeza kuti ntchito mipata ina ndi wogwirizana ndi kompyuta, ndi malemba mbalambanda, ndi matumizidwe ophatikizika amawu, nyimbo ndi zithunzi. Koma mu pulogalamu yake choyambirira mawonekedwe izo polenga ngati mkonzi wamphamvu masamu. Komabe, kutenga ntchito yoyamba kwa Chiwerengero aliyense ndi zina zozama. kulakwa kwambiri!

Jobs "Eksele" ndi matebulo oyamba: womdziwa woyamba ndi mawonekedwe

Chinthu choyamba pambuyo kutsegula pulogalamu, wosuta amaona zenera chachikulu, imene muli amazilamulira zikuluzikulu ndi zida ntchito. Mabaibulo pambuyo pake, zenera Umaoneka inu kuyamba ntchito, zomwe akumufunsira kulenga file yatsopano, ndi kusakhulupirika amatchedwa "Buku 1" kapena sankhani Chinsinsi kanthu zina.

Kugwira ntchito ndi "kupambana" spreadsheet kwa oyamba pa gawo loyamba la kuzolowerana ndi pulogalamu ayenera okha enieni kulenga tebulo kanthu. Pamene tikulingalira zofunika.

munda Main akuchita tebulo lenilenilo, limene lagawidwa maselo. Aliyense akwanira, chifukwa cha ndondomeko ziwiri ooneka enieni - mzere nambala ndime kalata lakuti (mwachitsanzo, tengani kupambana 2016). manambala Izi athe mu dependencies chilinganizo kuona bwinobwino chimatanthauza ndendende deta cha ndende, machitidwe a umene kupangidwa.

Kuchokera pamwamba, monga mwa ntchito zina ofesi, pali gulu la menyu waukulu, ndipo basi pansipa - zipangizo. Patsinde pali mzere wapadera komwe inu kulowa kachitidwe, ndi pang'ono lamanzere munakwanisa kuona zenera ndi ndondomeko ya selo panopa yogwira (zomwe ndi rectangle). Pansi gulu zikusonyeza mapepala ndi yopingasa kayendedwe ka slider, ndi patsinde ndi batani mtundu lophimba ndi mawonekedwe. Kumanja ndi Mzere ofukula za pepala kuti kusunthira / pansi.

Mitundu deta athandizira ntchito mogwirizana

Poyamba amaganiza kuti ntchito mu "matebulo Eksele 'ndi wosuta kwa oyamba kuzolowera izo ntchito bwino, mwachitsanzo mofanana lemba mkonzi Mawu.

Monga mwachizolowezi, tebulo akhoza kukopera opareshoni, kapena kudula Ikani deta kulowa lemba kapena deta M'ndandanda.

Koma kuika osiyana pang'ono kuchokera ananena akonzi malemba. chakuti pulogalamu poyamba kukhazikitsidwa basi kuzindikira zimene wosuta akaundula selo yogwira. Mwachitsanzo, ngati inu kulowa chingwe 01/02/2016, deta zidzadziŵika monga tsiku, ndipo mchipindamo m'malo manambala analowa kudzakhala tsiku mu mawonekedwe m'Chingelezi chosavuta - 02/01/2016. Kusintha mtundu anasonyeza akhoza kukhala wosavuta (pa zimenezo kanthawi kena).

Ndipo kotero izo ziri ndi manambala. Mungakhale deta aliyense M'ndandanda, ngakhale ndi chiwerengero umasinthasintha malo decimal, nadzakhala kuwonetsedwa mu mawonekedwe imene onse a iwo ntchito kuwona. Koma, ngati inu kulowa ndi inteja, izo Adzaperekedwa popanda mantissa (malo decimal monga ziro). Change n'zothekanso.

Koma inu mwathedwa, ambiri owerenga novice akuyesera kuti asamukire ku selo lotsatira pogwiritsa ntchito makiyi kiyibodi muvi (ofanana ndi momwe izo zikhoza kuchitidwa mu magome Mawu). Ndipo izo sizimagwira ntchito. Chifukwa chiyani? Koma chifukwa ntchito ndi "kupambana" spreadsheet ndi osiyana ndi lemba mkonzi Mawu ndithu kwambiri. kusintha mwina kuchitidwa ndi kukanikiza Lowani ofunika kapena poonetsa rectangle yogwira ntchito foni wina pogwiritsa ntchito kumanzere mbewa pitani. Ngati atalemba chinachake selo yogwira, atolankhani Esc, athandizira adzakhala zimafika.

Zochita ndi mapepala a

Kugwira ntchito ndi mapepala poyamba kuvutika asapembedzere. Pa gulu pansi ali wapadera mapepala pokha batani pambuyo kukanikiza amene adzakhala tebulo latsopano ndi kutengerapo zodziwikiratu kuti ndi kutchula dzina ( "Mapepala 1", "Page 2" ndi zina zotero. D.).

Dinani-kawiri, mukhoza yambitsa ndi renaming aliyense wa iwo. Komanso, pakali-pitani menyu angagwiritsidwe ntchito amayitana ndi menyu zina, pamene pali ochepa malamulo zofunika.

maselo akamagwiritsa

Tsopano chinthu chofunika kwambiri - selo mtundu - imodzi mwa mfundo zofunika Izi n'zimene Mzimuyo mtundu deta kuti zikhale zogwiritsa ntchito pa kuzindikira za nkhani zake. Kuitana mtundu kusintha kupyolera kumanja pitani menyu, pamene mzere yoyenera amusankha kapena kukanikiza F2.

Zenera kumanzere zikusonyeza akamagwiritsa zonse zilipo, ndi bwino chimasonyeza njira kwa anasonyeza deta. Ngati inu mukuyang'ana pa chitsanzo ndi tsiku lili pamwambali, monga mtundu wa amusankha, "Tsiku", ndi woyenera kukhazikitsa fomu anakhumba (mwachitsanzo, 1 February 2016).

ena akamagwiritsa angagwiritsidwe ntchito kuti agwire ntchito masamu, koma mu nkhani losavuta kusankha Number. Kumanja, pali mitundu ingapo ya athandizira, ndi Cholozera chiwerengero cha manambala pambuyo mfundo decimal m'munda mantissa ndi kuika olekanitsa gulu. Kugwiritsa akamagwiritsa ena M'ndandanda (kwakukulu kwambiri, fractional, ndalama ndi zina zotero. D.), nawonso akayiyike magawo ankafuna.

Ndi kusakhulupirika, basi kuzindikira deta anapereka mtundu wamba. Koma pamene inu lembani makalata ochepa kapena pulogalamu akhoza zokha uzidzatenga chinachake. Choncho, kulowa lemba selo yogwira M'pofunika kukhazikitsa njira yoyenera.

Ntchito "kupambana" ndi mitunduyi (tebulo): Chitsanzo

Pomaliza, mawu ochepa za mitunduyi. Choyamba, tiyeni tione chitsanzo Uwerenge manambala awiri mu A1 ndi A2. ntchito zikuphatikizapo basi chimangirizo batani ndi ena ntchito zina (ndi mawerengedwe a zikutanthauza masamu, pazipita, osachepera, ndi zina zotero. D.). Mwachidule kukhazikitsa selo yogwira ali mu ndime yomweyo, pansipa, ndi kusankha kuchuluka izo awerengedwe basi. Ntchito zomwezo kwa mfundo ndi yopingasa, koma selo yogwira ntchito ndalama muyenera kuika bwino.

Koma mukhoza kulowa chilinganizo pamanja (ntchito ndi matebulo "kupambana" ndipo akusonyeza kuti zimenezi zingathe pamene ntchito basi si anapereka). Pakuti yofanana ayenera chilinganizo omwera opotoka ndi mankhwala machitidwe a A1 + A2 kapena ndalama (A1; A2), ndi ngati inu mukufuna kuti musankhe osiyanasiyana maselo, ntchito mawonekedwe pambuyo chizindikiro ofanana: (A1: A20), kenako adzatero Iwo linaŵerengera Uwerenge manambala onse maselo kuchokera oyamba makumi awiri, malimodzi.

Charting

Kugwira ntchito ndi matebulo "kupambana" ndi chidwi mu zimene zimaphatikizapo ntchito yapadera yodzichitira chida akufuna ndi zithunzi zochokera osiyanasiyana anasankha.

Chifukwa chaichi, batani wapadera pa gulu, pambuyo kuwonekera pa zimene mungathe kusankha magawo kapena anakhumba tione. Kenako, tchati kapena Zithunzi anasonyeza pa pepala monga fano.

Cross-kugwirizana, deta inatha ndi katundu

Pologalamuyi akhoza kukhazikitsa deta kulankhulana pa mapepala osiyana, ntchito owonjezerawo kwa owona zina mtundu kapena zinthu mu maseva pa Intaneti, ndipo ena ambiri pokha-mvu.

Komanso owona kupambana akhoza zimagulitsidwa ku akamagwiritsa ena (mwachitsanzo, PDF), kutengera deta kwa iwo, ndi zina zotero. D. Koma msonkhano kutsegula owona analengedwa ntchito zina (akamagwiritsa malemba, zinasokoneza makompyuta, Intaneti, XML- zikalata, ndi zina zotero. d.).

Monga mukuonera, mwayi ndi mkonzi pafupifupi zopanda malire. Ndipo, ndithudi, pofotokoza iwo onse si nthawi yokwanira. Nawa ndizosowa angoyamba, koma wosuta chidwi adzakhala ndi kuwerenga nkhaniyo, kuti adziwe pulogalamu pa mlingo wapamwamba.