Ntchito yotsalira kuchokera ku Excel

Anonim

Mulingo wogawana mu Microsoft Excel

Zina mwazomwe zimagwiritsa ntchito mankhwalawa, ntchitoyi imagawidwa ndi kuthekera kwawo. Zimakupatsani mwayi wowonetsa bwino kuti mugawire nambala imodzi kwa selo. Tiyeni tiphunzire zambiri za momwe ntchitoyi imagwiritsidwira ntchito pochita, komanso fotokozerani zovuta zogwira ntchito nazo.

Kugwiritsa ntchito ntchito

Dzinali la ntchitoyi limachokera ku dzina lotsirizira la mawu oti "otsalira kuchokera kugawanika". Wogwiritsa ntchito wa fuko la masamu amakupatsani mwayi wotsalira womwe umakhala ndi magawo azomwe amagawanitsa manambala m'khosi lotchulidwa. Nthawi yomweyo, gawo lonse la zotsatira zake silinafotokozedwe. Ngati zofunikira za manambala omwe ali ndi chizindikiritso chinagwiritsidwa ntchito pogawidwa, ndiye zotsatira za kukonzayo zidzawonetsedwa ndi chizindikiro chomwe chinali pagululi. Syntax ya wothandizira uyu akuwoneka motere:

= Kumanzere (nambala; wogawa)

Monga mukuwonera, mawuwo ali ndi mikangano itatu yokha. "Nambala" ndi yogawanika, yojambulidwa mosiyanasiyana. Kukangana kwachiwiri ndi gawo, monga zikuwonekera ndi dzina lake. Ndiwo womaliza waiwo amatanthauzira chizindikiro kuti zotsatira zokonzanso zidzabwezedwa. Udindo wamikangano ungachite ngati mfundo zofananira ndi zomwe mabuku amakambidwa m'maselo omwe ali nawo.

Onani njira zingapo zoyambira mawu oyambira ndi zotsatira za magawano:

  • Mawu Oyamba

    = Khalani (5; 3)

    Zotsatira: 2.

  • Mawu oyambira:

    = Kumanzere (-5; 3)

    Zotsatira: 2 (popeza gawoli ndi mtengo wabwino).

  • Mawu oyambira:

    = Khalani (5; -3)

    Zotsatira: -2 (popeza gululi ndi mtengo wosangalatsa).

  • Mawu oyambira:

    = Khalani (6; 3)

    Zotsatira: 0 (monga 6 mpaka 3 imagawidwa popanda zotsalira).

Chitsanzo chogwiritsa ntchito wothandizira

Tsopano mwachitsanzo, lingalirani za kugwiritsidwa ntchito kwa wothandizirayo.

  1. Tsegulani buku la Excel, timapanga khungu lowunikira, momwe zotsatira za kusintha kwa data zidzasonyezedwera, ndikudina batani la "Ikani Ntchito", kuyikidwa pafupi ndi mawonekedwe.
  2. Imbani master ntchito ku Microsoft Excel

  3. Masters akuyambitsa ntchito. Timagwira ntchito yopita ku gulu la "masamu" kapena "mndandanda wathunthu wa zilembo". Sankhani dzina "khalani". Tikuunikira ndikudina batani la "Ok" lomwe lili pansi pazenera.
  4. Kusintha kwa mikangano ya ntchito yatsala mu Microsoft Excel

  5. Zenera la zokangana limayambitsidwa. Imakhala ndi minda iwiri yomwe ikugwirizana ndi mfundo zomwe tafotokozazi zomwe tafotokozazi. M'munda wa "nambala ya", lowetsani mtengo womwe udzathetsedwe. M'munda wa "smuder", wofanana ndi kuchuluka kwa manambala omwe gawo lidzakhala. Muthanso kulemba zomwe zili m'maselo omwe mfundo zomwe zafotokozedwazo zili ngati mikangano. Pambuyo pazomwe zimafotokozedwa, dinani batani la "Ok".
  6. Kukangana kwa ntchito kudzasiyidwa ku Microsoft Excel

  7. Kutsatira momwe zochita zomaliza zimachitikira, m'chipindacho, chomwe tidalemba m'ndime yoyamba ya bukuli, chomwe chimawonetsa zotsatira za mankhwala ogwiritsa ntchito, ndiye kuti, gawo lotsala la manambala awiriwo.

Zotsatira za mawonekedwe a data amasiyidwa ku Microsoft Excel

Phunziro: Master of Nurctions

Monga tikuwona, wophunziridwayo amakupatsani mwayi kuti muchotse bwino za manambala omwe ali m'chipinda chotsimikizika. Nthawi yomweyo, njirayi imachitidwa molingana ndi malamulo ofanana ofanana ndi ntchito zina za ntchito yopambana.

Werengani zambiri