Izindlela ezi-4 zokwengeza Ishidi Elisha ku-Excel

Ngokuvamile, abasebenzisi abasebenza kumhleli wespredishithi se-Excel badinga ukungeza ishidi lokusebenzela elisha kudokhumenti yesipredishithi. Yiqiniso, ungakha idokhumenti entsha, kodwa kuhle ukusebenzisa le nketho kuphela ezimweni lapho kungenasidingo sokuxhumanisa ulwazi oluhlukahlukene komunye nomunye. Uhlelo lunezindlela ezimbalwa ezikuvumela ukuthi wengeze ishidi kudokhumenti yesipredishithi. Ake sicabangele zonke izindlela ngokuningiliziwe.

Inkinobho yesipredishithi se-Excel

Le ndlela ibhekwa njengelula futhi elula kakhulu ukuyisebenzisa. Isetshenziswa iningi labasebenzisi bomhleli wespredishithi. Ukusabalala okuphezulu kwendlela kuchazwa yiqiniso lokuthi i-algorithm yokwengeza ishidi lokusebenzela elisha ilula kakhulu futhi iyaqondakala ngisho nakubasebenzisi be-novice.

Udinga ukuchofoza i-LMB engxenyeni ekhethekile ebizwa ngokuthi “Ishidi Elisha”, etholakala kwesokudla samakhasi okusebenza akhona ngezansi kwespredishithi. Inkinobho ngokwayo ibukeka njengophawu oluncane lokuhlanganisa ethunzini elimnyama. Igama leshidi lokusebenza elisha, elisanda kwakhiwa linikezwa ngokuzenzakalelayo. Isihloko seshidi singahlelwa.

Imiyalo enemininingwane yokuhlela igama imi kanje:

1. Chofoza kabili i-LMB ekhasini lokusebenza elidaliwe.
2. Faka igama ofuna ukulinika.
3. Ngemuva kokwenza konke ukukhohlisa, chofoza inkinobho ethi "Enter" etholakala kukhibhodi.

4. Ilungile! Igama leshidi lokusebenza elisha lishintshile.

Ukusebenzisa imenyu yokuqukethwe kwe-Excel ekhethekile

Imenyu yokuqukethwe ikuvumela ukuthi usebenzise inqubo yokwengeza ishidi lokusebenzela elisha kudokhumenti yespredishithi ngezinyathelo ezimbalwa ezisheshayo. Imiyalo enemininingwane yokwengeza ibukeka kanje:

1. Sibheka ngezansi kwesixhumi esibonakalayo sespredishithi futhi sithola elinye lamashidi atholakalayo edokhumenti.
2. Sichofoza kuyo i-RMB.
3. Imenyu yokuqukethwe encane iboniswe esikrinini. Sithola into ebizwa ngokuthi “Faka ishidi” bese uchofoza kuyo i-LMB.

4. Ilungile! Sengeze ishidi lokusebenza elisha kudokhumenti.

Ungabona ukuthi le ndlela, ekuvumela ukuthi wengeze ishidi kudokhumenti usebenzisa imenyu yokuqukethwe, kulula ukuyisebenzisa ngendlela okuxoxwe ngayo ngaphambilini. Ishidi lokusebenza elengezwe yile ndlela lingahlelwa ngendlela efanayo.

Nakani!  Ngokusebenzisa imenyu yokuqukethwe, awukwazi ukufaka kuphela ishidi lokusebenza elisha, kodwa futhi ususe akhona kakade.

Umyalelo onemininingwane yokususa ishidi lokusebenza umi kanje:

1. Sithola elinye lamakhasi atholakalayo edokhumenti.
2. Chofoza ishidi ngenkinobho yegundane elingakwesokudla.
3. Imenyu yokuqukethwe encane ivele esikrinini. Sithola into ebizwa ngokuthi "Susa", chofoza kuyo ngenkinobho yegundane kwesokunxele.
4. Ilungile! Silisusile ishidi lokusebenza kudokhumenti.

Ngokusebenzisa imenyu yokuqukethwe, ungaphinda uqambe kabusha, uhambise, ukopishe futhi uvikele ishidi lokusebenza.

Ukwengeza Iphepha Lokusebenza Ngokusebenzisa Iribhoni Yethuluzi

Ungakwazi ukwengeza ishidi lokusebenza elisha kudokhumenti yesipredishithi se-Excel usebenzisa ibha yamathuluzi ekhethekile enemisebenzi eminingi etholakala phezulu kwesixhumi esibonakalayo. Imiyalo enemininingwane imi kanje:

1. Okokuqala, sithuthela engxenyeni ethi "Ekhaya". Ngakwesokudla seribhoni yamathuluzi, sithola into ebizwa ngokuthi “Amaseli” bese uchofoza kwesokunxele isithonjana somcibisholo esiseduze kwayo. Uhlu lwezinkinobho ezintathu “Faka”, “Susa” kanye “Nefomethi” lwembulwa. Chofoza inkinobho yegundane kwesokunxele komunye umcibisholo oseduze kwenkinobho "Faka".

2. Kwambulwa olunye uhlu oluncane lwezinto ezine. Sidinga i-elementi yokugcina ebizwa ngokuthi “Faka Ishidi”. Sichofoza kuyo LMB.

3. Ilungile! Senze inqubo yokwengeza ishidi lokusebenza elisha kudokhumenti yesipredishithi. Kuyaphawuleka ukuthi, njengoba ezindleleni okuxoxwe ngazo ngaphambili, ungahlela igama lephepha lokusebenzela elakhiwe, futhi ulisuse.

Kubalulekile! Uma iwindi lesipredishithi linwetshwa ukuze libe usayizi walo ogcwele, asikho isidingo sokubheka isici esithi "Amaseli". Kulokhu, inkinobho ethi "Faka Ishidi", esohlwini lokudonsela phansi lwento ethi "Faka", itholakala ngokushesha esigabeni esibizwa ngokuthi "Ekhaya".

Ukusebenzisa Okhiye Bespreadsheet

Ispredishithi se-Excel sinezikhiye zaso ezikhethekile ezishisayo, ukusetshenziswa kwazo kunganciphisa kakhulu isikhathi esithathwayo ukuthola amathuluzi adingekayo kumenyu yohlelo.

Ukwengeza ishidi lokusebenza elisha kudokhumenti yesipredishithi, udinga nje ukucindezela inhlanganisela yokhiye "Shift + F11" kukhibhodi. Ngemva kokwengeza ishidi lokusebenzela elisha ngale ndlela, sizozithola ngokushesha sisendaweni yalo yokusebenza. Ngemva kokuthi ishidi lokusebenza elisha lengezwe encwadini, igama lalo lingahlelwa ngale ndlela engenhla.

Isiphetho

Inqubo yokwengeza ishidi lokusebenzela elisha kudokhumenti ye-Excel iwumsebenzi olula, okungenye yezindlela ezivame kakhulu nezisetshenziswa kakhulu abasebenzisi bespredishithi. Uma umsebenzisi engazi ukuthi angayenza kanjani le nqubo, khona-ke ngeke akwazi ukwenza umsebenzi wakhe ngempumelelo nangempumelelo. Ikhono lokwengeza ishidi lokusebenzela elisha ebhukwini lokusebenza kuyikhono eliyisisekelo wonke umsebenzisi ofuna ukusebenza ngokushesha nangendlela efanele kusipredishithi okufanele abe nalo.