Kugwiritsa ntchito VIEW mu Excel

Pulogalamu ya Excel imakulolani kuti mulowetse deta patebulo, komanso kuti muyigwiritse ntchito m'njira zosiyanasiyana. Monga mbali ya bukhuli, tiona chifukwa chake ntchitoyi ikufunika Onani ndi momwe mungagwiritsire ntchito.

Zopindulitsa

Onani amagwiritsidwa ntchito kupeza ndi kuwonetsa mtengo kuchokera patebulo lomwe likufufuzidwa pokonza/kufananiza ndi gawo lodziwika ndi wogwiritsa ntchito. Mwachitsanzo, timayika dzina la chinthu mu selo linalake, ndipo mtengo wake, kuchuluka kwake, ndi zina zotero zimawonekera mu selo lotsatira. (malingana ndi zomwe tikufuna).

ntchito Onani zofanana ndi , koma sizisamala ngati zomwe zimawoneka zili kumanzere kwenikweni.

Kugwiritsa ntchito mawonekedwe a VIEW

Tiyerekeze kuti tili ndi tebulo lokhala ndi mayina a katundu, mtengo wake, kuchuluka kwake komanso kuchuluka kwake.

Zindikirani: deta kuti asakidwe ayenera kukonzedwa mosamalitsa mu dongosolo kukwera, apo ayi ntchito Onani sizigwira ntchito bwino, ndiye:

• Numeri: … -2, -1, 0, 1, 2…
• Makalata: kuchokera ku A mpaka Z, kuchokera ku A mpaka Z, ndi zina.
• Mawu a Boolean: ZABODZA, ZOONA.

Mutha kugwiritsa ntchito.

Pali njira ziwiri zogwiritsira ntchito ntchitoyi Onani: mawonekedwe a vector ndi mawonekedwe osiyanasiyana. Tiyeni tione bwinobwino aliyense wa iwo.

Njira 1: mawonekedwe a vector

Ogwiritsa ntchito Excel nthawi zambiri amagwiritsa ntchito njirayi. Izi ndi izi:

1. Pafupi ndi tebulo loyambirira, pangani lina, mutu wake uli ndi mizati yokhala ndi mayina "Desired value" и "Zotsatira". M'malo mwake, izi sizofunikira, komabe, ndikosavuta kugwira ntchito ndi ntchitoyi motere. Mayina amitu angakhalenso osiyana.
2. Timayima mu cell momwe tikukonzekera kuwonetsa zotsatira, kenako dinani chizindikirocho "Isert ntchito" kumanzere kwa formula bar.
3. Zenera lidzaonekera patsogolo pathu Ntchito Wizards. Apa timasankha gulu “Mndandanda wa zilembo zonse”, pindani pansi pamndandanda, pezani woyendetsa “ONANI”, ikani chizindikiro ndikudina OK.
4. Zenera laling'ono lidzawonekera pazenera momwe tiyenera kusankha imodzi mwa mindandanda iwiri ya mikangano. Pankhaniyi, timayima pa njira yoyamba, chifukwa. kufotokoza mawonekedwe a vector.
5. Tsopano tiyenera kudzaza mikangano ya ntchitoyo, ndiyeno dinani batani OK:
   • "Lookup_value" - apa tikuwonetsa makonzedwe a selo (timalemba pamanja kapena kungodinanso chinthu chomwe tikufuna patebulo lokha), momwe tidzalowetsamo zomwe kusaka kudzachitidwa. Kwa ife, izi ndi "F2".
   • "Viewed_Vector" - tchulani kuchuluka kwa ma cell omwe kusaka mtengo womwe mukufuna kudzachitidwa (tili ndi izi "A2:A8"). Apa titha kulowetsanso ma coordinates pamanja, kapena kusankha malo ofunikira a ma cell patebulo ndi batani lakumanzere la mbewa.
   • "zotsatira_vector" - apa tikuwonetsa momwe tingasankhire zotsatira zogwirizana ndi mtengo womwe mukufuna (zidzakhala mzere womwewo). Kwa ife, tiyeni "Kuchuluka, ma PC.", ie range "C2:C8".
6. Mu selo ndi chilinganizo, tikuwona zotsatira "#N / A", zomwe zingawoneke ngati zolakwika, koma sizowona kwenikweni.
7. Kuti ntchitoyi igwire ntchito, tiyenera kulowa mu cell "F2" dzina lina (mwachitsanzo, "Sink") zomwe zili mu tsamba loyambira, nkhani sizofunikira. Tikamaliza dinani Lowani, ntchitoyi imangotulutsa zotsatira zomwe mukufuna (tidzakhala nazo 19 pc).Zindikirani: ogwiritsa odziwa angachite popanda Ntchito Wizards ndipo nthawi yomweyo lowetsani chilinganizo cha ntchito mumzere woyenera ndi maulalo ku maselo ofunikira ndi milingo.

Njira 2: Fomu Yopangira

Pankhaniyi, tidzagwira ntchito nthawi yomweyo ndi gulu lonse, lomwe nthawi yomweyo limaphatikizapo magawo onse awiri (zowonedwa ndi zotsatira). Koma pali malire apa: mawonekedwe omwe amawonedwa ayenera kukhala gawo lakutali kwambiri la gulu lomwe laperekedwa, ndipo kusankha kwa zikhalidwe kudzachitidwa kuchokera kumanja kwenikweni. Choncho, tiyeni tiyambe ntchito:

1. Ikani ntchito mu selo kuti muwonetse zotsatira Onani - monga njira yoyamba, koma tsopano timasankha mndandanda wa zotsutsana zamagulu.
2. Tchulani zotsutsana za ntchito ndikudina batani OK:
   • "Lookup_value" - kudzazidwa mofanana ndi mawonekedwe a vector.
   • "Array" - ikani makonzedwe a gulu lonse (kapena sankhani patebulo lokha), kuphatikizapo mndandanda womwe ukuwonedwa ndi dera la zotsatira.
3. Kuti mugwiritse ntchito ntchitoyi, monga njira yoyamba, lowetsani dzina la chinthucho ndikudina Lowani, pambuyo pake zotsatira zake ziziwoneka zokha mu cell ndi formula.

Zindikirani: mndandanda wa ntchito Onani amagwiritsidwa ntchito kawirikawiri, tk. ndi yachikale ndipo imakhalabe m'matembenuzidwe amakono a Excel kuti apitirize kugwirizanirana ndi mabuku ogwirira ntchito omwe adapangidwa m'matembenuzidwe akale a pulogalamuyi. M'malo mwake, ndikofunikira kugwiritsa ntchito ntchito zamakono: VPR и GPR.

Kutsiliza

Choncho, mu Excel pali njira ziwiri zogwiritsira ntchito LOOKUP, malingana ndi mndandanda wa mikangano yosankhidwa (mawonekedwe a vector kapena mawonekedwe osiyanasiyana). Pophunzira kugwiritsa ntchito chida ichi, nthawi zina, mukhoza kuchepetsa kwambiri nthawi yopangira chidziwitso, kumvetsera ntchito zofunika kwambiri.