Uyini umsebenzi "Excel"?

Ukuze siphendule ngokunembile umbuzo ngalokho umsebenzi obuhle "Excel", kudingeka uqonde ukuthi yini lolu hlelo.

Lolu hlelo lokusebenza nehhovisi ngokukhethekile ukusebenza spreadsheet amanani ezinombolo.

Izici eziyinhloko:

1. izibalo Economic.
2. izibalo ezibalo.
3. Charting.
4. Automation izibalo (ezimali, ubunjiniyela).
5. Nokusingatha esiningi idatha.
6. Backfill imigqa namaseli amakholomu.
7. Isixazululo of zibalo.
8. Ukuhlaziya imiphumela eyatholakala.
9. Ukusebenzisa ulimi lokwakha izinhlelo ukuze lelisu ezinye izici ohlobo angajwayelekile.
10. Ukusetshenziswa imisebenzi cartographic.
11. Ukuvikelwa ekhethiwe ngumsebenzisi ekusetshenzisweni okungavumelekile.

Umsebenzi "Excel" ubandakanya Ukuhlelwa ezilandelayo:

• iinthombe wamathuluzi main, okuhlanganisa "Standard" futhi "Ifomethi";
• ukukwazi izinkinobho eziyisisekelo panel ngayinye yokuhamba panel;
• ifoni ukubonisa "imenyu Okugcwele."

Incwadzi Yekusebentela futhi oyiyo

Ukunwetshwa imibhalo ahlinzekwa umsebenzi "Excel", ube uhlobo .xls. okuzenzakalelayo idokhumenti ngayinye okudalwe ubizwa ngokuthi "Incwadi." Okuzenzakalelayo njalo wadala amashidi amathathu ibhuku.

ishidi ngasinye esisha yitafula, ehlanganisa 256 kanye nemigqa 65536. Ngasinye bar idokhumenti has a "igama" ngesimo izinhlamvu izinhlamvu zesiLatini. String - inombolo Arabhu. Ngakho, ikheli cell (cell) ezimpambanweni zomgwaqo emigqeni futhi ikholomu ehlanganisa izinhlamvu nezinombolo.

Umsebenzi wanoma yimuphi kuseli eyodwa, ngamabhayisikili iseli noma ububanzi egqanyisiwe e uhlaka amnyama.

imisebenzi Iyatholakala phezu Amakhasi noma amashidi:

1. Usuke. Chofoza kwesokunxele inkinobho yegundane noma inhlanganisela izinkinobho Ctrl PageUp, futhi Ctrl PageDown.
2. Shintsha indawo igunya - kwesokunxele inkinobho yegundane (ukuhudula).
3. Kopisha - Ctrl ukhiye bese uhudula.
4. Kwemihlambi ezingaphezu kweyodwa ishidi ngeluhlelo lolwehlukile. inkinobho Ctrl (sicindezelwe) washiya uchofoze igundane.
5. Kwemihlambi ekupha amashidi elakhiwe. inkinobho Shift (sicindezelwe) futhi chofoza kwesokunxele emakhasini kokuqala nokokugcina ujike.

Umsebenzi "Excel" inikeza okulandelayo imiyalo imenyu yengqikithi:

1. "Engeza." Kwenzeka isifanekiso kwalokho, ihluzo, futhi ngakho ishidi elisha. P.
2. "Susa". Ukususwa amaseli, imigqa, amakholomu, kwalandela shift idatha.
3. "Qamba kabusha". Ukushintsha igama idokhumenti sheet m. P.
4. "Yenza ikhophi / hambisa". Banikezwe ikhophi ukukhetha noma ukuhambisa Ishidi umbhalo oseceleni futhi zithuthele idatha ku Thatha iphe-. Kanye nokunikeza igama ishidi elisha.
5. "Khetha Wonke amashidi".
6. "Umbala Ilebula".

Liphinde ukusebenza "Excel" kuhilela ukushintsha irowu noma ikholomu osayizi. Ukuze wenze lokhu, beka isikhombisi ku ukwehlukanisa phakathi amarowu / amakholomu kangangokuba kwashintsha ukuma. Nakuba ubambe inkinobho yesinxele futhi ezihamba usayizi usayizi ekhona isikhombisi kuyoba ingase ishintshe. Uma ukhetha uhla amarowu / amakholomu kanye usayizi nomunye usayizi abamelwe ishintshwe ngokuzenzekelayo.

Omunye umsebenzi uhlelo "Excel" idinga ukufomathwa kweseli umsebenzi. Imbangela ewindini ukufomatha ungasebenzisa imenyu yengqikithi. Iyatholakala ukuze kuhlelwe: ifomethi inombolo, izinhlobo Ukuvikelwa yeseli / dokhumenti (ezinobukhulu, imibala), amafonti, ukuqondanisa okuqukethwe, uhlobo cell imingcele.

Ake bathemba ukuthi manje wonke umuntu ufunda lesi sihloko, uyaqonda ngokucacile ukuthi umsebenzi "Excel" kudinga cishe sonke isikhathi sethu.