Chimodzi mwazinthu zosangalatsa za Microsoft Excel ndi LERO. Pogwiritsa ntchito opaleshoni iyi, deti lakalipano limalowetsedwa mu foni. Koma itha kugwiritsidwanso ntchito ndi mitundu ina yophatikiza. Ganizirani zazikuluzikulu za ntchitoyo LERO, zovuta zamachitidwe ake ndi kuyanjana ndi opanga ena.
Kugwiritsa ntchito Ophunzira TSOPANO
Ntchito LERO amatulutsa zomwe zimatuluka mu selo lomwe linatchulidwa pa kompyuta. Ndi gulu la ogwiritsira ntchito "Tsiku ndi nthawi".
Koma muyenera kumvetsetsa kuti formula iyi yokha siyingasinthe zomwe zili mu foni. Ndiye kuti, ngati mutsegula pulogalamuyo m'masiku ochepa osasinthiratu njira zake (pamanja kapena zodziwikiratu), tsiku lomwelo lidzayikidwa mu cell, koma osati lomweli.
Kuti muwone ngati kuwerengera kokha nkukhazikika mu chikalata china, muyenera kuchita zinthu zingapo.
- Kukhala mu tabu Fayilopitani kuloza "Zosankha" kumanzere kwa zenera.
- Pambuyo pazenera magawo ake adakhazikitsidwa, pitani pagawo Mawonekedwe. Tikhala tikufuna mawonekedwe osindikizira apamwamba kwambiri Mawerengi Magawo. Paramu switch "Kuwerengera m'buku" ziyenera kukhazikitsidwa "Basi". Ngati ili mbali ina, ndiye kuti iyenera kukhazikitsidwa monga tafotokozera pamwambapa. Pambuyo pakusintha makonzedwe, dinani batani "Zabwino".
Tsopano, ndikusintha kulikonse mu chikalatachi, ziwonjezedwa zokha.
Ngati pazifukwa zina simukufuna kukhazikitsa zolemba zokha, ndiye kuti musinthe zomwe zili mu foni yomwe ili ndi ntchito lero LERO, muyenera kuyisankha, ikani cholozera mzere wa fomula ndikudina batani Lowani.
Pankhaniyi, ngati makina ojambula omwe ali ndi zilembozi zilemekezedwa, zitha kuchitidwa pokhapokha ngati pali foni iyi, osati zolembedwazo.
Njira 1: kuyambitsa ntchito
Wogwiritsa ntchitoyu alibe mkangano. Mapikidwe ake ndi osavuta ndipo akuwoneka motere:
= LERO ()
- Kuti mugwiritse ntchito ntchitoyi, ingoikani mawuwa mu cell momwe mukufuna kuwona chithunzi cha lero.
- Kuti muwerenge ndikuwonetsa zotsatira pazenera, dinani batani Lowani.
Phunziro: Tsiku la Excel ndi ntchito za nthawi
Njira 2: gwiritsani ntchito Wizard wa Ntchito
Kuphatikiza apo, mutha kugwiritsa ntchito Fotokozerani Wizard. Izi ndizoyenera makamaka kwa ogwiritsa ntchito a novice Excel omwe adasokonezabe mayina a ntchito ndi syntax yawo, ngakhale motere ndizosavuta momwe zingathere.
- Sankhani khungu pa pepala momwe tsikulo liziwonekera. Dinani pachizindikiro "Ikani ntchito"ili pa barula yamu formula.
- Wizard wa Ntchito uyamba. Gulu "Tsiku ndi nthawi" kapena "Mndandanda wathunthu wa zilembo" kufunafuna chinthu "LERO". Sankhani ndikudina batani. "Zabwino" pansi pazenera.
- Windo lazidziwitso laling'ono limatseguka, lomwe limafotokoza cholinga cha ntchitoyi, ndikuti ilibe zotsutsana. Dinani batani "Zabwino".
- Pambuyo pake, deti lomwe lakhazikitsidwa pakompyuta ya wosuta liziwonetsedwa mu foni yomwe idatchulidwa kale.
Phunziro: Ntchito Wizard ku Excel
Njira 3: kusintha maselo
Ngati musanalowe mu ntchito LERO foni inali ndi mtundu wofanana, izisinthidwa zokha mwanjira yanthawiyo. Koma, ngati mtunduwo utapangidwa kale kuti ukhale ndi phindu lina, ndiye kuti sizisintha, zomwe zikutanthauza kuti fomuloli ipanga zotsatira zolakwika.
Kuti muwone mtundu wa foni kapena gawo pa pepala, muyenera kusankha mtundu womwe mukufuna ndipo, mukakhala "Home" tabu, muwone kuti ndi mtengo uti womwe umasungidwa mu mawonekedwe apamwamba pa riboni "Chiwerengero".
Ngati mutalowa fomula LERO mtundu wake sunayikiridwe m'selo yokha Tsiku, ndiye kuti ntchitoyo siziwonetsa zotsatira zake moyenera. Pankhaniyi, muyenera kusintha mawonekedwe.
- Dinani kumanja pa foni yomwe mukufuna kusintha mawonekedwe. Pazosankha zomwe zimawonekera, sankhani malo Mtundu Wa Cell.
- Tsamba losintha likutsegulidwa. Pitani ku tabu "Chiwerengero" m'malo mwake idatsegulidwa kwina. Mu block "Mawerengero Amanambala" sankhani Tsiku ndipo dinani batani "Zabwino".
- Tsopano khungu limapangidwa molondola ndipo likuwonetsa lero.
Kuphatikiza apo, pazenera la fayilo, mutha kusinthanso kuwonetsedwa kwa lero. Fomu yokhazikika ya template "dd.mm.yyyy". Kuunikira zosankha zingapo zamakhalidwe pamunda "Mtundu", yomwe ili kumanja kwa zenera lojambula, mutha kusintha mawonekedwe a tsiku lowonetsedwa mufoni. Pambuyo pakusintha musaiwale kukanikiza batani "Zabwino".
Njira 4: gwiritsani TODAYI kuphatikiza mitundu ina
Komanso ntchito LERO itha kugwiritsidwa ntchito ngati gawo limodzi lamafotokozedwe ovuta. Mu izi, opaleshoniyi amakupatsani mwayi wothana ndi mavuto ambiri kuposa kugwiritsa ntchito pawokha.
Wogwiritsa ntchito LERO Ndizosavuta kugwiritsa ntchito kuwerengera nthawi, mwachitsanzo, posonyeza zaka za munthu. Kuti tichite izi, timalemba mawu amtunduwu m'chipindamo:
= CHAKA (LERO ()) - 1965
Kuti mugwiritse ntchito chilinganizo, dinani batani ENG.
Tsopano, muchipinda chosungira momwe zalembedwera, m'badwo wamunthu wa omwe adabadwa mu 1965 aziwonetsedwa. Mawu ofananawo amatha kugwira ntchito pachaka chilichonse chobadwa kapena kuwerengetsa zaka zomwe zinachitika.
Palinso formula yomwe imawonetsa masiku angapo pasadakhale. Mwachitsanzo, kuwonetsa tsikulo patatha masiku atatu, zikuwoneka ngati:
= LERO () + 3
Ngati mukufunikira kukumbukira tsiku lomwe lapita masiku atatu apitawo, mawonekedwe ake adzawoneka motere:
= LERO () - 3
Ngati mukufuna kuwonetsera mu foni nambala yokha ya tsiku lomwe mulipeza mweziwo, osati tsiku lenileni, ndiye kuti mawu awa agwiritsidwa ntchito:
= TSIKU (LERO ())
Kugwiritsanso ntchito kofananako kowonetsa nambala yamiyezi yapano kumawoneka motere:
= MONTH (LERO ())
Ndiye kuti, mu febuloni nambala 2 idzakhala muchitokisi, mu Marichi - 3, ndi zina zambiri.
Pogwiritsa ntchito njira yovuta kwambiri, mutha kuwerengetsa kuti ndi masiku angati azikwanira kuchokera lero kufika tsiku linalake. Ngati mungakonze ndalamazo molondola, mwanjira imeneyi mutha kupanga mtundu wotsatsa zowerengetsa nthawiyo mpaka tsiku lomwe mwapatsidwa. Template ya formula yomwe ili ndi mphamvu zofananira ndi iyi:
= DATEVALUE ("set_date") - TODAY ()
M'malo mopindulitsa "Khalani ndi Tsiku" Fotokozani tsiku lenileni mumtunduwo "dd.mm.yyyy", komwe muyenera kukonzekera kuwerengera.
Onetsetsani kuti mwapanga fayilo momwe awerengere awonetse mtundu wonsewo, apo ayi kuwonetsa zotsatira zake sikungakhale kolondola.
Pali mwayi wophatikiza ndi ntchito zina za Excel.
Monga mukuwonera, kugwiritsa ntchito ntchitoyo LERO Simungangowonetsa tsiku lomwe lilipo lero, komanso muwerengere zina zambiri. Kudziwa kapangidwe ka izi komanso njira zina kudzathandiza kutsata mitundu yosiyanasiyana yogwiritsira ntchito kogwiritsa ntchito opareshoni. Ngati musintha molondola momwe amafotokozera mu chikalatacho, kufunika kwake kumakhala kusinthidwa zokha.
