Mukati
Nezuro mumarathon 30 Excel inoshanda mumazuva makumi matatu takanga tichichenesa dzimwe nzvimbo tichishandisa basa racho TRIM (CIMATE) uye zvakare yakaita shuwa kuti haizotsiva calorie control mune yedu menyu.
Zuva rechina remarathon tichazvipira pakudzidza kwebasa racho INFO (ZIVA). Excel Rubatsiro inotiyambira kuti tingwarire nebasa iri, zvikasadaro unogona kupa ruzivo rwemunhu kune vamwe vashandisi!
Saka ngatitarisei kune referensi yebasa INFO (ZIVA) uye funga nezvemienzaniso mishoma. Kana iwe uine rumwe ruzivo nezve ichi chimiro kana mamwe ekushandisa kesi, ndapota igovera iwo mune zvakataurwa. Uye chengeta zvakavanzika zvako!
Basa 04: INFO
basa INFO (INFORM) inoratidza ruzivo pamusoro pemamiriro ekushanda aripo.
Iyo INFO basa rinogona kushandiswa sei?
basa INFO (INFORM) inogona kuratidza ruzivo runotevera nezveExcel:
- Microsoft Excel vhezheni.
- Nhamba yeanoshanda eExcel sheets.
- Nzira yekuverenga ikozvino.
Mune shanduro dzakapfuura dzeExcel, unogona kuwana ruzivo nezve zviwanikwa zvendangariro, asi idzi nharo dzemhando hadzichatsigirwi.
Syntax INFO (INFORM)
basa INFO (INFORM) ine syntax inotevera:
INFO(type_text)
ИНФОРМ(тип_информации)
Type_text (information_type) nharo inotsanangura kuti ndeupi ruzivo rwekutora. Aya anotevera maitiro anogona kushandiswa senharo:
- dhairetori (DIRECTORY) - dhairekitori razvino kana folda.
- nymphs (NUM FILES) - nhamba yemashizha anoshanda.
- zvakabva (SOURCE) ndeye mhedziso yesero referenzi mukona yepamusoro kuruboshwe rwechidzitiro.
- osversion (VERSIONOS) - vhezheni yeiyo inoshanda sisitimu.
- recalc (RECALCULATE) - yazvino nzira yekuverengazve: "Otomatiki" kana "Manually".
- kuregedzera (VERSION) - Microsoft Excel shanduro.
- maitiro (SYSTEM) - zita rekushandisa system: "pcdos" kana "mac".
Misungo INFO (KUZIVA)
Microsoft Excel Rubatsiro ine yambiro yekuti basa racho INFO (INFORM) inofanira kushandiswa nekuchenjerera sezvo inogona kuratidza ruzivo rwakadzama kune vamwe vashandisi. Iwe hausi kuda kupa vamwe vashandisi nzira yakazara yebhuku rako faira, unodaro? Saka kana uchitumira faira reExcel kune mumwe munhu, ita shuwa kuti unodzima chero data yausingade kugovera.
Muenzaniso 1: Microsoft Excel shanduro
Kushandisa basa INFO (ZIVA) nenharo kuregedzera (VERSION) Unogona kuwana Excel vhezheni ruzivo. Mhedzisiro yacho iri muchimiro chemavara, kwete manhamba. Iyo skrini inoratidzwa pazasi inotorwa muExcel 2010, saka mhedzisiro ichave 14.0.
=INFO("release")
=ИНФОРМ("ВЕРСИЯ")
Unogona kushandisa mhedzisiro kuratidza meseji inoratidza vhezheni yeExcel.
=IF(C2+0<14,"Пора обновляться","Последняя версия")
=ЕСЛИ(C2+0<14;"Пора обновляться";"Последняя версия")
Muenzaniso 2: Nhamba Yemashiti Anoshanda
Kushandisa nharo nymphs (NUMFILE) basa INFO (INFORM) inogona kuratidza huwandu hwemashizha anoshanda mumabhuku ese akavhurwa eExcel. Iyi nhamba inosanganisira mashizha akavanzwa, mashizha mumabhuku ekushanda akavanzika, uye mapepa mu-add-ons.
Mumuenzaniso unotevera, bhuku rekushanda reExcel rine mapepa mashanu rinovhurwa uye plug-in ine mapepa maviri iri kushanda. Huwandu hwemashiti akadzoserwa nebasa INFO (INFORM), ichaenzana nenomwe.
=INFO("numfile")
=ИНФОРМ("ЧИСЛОФАЙЛОВ")
Muenzaniso 3: Yazvino nzira yekuverengazve
Pane kuti muite nharo type_text (information_type) yebasa racho INFO (INFO) Unogona kureva sero rine imwe yenharo dzakakosha. Mumuenzaniso unotevera, sero B3 rine rondedzero yekudonha uye basa INFO (INFORM) zvinoreva sero iri.
=INFO(B3)
=ИНФОРМ(B3)
Kana rondedzero yasarudzwa recalc (RECALCULATE), mhedzisiro inoratidza kuti ikozvino recalculation nzira ndeye Automatically.
