Contents
Jiya a gudun marathon 30 Excel yana aiki a cikin kwanaki 30 muna tsaftace ƙarin wurare ta amfani da aikin TASHIYA (CIMATE) da kuma tabbatar da cewa ba zai maye gurbin sarrafa kalori a cikin menu namu ba.
Rana ta huɗu na marathon za mu ƙaddamar da nazarin aikin takardunku (SANARWA). Taimakon Excel yana gargaɗin mu mu yi hankali da wannan aikin, in ba haka ba kuna iya ba da bayanan sirri ga sauran masu amfani!
Don haka bari mu dubi ma'anar aikin takardunku (SANARWA) kuma kuyi la'akari da ƴan misalai. Idan kuna da ƙarin bayani game da wannan fasalin ko wasu lokuta masu amfani, da fatan za a raba su a cikin sharhi. Kuma ku kiyaye sirrinku!
Aiki 04: BAYANI
aiki takardunku (INFORM) yana nuna bayanai game da yanayin aiki na yanzu.
Ta yaya za a iya amfani da aikin INFO?
aiki takardunku (INFORM) na iya nuna bayanan masu zuwa game da Excel:
- Microsoft Excel version.
- Adadin zanen gadon Excel masu aiki.
- Hanyar lissafi na yanzu.
A cikin sigogin Excel na baya, zaku iya samun bayanai game da albarkatun ƙwaƙwalwar ajiya, amma waɗannan nau'ikan gardama ba su da tallafi.
BAYANIN SANTAX (INFORM)
aiki takardunku (INFORM) yana da ma'ana mai zuwa:
INFO(type_text)
ИНФОРМ(тип_информации)
Nau'in_rubutu (information_type) hujja ce da ke fayyace bayanan da za a ɗauko. Ana iya amfani da ƙimar masu zuwa azaman hujja:
- directory (DIRECTORY) - kundin adireshi ko babban fayil na yanzu.
- nymphs (NUM FILES) - adadin takaddun aiki.
- Asali (SOURCE) shine cikakken bayanin tantanin halitta a kusurwar hagu na sama na allon.
- zagi (VERSIONOS) - sigar tsarin aiki.
- maimaitawa (RECALCULATE) - Hanyar sake lissafin halin yanzu: "Ta atomatik" ko "Da hannu".
- saki (VERSION) - Microsoft Excel sigar.
- tsarin (SYSTEM) - sunan tsarin aiki: "pcdos" ko "mac".
Tarko INFO (INFORM)
Taimakon Microsoft Excel yana da gargaɗin cewa aikin takardunku Ya kamata a yi amfani da (INFORM) tare da taka tsantsan saboda yana iya bayyana mahimman bayanai ga sauran masu amfani. Ba kwa son ba wa sauran masu amfani cikakkiyar hanyar zuwa fayil ɗin littafin ku, kuna? Don haka lokacin aika fayil ɗin Excel zuwa wani, tabbatar cewa kun goge duk bayanan da ba ku son rabawa.
Misali 1: Sigar Microsoft Excel
Amfani da aikin takardunku (SANARWA) tare da hujja saki (VERSION) Kuna iya samun bayanin sigar Excel. Sakamakon yana cikin tsarin rubutu, ba lamba ba. Hoton da aka nuna a ƙasa an ɗauka a cikin Excel 2010, don haka sakamakon zai kasance 14.0.
=INFO("release")
=ИНФОРМ("ВЕРСИЯ")
Kuna iya amfani da sakamakon don nuna saƙon da ke nuna sigar Excel.
=IF(C2+0<14,"Пора обновляться","Последняя версия")
=ЕСЛИ(C2+0<14;"Пора обновляться";"Последняя версия")
Misali 2: Adadin Zane-zane masu Aiki
Amfani da hujja nymphs (NUMFILE) aiki takardunku (INFORM) na iya nuna adadin takaddun aiki a cikin duk buɗaɗɗen littattafan aikin Excel. Wannan lambar ta ƙunshi ɓoyayyun zanen gado, zanen gado a cikin ɓoyayyun littattafan aiki, da zanen gado a cikin add-ons.
A cikin misali mai zuwa, an buɗe littafin aiki na Excel mai zanen gado biyar kuma plug-in mai ɗauke da zanen gado biyu yana gudana. Jimlar adadin zanen gado da aikin ya dawo takardunku (SANARWA), zai kasance daidai da bakwai.
=INFO("numfile")
=ИНФОРМ("ЧИСЛОФАЙЛОВ")
Misali 3: Hanyar sake kirga na yanzu
Maimakon shigar da hujja type_rubutu (information_type) don aikin takardunku (INFO) Kuna iya komawa zuwa tantanin halitta wanda ya ƙunshi ɗayan ingantattun ƙimar hujja. A cikin misali mai zuwa, tantanin halitta B3 ya ƙunshi jerin zaɓuka da aikin takardunku (INFORM) yana nufin wannan tantanin halitta.
=INFO(B3)
=ИНФОРМ(B3)
Lokacin da aka zaɓi lissafin maimaitawa (RECALCULATE), sakamakon yana nuna cewa hanyar sake kirgawa na yanzu shine Ta atomatik.
