Chii basa "Excel"?

Kuti zvakanaka kupindura mubvunzo pamusoro chii basa rakanaka "Excel", unofanira kunzwisisa chii chirongwa ichi.

Izvi hofisi kushanda unyanzvi vari kushanda pamwe Spreadsheets uye kusanganiswa tsika.

Key zvinhu:

1. Economic Masvomhu.
2. Statistical Masvomhu.
3. Charting.
4. Kushandisa michina Masvomhu (rokuzvidavirira, injiniya).
5. Kudzora yakawanda mashoko.
6. Backfill mitsara masero pembiru.
7. Kugadzirisa kwakaita equations.
8. Kuongororwa vakachiwana zvabuda.
9. Kushandisa mutauro zvirongwa ezvidzidzo zvimwe vasiri vomureza mhando.
10. Kushandiswa cartographic mabasa.
11. Kudzivirirwa akasarudzwa inodzidzisa kubva kunze komutemo kushandiswa.

Basa "Excel" kunosanganisira zvinotevera presets:

• kuti unyorwe huru toolbars, zvinosanganisira "Standard" uye "Format";
• Kuyera dzinokosha mabhatani remadziro rimwe nerimwe nokutamira zvaiva pangoro;
• runhare kuratidza "Full Muterere."

Workbook yaro mamiriro

Kuwedzera magwaro akapa basa mu "Excel", vane mhando .xls. Mumwe richangobva akasika default gwaro rinonzi "The Book." The default anogara akasika machira matatu ari workbook.

jira mutsva mumwe nomumwe ari tafura, zvinosanganisira 256 mbiru uye 65536 misara. Mumwe muzariro gwaro rine "zita" muchimiro tsamba rechiLatin arufabheti. Tambo - Arabic nhamba. Saizvozvowo, sero kero (sero) panguva mharadzano pakati pemitsara, uye mbiru zvinosanganisira tsamba uye nhamba.

Basa sero chero chete, bhasikoro sero kana chikuva kusimbiswa murima pepa rehurukuro.

Available akavhiyiwa pamusoro mapeji kana machira:

1. Nokuchinja. Baya akasiya mbeva bhatani kana mubatanidzwa mabhatani Ctrl + PageUp, uye Ctrl + PageDown.
2. Kushandura nzvimbo kuitwa - kuruboshwe mbeva bhatani (zvuva uye donhwe).
3. Copy - Ctrl kiyi achikakata.
4. Voga anopfuura rimwe jira yakasiyana kuti. Ctrl bhatani (akavanyengetedza) uye akasiya tinya mbeva.
5. Voga pakati siyana kunotangira machira. Kusuduruka bhatani (akavanyengetedza) uye rworuboshwe tinya kwokutanga uye yokupedzisira mapeji kutendeukira.

Basa "Excel" inopa zvinotevera mirayiro akapoteredza Muterere:

1. "Wedzerai." It kunoitika template Uyezve, Graphics, uye saka semucheka itsva. P.
2. "Kudzima". Kubviswa masero, misara, mbiru, uchiteverwa date kusuduruka.
3. "Rename". Changing zita jira gwaro uye m. P.
4. "Ita bhurocha / danho". Akapiwa chisarudzo kopi kana kutama jira ari oga gwaro, uye kutamira mashoko kuti yoga jira. Uyewo kupa zita kuti jira itsva.
5. "Sarudzai Sheets All".
6. "Color Label".

Zvinonzi zvakare kushanda ne "Excel" kunosanganisira kuchinja mutsara kana mbiru hukuru. Kuti aite izvi, uise cursor pamusoro zviparadzanise pemitsara / mbiru zvokuti achinja chimiro. Apo akabata kuruboshwe mbeva bhatani uye anozunungusa resizing huripo cursor saizi achava pasi kuchinja. Pakusarudza zvakawanda mitsara / mbiru uye resizing mumwe constituent zvimwe saizi achashandurwa kwaita.

Chimwe basa iri chirongwa "Excel" kunoda sero formatting chaitika. Kukonzera hwindo formatting ungashandisa chechinyorwa Muterere. Available nokuti fora: uwandu format, sero dziviriro / gwaro mhando (makuriro, mavara), fonts, inogara kugutsikana, mhando foni miganhu.

Ngatitorei tariro kuti zvino munhu wose anenge kuverenga nyaya ino, kunyatsonzwisisa kuti basa iri "Excel" inoda inenge yose nguva yedu.