Contents
I nehinei i ka marathon 30 mau hana Excel i 30 mau lā hoʻomaʻemaʻe mākou i nā wahi keu me ka hoʻohana ʻana i ka hana KANAKA (CLIMATE) a ʻike pū ʻia ʻaʻole ia e pani i ka mana calorie i kā mākou papa kuhikuhi.
ʻO ka ʻehā o ka lā o ka marathon e hāʻawi mākou i ke aʻo ʻana i ka hana INFO (INFORM). Hoʻomaopopo ʻo Excel Help iā mākou e makaʻala i kēia hana, inā ʻaʻole hiki iā ʻoe ke hāʻawi i ka ʻike pilikino i nā mea hoʻohana ʻē aʻe!
No laila, e nānā kāua i ka reference function INFO (INFORM) a noʻonoʻo i kekahi mau laʻana. Inā loaʻa iā ʻoe ka ʻike hou aʻe e pili ana i kēia hiʻohiʻona a i ʻole nā hihia hoʻohana ʻē aʻe, e ʻoluʻolu e kaʻana iā lākou i nā manaʻo. A mālama i kāu mau mea huna!
Hana 04: INFO
Launch INFO (INFORM) hōʻike i ka ʻike e pili ana i ke kaiapuni hana o kēia manawa.
Pehea e hoʻohana ʻia ai ka hana INFO?
Launch INFO (INFORM) hiki ke hōʻike i kēia ʻike e pili ana iā Excel:
- Manao Microsoft Excel.
- Ka helu o nā pepa Excel hana.
- ʻO ke ʻano helu helu o kēia manawa.
Ma nā mana mua o Excel, hiki iā ʻoe ke loaʻa ka ʻike e pili ana i nā kumuwaiwai hoʻomanaʻo, akā ʻaʻole kākoʻo ʻia kēia mau ʻano hoʻopaʻapaʻa.
ʻIkepili ʻōlelo (INFORM)
Launch INFO (INFORM) loaʻa kēia syntax:
INFO(type_text)
ИНФОРМ(тип_информации)
Type_text (information_type) he hoʻopaʻapaʻa e hōʻike ana i ka ʻike e kiʻi ai. Hiki ke hoʻohana ʻia kēia mau waiwai ma ke ʻano he hoʻopaʻapaʻa:
- papa kuhikuhi (DIRECTORY) – papa kuhikuhi a waihona paha.
- nimoni (NUM FILES) - ka helu o nā pepa hana.
- nā kumu (SOURCE) ʻo ia ka ʻōlelo kelepona paʻa ma ka ʻaoʻao hema hema o ka pale.
- osversion (VERSIONOS) - mana o ka ʻōnaehana hana.
- hoʻomanaʻo hou (RECALCULATE) – ke ʻano o ka helu ʻana i kēia manawa: “Automatically” a i ʻole “Manual”.
- hookuu (VERSION) – Manaʻo Microsoft Excel.
- nenoaiu (SYSTEM) - ka inoa o ka ʻōnaehana hana: "pcdos" a i ʻole "mac".
Pahele INFO (INFORM)
He ʻōlelo aʻo ko Microsoft Excel Help no ka hana INFO (INFORM) pono e hoʻohana me ka akahele no ka mea hiki ke hōʻike i ka ʻike koʻikoʻi i nā mea hoʻohana ʻē aʻe. ʻAʻole ʻoe makemake e hāʻawi i nā mea hoʻohana ʻē aʻe i ke ala piha i kāu faila puke, ʻeā? No laila, i ka hoʻouna ʻana i kahi faila Excel i kekahi, e hōʻoia ʻoe e holoi i nā ʻikepili āu e makemake ʻole e kaʻana like.
Laʻana 1: Manaʻo Microsoft Excel
Ke hoʻohana nei i ka hana INFO (INFORM) me ka hoʻopaʻapaʻa hookuu (VERSION) Hiki iā ʻoe ke loaʻa ka ʻike mana Excel. Aia ka hopena ma ke ʻano kikokikona, ʻaʻole ka helu. ʻO ke kiʻi i hōʻike ʻia ma lalo nei ua lawe ʻia ma Excel 2010, no laila ka hopena 14.0.
=INFO("release")
=ИНФОРМ("ВЕРСИЯ")
Hiki iā ʻoe ke hoʻohana i ka hopena e hōʻike i kahi memo e hōʻike ana i ka mana o Excel.
=IF(C2+0<14,"Пора обновляться","Последняя версия")
=ЕСЛИ(C2+0<14;"Пора обновляться";"Последняя версия")
Laʻana 2: Ka helu o nā Pepa Hana
Ke hoʻohana nei i ka hoʻopaʻapaʻa nimoni (NUMFILE) hana INFO (INFORM) hiki ke hōʻike i ka helu o nā pepa hana ma nā puke hana Excel wehe. Aia kēia helu i nā pepa huna, nā pepa i loko o nā puke hana huna, a me nā pepa i nā mea hoʻohui.
Ma kēia laʻana, ua wehe ʻia kahi puke hana Excel me ʻelima mau ʻāpana a e holo ana kahi plug-in i loko o nā ʻāpana ʻelua. ʻO ka huina o nā pepa i hoʻihoʻi ʻia e ka hana INFO (INFORM), e like ia me ehiku.
=INFO("numfile")
=ИНФОРМ("ЧИСЛОФАЙЛОВ")
Laʻana 3: Ke ʻano helu hou o kēia manawa
Ma kahi o ke komo ʻana i kahi hoʻopaʻapaʻa type_text (information_type) no ka hana INFO (INFO) Hiki iā ʻoe ke kuhikuhi i kahi kelepona i loaʻa kekahi o nā kumu hoʻopaʻapaʻa kūpono. Ma kēia laʻana, loaʻa i ka cell B3 kahi papa inoa hāʻule i lalo a me ka hana INFO (INFORM) pili i kēia pūnaewele.
=INFO(B3)
=ИНФОРМ(B3)
Ke koho ʻia ka papa inoa hoʻomanaʻo hou (RECALCULATE), hōʻike ka hopena i ke ʻano o ka helu ʻana i kēia manawa ʻO ka'Āina.