Izinketho zokufometha okunemibandela ye-Excel zikuvumela ukuthi usebenzise okukhethwa kukho okufomathiwe okuhlukile, njengombala wangemuva, imingcele, noma ukufometha kwefonti kumininingwane ehlangabezana nezimo ezithile. Izinsuku zokudlula isikhathi, isibonelo, zingafomathwa ukuze ziboniswe ngesizinda esibomvu noma umbala wefonti oluhlaza noma kokubili.
Ukufometha okunemibandela kuyasetshenziswa kumakhalekhukhwini owodwa noma ngaphezulu futhi, uma idatha kulawo maseli ihlangabezana nesimo noma izimo ezicacisiwe, ifomethi ekhethiwe isetshenziswa. Ukuqala nge- Excel 2007 , i-Excel inezinketho eziningi zokufometha ezilungiselelwe ngaphambilini ezenza kube lula ukusebenzisa izimo ezisetshenziselwa idatha. Lezi zindlela zokubeka kuqala zifaka phakathi ukuthola izinombolo ezingenhla noma ngaphansi kwenani elilinganiselwe lemininingwane ekhethiwe yedatha.
Ukuthola Ngaphezulu Amanani Aphakathi Nefometha Yemibandela
Lesi sibonelo sihlanganisa izinyathelo okumelwe zilandelwe ukuthola izinombolo ezingaphezu kwesilinganiso ebangeni elikhethiwe. Lezinyathelo ezifanayo zingasetshenziswa ukuthola amanani aphansi angaphansi.
Izinyathelo Zokufundisa
- Faka idatha elandelayo kumaseli A1 kuya ku-A7:
- 8, 12, 16, 13, 17, 15, 24
- Gqamisa amaseli A1 kuya ku-A7
- Chofoza kuthebhu yasekhaya
- Chofoza kusithonjana sokufometha okunemibandela kwi- Ribbon ukuvula imenyu ehlayo
- Khetha Imilayezo Ephezulu / Eyisisekelo> Phezulu Kwesilinganiso ... ukuvula ibhokisi lebhokisi lengxoxo yokufometha
- Ibhokisi lebhokisi liqukethe uhlu olwehlisiwe lwezinketho zokufometha zangaphambi kokusetha ezingasetshenziswa kumaseli akhethiwe
- Chofoza umcibisholo ophansi ngakwesokudla ohlwini lokudonsa ukuze uluvule
- Khetha okukhethwa kukho ukufometha kwedatha - lesi sibonelo sisebenzisa ukuCwiliswa Kokukhanya Okukhanyayo Nombhalo Omnyama Olubomvu
- Uma ungathandi noma yikuphi okukhethwa kukho okulungiselelwe ngaphambilini, sebenzisa inketho yangokwezifiso ezansi ngaphansi kohlu ukuze ukhethe ukukhetha kwakho ukufometha
- Uma usukhethile inketho yokufometha, chofoza u- Kulungile ukwamukela izinguquko bese ubuyela ekhasini lokusebenzela
- Amaseli A3, A5, no-A7 kuphepha lokusebenzela kufanele manje bafomelwe ngezinketho zokufometha ezikhethiwe
- Inani elilinganiselwe lwedatha lingu- 15 , ngakho-ke, inombolo kuphela kulawa maseli amathathu aqukethe izinombolo ezingaphezu kwesilinganiso
Inothi Ukufometha akuzange kusetshenziswe kwiseli A6 ngoba inombolo eselilini ilingana nenani elijwayelekile hhayi ngaphezulu kwayo.
Ukuthola Ngezansi Izindinganiso Zokulinganisa Ngokufometha Okumpoqo
Ukuze uthole izinombolo ezingezansi ezingezansi, ngesinyathelo sesi-5 saphezulu ngenhla khetha ukhetho olungezansi ... bese ulandela izinyathelo ezingu-6 noma yi-10.