Zamkatimu
Dzulo pa marathon 30 Excel imagwira ntchito m'masiku 30 tinali kukonza malo owonjezera pogwiritsa ntchito ntchitoyi TRIM (CIMATE) ndikuwonetsetsanso kuti sichidzalowa m'malo mwazowongolera zama calorie pamindandanda yathu.
Tsiku lachinayi la marathon tidzapereka phunziro la ntchitoyi Info (DZIWANITSA). Excel Help ikutichenjeza kuti tisamalire ndi ntchitoyi, apo ayi mutha kupereka zambiri zanu kwa ogwiritsa ntchito ena!
Ndiye tiyeni tiwone momwe ntchito imagwiritsidwira ntchito Info (DZIWANITSA) ndipo ganizirani zitsanzo zingapo. Ngati muli ndi zambiri zokhudzana ndi izi kapena zochitika zina, chonde gawanani nawo mu ndemanga. Ndipo sungani zinsinsi zanu!
Ntchito 04: INFO
ntchito Info (INFORM) ikuwonetsa zambiri za malo omwe akugwira ntchito.
Kodi ntchito ya INFO ingagwiritsidwe ntchito bwanji?
ntchito Info (INFORM) ikhoza kuwonetsa izi za Excel:
- Mtundu wa Microsoft Excel.
- Chiwerengero cha mapepala a Excel omwe akugwira ntchito.
- Njira yowerengera pano.
M'matembenuzidwe am'mbuyomu a Excel, mutha kudziwa zambiri zamakumbukidwe, koma mitundu ya mikangano iyi siyikuthandizidwanso.
Syntax INFO (INFORM)
ntchito Info (INFORM) ili ndi mawu awa:
INFO(type_text)
ИНФОРМ(тип_информации)
Type_text (information_type) ndi mkangano womwe umatanthawuza zomwe mungatenge. Zotsatirazi zitha kugwiritsidwa ntchito ngati mkangano:
- Directory (DIRECTORY) - chikwatu kapena foda yamakono.
- ziphuphu (NUM FILE) - chiwerengero cha mapepala ogwira ntchito.
- chiyambi (SOURCE) ndi kalozera wamtheradi wam'manja pakona yakumanzere kwa chinsalu.
- kusokoneza (VERSIONOS) - mtundu wamakina ogwiritsira ntchito.
- recalc (RECALCULATE) - njira yamakono yowerengeranso: "Mokha" kapena "Pamanja".
- kumasulidwa (VERSION) - Mtundu wa Microsoft Excel.
- dongosolo (SYSTEM) - dzina la opareshoni: "pcdos" kapena "mac".
INFO ya Misampha (INFORM)
Thandizo la Microsoft Excel lili ndi chenjezo kuti ntchitoyi Info (INFORM) iyenera kugwiritsidwa ntchito mosamala chifukwa ikhoza kuwulula zambiri zachinsinsi kwa ogwiritsa ntchito ena. Simukufuna kupatsa ogwiritsa ntchito njira yonse ya fayilo yanu yamabuku, sichoncho? Chifukwa chake mukatumiza fayilo ya Excel kwa wina, onetsetsani kuti mwachotsa chilichonse chomwe simukufuna kugawana.
Chitsanzo 1: Mtundu wa Microsoft Excel
Kugwiritsa ntchito Info (DZIWANITSA) ndi mkangano kumasulidwa (VERSION) Mutha kupeza zambiri za mtundu wa Excel. Zotsatira zake zimakhala m'mawu, osati manambala. Chithunzi chomwe chili pansipa chikujambulidwa mu Excel 2010, ndiye zotsatira zake zidzakhala 14.0.
=INFO("release")
=ИНФОРМ("ВЕРСИЯ")
Mutha kugwiritsa ntchito zotsatira zake kuti muwonetse uthenga womwe ukuwonetsa mtundu wa Excel.
=IF(C2+0<14,"Пора обновляться","Последняя версия")
=ЕСЛИ(C2+0<14;"Пора обновляться";"Последняя версия")
Chitsanzo 2: Chiwerengero cha Mapepala Ogwira Ntchito
Kugwiritsa ntchito kukangana ziphuphu (NUMFILE) ntchito Info (INFORM) ikhoza kuwonetsa kuchuluka kwa mapepala omwe akugwira ntchito m'mabuku onse otseguka a Excel. Nambalayi imaphatikizapo mapepala obisika, mapepala m'mabuku obisika ogwirira ntchito, ndi mapepala muzowonjezera.
Muchitsanzo chotsatirachi, buku la Excel lomwe lili ndi mapepala asanu limatsegulidwa ndipo pulagi yomwe ili ndi mapepala awiri ikugwira ntchito. Chiwerengero chonse cha mapepala omwe abwezedwa ndi ntchitoyi Info (INFORM), adzakhala wofanana ndi asanu ndi awiri.
=INFO("numfile")
=ИНФОРМ("ЧИСЛОФАЙЛОВ")
Chitsanzo 3: Njira yowerengeranso
M'malo mokangana type_text (information_type) ya ntchitoyi Info (INFO) Mutha kulozera ku selo yomwe ili ndi imodzi mwamitsutso yoyenera. Muchitsanzo chotsatira, selo B3 ili ndi mndandanda wotsitsa ndi ntchito Info (INFORM) imayimira selo ili.
=INFO(B3)
=ИНФОРМ(B3)
Pamene mndandanda wasankhidwa recalc (RECALCULATE), zotsatira zake zikuwonetsa kuti njira yowerengeranso ndi Mwadzidzidzi.
