Excel makamaka pulogalamu yokonza deta yomwe ili patebulo. Ntchito VIEW imawonetsa mtengo wofunidwa kuchokera pa tebulo, ndikusintha mtundu womwe umadziwika bwino womwe uli mu mzere womwewo kapena mzere umodzi. Motero, mwachitsanzo, mukhoza kusonyeza mtengo wa mankhwala mu selo losiyana, kutchula dzina lake. Mofananamo, mungapeze nambala ya foni ndi dzina la munthuyo. Tiyeni tiwone bwinobwino momwe ntchito YONSE ikugwirira ntchito.
Ntchito Opanga VIEW
Musanayambe kugwiritsa ntchito chida choyang'ana, muyenera kupanga tebulo, pomwe padzakhala malingaliro omwe muyenera kupeza ndi kukhazikitsa zofunika. Malingana ndi magawo awa, kufufuza kudzachitika. Pali njira ziwiri zomwe mungagwiritsire ntchito ntchito: mawonekedwe a vector ndi mawonekedwe osiyanasiyana.
Njira 1: Fomu ya Vector
Njira imeneyi imagwiritsidwa ntchito nthawi zambiri pakati pa ogwiritsa ntchito pogwiritsa ntchito OTHANDIZA.
- Kuti tipeze mosavuta, timapanga tebulo lachiwiri ndi zipilala "Ndalama yamtengo wapatali" ndi "Zotsatira". Izi siziri zofunikira, chifukwa cha zolingazi mungagwiritse ntchito maselo onse pa pepala. Koma zidzakhala zosavuta.
- Sankhani selo komwe zotsatira zomaliza ziwonetsedwe. Muli momwemo. Dinani pazithunzi "Ikani ntchito".
- Fayilo la Function Wizard likuyamba. Mndandanda ife tikuyang'ana chinthu "PROSMOTR" sankhani ndipo dinani pa batani "Chabwino".
- Kenaka, zenera yowonjezera imatsegulidwa. Kwa ogwira ntchito ena, ndizosowa. Pano muyenera kusankha imodzi mwa mafomu opangira deta omwe takambirana pamwambapa: mawonekedwe kapena ma fomu. Popeza tsopano tikulingalira ndondomeko ya vector, timasankha njira yoyamba. Timakanikiza batani "Chabwino".
- Fesholo yotsutsana ikutsegula. Monga mukuonera, ntchitoyi ili ndi zifukwa zitatu:
- Kufuna mtengo;
- Onani vector;
- Vector zotsatira.
Kwa ogwiritsa ntchito omwe akufuna kugwiritsa ntchito operekera, popanda kugwiritsa ntchito "Ambuye A Ntchito", ndikofunika kudziwa mawu ofotokozera ake. Zikuwoneka ngati izi:
= VIEW (mtengo wofufuzira, vector yotheka, chotsatira chotsatira)Tidzakambirana za mfundo zomwe ziyenera kuikidwa pazenera zazitsutsano.
Kumunda "Ndalama yamtengo wapatali" lowetsani makonzedwe a selo komwe tidzakhalapo chizindikiro chomwe chidzafufuzidwa. Ife mu tebulo yachiwiri amatchedwa selo losiyana. Monga mwachizoloŵezi, adiresi ya kulumikizanako imalowetsedwa m'munda mwadongosolo kuchokera pa kibokosilo kapena poyika malo omwe akugwirizana nawo. Njira yachiwiri ndi yabwino kwambiri.
- Kumunda "Zowoneka Vector" tchulani maselo osiyanasiyana, ndipo mwa ife, mzere umene mainawo ali, umodzi mwa iwo udzalembedwera mu selo "Ndalama yamtengo wapatali". Kulowa makonzedwe kumundawu kumakhalanso kosavuta posankha malo pa pepala.
- Kumunda "Vector Yotsatira" lowetsani zogwirizanitsa zamtunduwu momwe zikhalidwe zomwe tikufunikira kuti tipeze zilipo.
- Deta yonse italowa, dinani pa batani "Chabwino".
- Koma, monga momwe tingathe kuwonera, mpaka pano ntchitoyi ikuwonetsa zotsatira zosayenera mu selo. Kuti icho chiyambe kugwira ntchito, munthu ayenera kulowa muyeso yomwe ife tikusowa kuchokera ku vector yomwe ikuwonetsedwa mu dera lofunidwa.
Deta ikadalowa, selo yomwe ntchitoyi ilipo imadzazidwa ndi ndondomeko yofanana kuchokera ku vector yokopera.
Ngati titalowetsa dzina lina mu selo la mtengo wofunikila, ndiye zotsatira zake, motsatira, zidzasintha.
VIEWER ntchito ikufanana kwambiri ndi CDF. Koma mu CDF, gawo lowonedwa liyenera kukhala lokha. POPEREKERA choletsedwa ichi palibe, monga tikuwonera mu chitsanzo chapamwamba.
Phunziro: Wowonjezera Wogwira Ntchito
Njira 2: mawonekedwe osiyanasiyana
Mosiyana ndi njira yapitayi, mawonekedwe awa amagwira ntchito yonse, yomwe nthawi yomweyo imaphatikizapo malingaliro oyang'ana komanso zotsatira zake. Panthawi imodzimodziyo, maonekedwe omwe akuwonedwa ayenera kukhaladi mbali yotsala ya gulu.
- Pambuyo pa selo yomwe zotsatira zake zidzasankhidwa, Mbuye wa ntchito yakhazikitsidwa ndipo kusintha kwa woyendetsa VIEW kumachitika, zenera likuyamba kusankha mtundu wa woyendetsa. Pachifukwa ichi, sankhani mtundu wa wogwiritsira ntchito payekha, ndiko kuti, malo achiwiri m'ndandanda. Timakakamiza "Chabwino".
- Fesholo yotsutsana ikutsegula. Monga mukuonera, gawo ili la ntchito liri ndi zifukwa ziwiri zokha - "Ndalama yamtengo wapatali" ndi "Mzere". Choncho, mawu ake omasulira ndi awa:
= VIEWER (lookup_value; gulu)Kumunda "Ndalama yamtengo wapatali"monga mwa njira yapitayi, lowetsani makonzedwe a selo momwe funsolo lidzalowe.
- Koma kumunda "Mzere" muyenera kufotokoza zochitika zonse zazomwe zili, zomwe zili ndi maonekedwe osiyanasiyana komanso zotsatira zake. Pa nthawi yomweyi, maonekedwe omwe akuwonedwa ayenera kukhala adiresi yotsala ya gululo, mwinamwake chiganizo sichingagwire ntchito molondola.
- Pambuyo pa deta yomwe yatsimikiziridwa, lowani pa batani "Chabwino".
- Tsopano, monga nthawi yotsiriza, kuti mugwiritse ntchito ntchitoyi, mu selo ya mtengo wofunikirako, lowetsani limodzi la mayina a machitidwe omwe akuwonedwa.
Monga mukuonera, pambuyo pa izi, zotsatira zimangowonetsedwa pamalo omwe akugwirizana nawo.
Chenjerani! Tiyenera kukumbukira kuti mawonekedwe a VIEW gawo ladongosolo ndi osatha. M'masulidwe atsopano a Excel, alipo, koma anangochita zofanana ndi zolembedwa zomwe zasinthidwa m'mawu omaliza. Ngakhale kuti n'zotheka kugwiritsa ntchito mawonekedwe ambiri m'makono a pulogalamuyi, ndikulimbikitsidwa mmalo mwake kuti mugwiritse ntchito ma CDF apamwamba kwambiri (kuti mufufuze mu ndondomeko yoyamba yamtunduwu) ndi GPR (pofufuzira mumzere woyamba wamtunduwu). Iwo sali otsika pang'ono ponena za kayendetsedwe ka mawonekedwe a VIEW a zilembo, koma amagwira ntchito molondola. Koma wogwiritsa ntchito VIEW akufunikabe.
Phunziro: Zitsanzo za cfr ntchito mu Excel
Monga mukuonera, wogwiritsa ntchito OPIEW ndi wothandizira wamkulu pofufuza deta pa mtengo wofunikila. Mbali imeneyi ndi yothandiza makamaka m'ma tebulo akuluakulu. Tiyeneranso kukumbukira kuti pali mitundu iwiri ya ntchitoyi - zojambula ndi zolemba. Yotsiriza idatha kale. Ngakhale ena ogwiritsa ntchito, amagwiritsidwa ntchito mpaka pano.
