Dziwani zomwe mbali zonse zawonekera pa Excel zili zabwino
Ngati muli watsopano kugwiritsa ntchito Excel 2013 kwa ma sapiritsi, simungadziwe kuti chirichonse chiri pawindo ndi chiyani. Mwayi ndikuti, mudzapeza njira zosavuta kapena zogwira ntchito zogwira ntchito ndi masamba anu mukatha kudziwa zambiri za mawonekedwe. Pano pali kuyang'ana mofulumira pa zigawo za sewero la Excel.
Excel 2013 Screen Elements
Pulogalamu ya Excel ili ndi mwayi. Mutaphunzira zomwe gawo lirilonse liri, muzitha kuchoka pazipangizo zamakono zosayang'ana nthawi iliyonse.
Onetsani chithunzi pamwambapa kuti mupeze zinthu zomwe zafotokozedwa.
Active Cell
- Selo yogwira ntchito imadziwika ndi ndondomeko yake yobiriwira. Deta nthawizonse imalowa mu selo yogwira ntchito. Maselo osiyana akhoza kupanga ntchito mwa kuwonekera pa iwo ndi mbewa kapena pogwiritsa ntchito makiyi ophikira pa kibokosi.
Onjezerani Chizindikiro Chake
- Kuphatikizira pazithunzi pazowonjezera pafupi ndi Tsambali la Tsambali pansi pa skiritsi likuwonjezera tsamba lina. (Mungathenso kugwiritsa ntchito njira zowonjezera ziwiri kuti muwonjezerepo tsamba latsopano : Shift + F11 ndi Alt + Shift + F1.)
Cell
- Maselo ndi mabokosi omwe ali m'kati mwa mapepala apamanja.
- Deta inalowetsedwera pazomwe zimagwiritsidwa ntchito mu selo. Selo lirilonse lingakhoze kugwira chidutswa chimodzi cha deta panthawi.
- Selo ndilo gawo loyendayenda la mzere wokhoma ndi mzere wopingasa.
- Selo lirilonse lomwe lili pa tsambali likhoza kudziwika ndi selo , yomwe ili kuphatikiza makalata ndi manambala monga A1, F456, kapena AA34.
Zilembo Zamapepala
Bwalo la Fomu
- Ili pamwamba pa tsamba, gawo ili likuwonetsera zomwe zili mu selo yogwira ntchito. Babu lachindunji lingagwiritsenso ntchito polowera kapena kusintha deta ndi ma fomu .
Bokosi la Dzina
- Zikapezeka pafupi ndi bar lachonde, Bokosi la Dzina likuwonetsera selo la maselo kapena dzina la selo yogwira ntchito.
Bwalo la Masamba Yopindulitsa
- Bwalo lopangira Quick Access likukuthandizani kuwonjezera malamulo ogwiritsidwa ntchito nthawi zonse. Dinani pamsana wotsika kumapeto kwa chida chopangira masewera kuti muwonetse zosankhidwa.
Ribbon
- Mphutsi ndi mzere wa mabatani ndi zithunzi zomwe zili pamwamba pa tsamba. Mukangododometsedwa, mabatani ndi zizindikiro izi zimayambitsa mbali zosiyanasiyana za pulogalamuyi. Choyamba chodziwika mu Excel 2007, nthitiyo inalowetsamo menyu ndi zida zogwiritsira ntchito zomwe zapezeka mu Excel 2003 ndi Mabaibulo oyambirira.
Makatani a Ribbon
- Mapepala a Ribbon ndi mbali ya menyu yosakanikirana yomwe imakhala ndi maulendo osiyanasiyana. Tsambali lililonse - monga Home , Mapangidwe , ndi Mafomu - ali ndi zinthu zina zomwe zimagwirizanitsidwa podalira chizindikiro choyenera.
Fayilo Tabu
- Fayilo yafayilo inayambitsidwa ku Excel 2010, m'malo mwa Excel 2007 Office Button, ndipo imagwira ntchito mosiyana ndi ma tabo ena. M'malo mokhala ndi zosankha zake pazenera lakuphatikizira, kudodometsa pa Fayilo tabu imatsegula menyu otsika pansi kumbali yakumanzere ya chinsalu.
- Tsambali ili ndi zinthu zomwe zimagwirizana kwambiri ndi mafayilo ndi malemba, monga kutsegula mafayilo atsopano kapena alipo, kusunga, ndi kusindikiza.
- Chosankha Chachidule, chomwe chiliponso pa menyu, chimagwiritsidwa ntchito kusintha maonekedwe a pulojekiti yonseyo posankha zinthu zomwe zowonekera, monga mipiringidzo ndi magalasi. Ikuphatikizaponso njira zomwe zingathe kukhazikitsa machitidwe angapo kuphatikizapo kubwezeretsanso mafayilo apakompyuta ndikusankha zilankhulo zomwe mungagwiritse ntchito pofuna kufufuza ndi ma galamala.
Mawerengedwe a Mzere
- Mizere imathamanga pang'onopang'ono mu tsamba lamasamba ndipo imadziwika ndi nambala mu mutu wa mzere .
Ma Tsati
- Mwachisawawa, pali tsamba limodzi pa fayilo ya Excel 2013, koma mukhoza kuwonjezera mapepala ena. Tsamba lamasamba pamunsi pa tsambali limakuuzani dzina la sheetwork , monga Sheet1 kapena Sheet2 .
- Kubwezeretsanso tsamba kapena kusintha mtundu wa tabu kungakhale kosavuta kusunga deta m'mafayilo akuluakulu a spreadsheet.
- Kusinthasintha pakati pa mapepala kungatheke podalira pa tepi la pepala yomwe mukufuna kuilandira. (Mukhozanso kusinthana pakati pa mapepala ndi njira yachinsinsi kuti musinthe pakati pa mapepala : Ctrl + PgUp ndi Ctrl + PgDn.)
Bwalo lachikhalidwe
- Bwalo labwino , lomwe limayendetsa pansi pamunsi pazenera, lingathe kusinthidwa kuti liwonetse njira zingapo, zomwe zambiri zimapatsa wothandizira zazomwe akulemba panopa, deta yomwe ili ndi tsambalo, ndibokosi la wogwiritsa ntchito ngati Caps Lock , Mpukutu Wopukuta , ndipo Num Lock makiyi amasulidwa kapena atsekedwa.
- Mzere wazitsulo umaphatikizanso zojambula Zowonjezera , zomwe zimalola ogwiritsa ntchito kusintha kusintha kwa tsamba.
Sula Slider
- Ili pansi pazanja lamanja la Excel pulojekiti, Slide yofiira imagwiritsidwa ntchito kusintha kukweza kwa pepala lothandizira pamene mukukoka bolodi lamasitomala kumbuyo kapena kutsogolo kapena dinani Zoom Out ndi Zoom In mabatani omwe ali kumapeto kwa slide.
Zaka Zakale za Excel
Ngati simukugwiritsa ntchito Excel 2013, imodzi mwa nkhanizi ingakhale ndi mauthenga omwe mukufuna.