Okuqukethwe
Izolo kumarathon 30 Excel isebenza ngezinsuku ezingama-30 besihlanza izikhala ezengeziwe sisebenzisa umsebenzi I-TRIM (ISIZULU) futhi senza isiqiniseko sokuthi ngeke sithathe indawo yokulawula amakhalori kumenyu yethu.
Ngosuku lwesine lwemarathon sizonikela ekutadisheni komsebenzi INFO (KWAZISA). I-Excel Help iyasixwayisa ukuthi siqaphele lo msebenzi, ngaphandle kwalokho unganikeza ulwazi lomuntu siqu kwabanye abasebenzisi!
Ngakho ake sibheke inkomba yomsebenzi INFO (KWAZISA) futhi ucabangele izibonelo ezimbalwa. Uma unolwazi oluthe xaxa ngalesi sici noma ezinye izimo zokusebenzisa, sicela wabelane ngazo kumazwana. Futhi gcina izimfihlo zakho!
Umsebenzi 04: ULWAZI
Umsebenzi INFO (INFORM) ibonisa ulwazi mayelana nendawo yokusebenza yamanje.
Ungasetshenziswa kanjani umsebenzi we-INFO?
Umsebenzi INFO (INFORM) ingabonisa imininingwane elandelayo nge-Excel:
- Inguqulo ye-Microsoft Excel.
- Inombolo yamashidi e-Excel asebenzayo.
- Indlela yokubala yamanje.
Ezinguqulweni ezedlule ze-Excel, ungathola ulwazi mayelana nezinsiza zememori, kodwa lezi zinhlobo zokungqubuzana azisasekelwa.
ULWAZI lwe-Syntax (UKWAZISA)
Umsebenzi INFO (INFORM) ine-syntax elandelayo:
INFO(type_text)
ИНФОРМ(тип_информации)
Uhlobo_lombhalo (information_type) i-agumenti ecacisa ukuthi yiluphi ulwazi okufanele lubuyiswe. Amanani alandelayo angasetshenziswa njengengxabano:
- Isiqondisi (I-DIRECTORY) – umkhombandlela wamanje noma ifolda.
- izinyoni (NUM FILES) – inani lamashidi asebenzayo.
- Umsuka (UMTHOMBO) iyireferensi yeseli eliphelele ekhoneni elingaphezulu kwesokunxele kwesikrini.
- ukweqa (VERSIONOS) – inguqulo yesistimu yokusebenza.
- recalc (RECALCULATE) – indlela yamanje yokubala kabusha: “Ngokuzenzakalelayo” noma “Ngokuzenzela”.
- Ukukhululwa (VERSION) – Inguqulo ye-Microsoft Excel.
- uhlelo (SYSTEM) – igama lesistimu yokusebenza: “ama-pcdos” noma “mac”.
ULWAZI Lwezicupho (UKWAZISA)
Usizo lweMicrosoft Excel lunesixwayiso sokuthi umsebenzi INFO (INFORM) kufanele isetshenziswe ngokuqapha njengoba ingase iveze ulwazi olubucayi kwabanye abasebenzisi. Awufuni ukunikeza abanye abasebenzisi indlela egcwele yefayela lakho lencwadi, akunjalo? Ngakho uma uthumela ifayela le-Excel komunye umuntu, qiniseka ukuthi ususa noma iyiphi idatha ongafuni ukwabelana ngayo nabanye.
Isibonelo 1: Inguqulo ye-Microsoft Excel
Ukusebenzisa umsebenzi INFO (KWAZISA) ngokuphikisana Ukukhululwa (VERSION) Ungathola ulwazi lwenguqulo ye-Excel. Umphumela ukufomethi yombhalo, hhayi izinombolo. Isithombe-skrini esiboniswe ngezansi sithathwe ku-Excel 2010, ngakho umphumela uzoba 14.0.
=INFO("release")
=ИНФОРМ("ВЕРСИЯ")
Ungasebenzisa umphumela ukuze ubonise umlayezo obonisa inguqulo ye-Excel.
=IF(C2+0<14,"Пора обновляться","Последняя версия")
=ЕСЛИ(C2+0<14;"Пора обновляться";"Последняя версия")
Isibonelo sesi-2: Inombolo Yamashidi Asebenzayo
Ukusebenzisa i-agumenti izinyoni (NUMFILE) umsebenzi INFO (INFORM) ingabonisa inani lamakhasi asebenzayo kuwo wonke amabhuku okusebenzela e-Excel avuliwe. Le nombolo ihlanganisa amashidi afihliwe, amashidi ezincwadini zokusebenza ezifihliwe, namashidi ezengezo.
Esibonelweni esilandelayo, incwadi yokusebenzela ye-Excel enamakhasi amahlanu iyavulwa futhi ipulaki equkethe amashidi amabili iyasebenza. Isamba senani lamashidi elibuyiswe umsebenzi INFO (INFORM), izolingana nesikhombisa.
=INFO("numfile")
=ИНФОРМ("ЧИСЛОФАЙЛОВ")
Isibonelo sesi-3: Indlela yamanje yokubala kabusha
Esikhundleni sokungena ingxabano thayipha_umbhalo (information_type) yomsebenzi INFO (INFO) Ungabhekisela kuseli eliqukethe inani elilodwa lamanani e-agumenti avumelekile. Esibonelweni esilandelayo, iseli B3 iqukethe uhlu lokudonsela phansi kanye nomsebenzi INFO (INFORM) ibhekisa kuleli seli.
=INFO(B3)
=ИНФОРМ(B3)
Uma uhlu lukhethiwe recalc (RECALCULATE), umphumela ukhombisa ukuthi indlela yamanje yokubala kabusha iyi Ngokuzenzekelayo.
