Ntchito za Excel: momwe mungamangire

Lero tiwone m'mene tingakhalire ndandanda ya ntchitoyi, Excel idzatithandiza pa izi. Ndiponso, tiyeni tiwone mwachidule zinthu zina zothandiza m'dongosolo la spreadsheet.

Ntchito

Choncho, tiyeni tipite ku yankho la funsoli, momwe tingamangire ntchito mu Excel. Mkonzi wa spreadsheet ndi chida chabwino chogwira ntchito ku ofesi komanso kunyumba. Excel ndi yokwanira kuwerengera ndalama zanu kapena kupanga mfundo zazikulu zachuma za ntchito ya kampani yaikulu. Mkonzi wa spreadsheet ali ndi mwayi wambiri, koma lero udzakhala wotchuka kwambiri.

Kujambula grafu

Tikhoza kupanga graph ya ntchito mu "Excel" ya mtundu wamba kapena kutchula ntchito zovuta kwambiri masamu. Kuti muchite izi, chitani masitepe angapo. Tsegulani pepala lopanda kanthu laling'ono kapena yambani polojekiti yatsopano. Pangani zipilala ziwiri. Powonjezerapo, tikulemba mkangano. Mwachindunji ntchito mu "Excel" yawonjezedwa ku gawo lachiwiri. Pitani ku gawo lotsatira. Mu ndime yoyamba, timafotokozera zizindikiro za X zomwe zimafunikira kuti ziwerengedwe, komanso kulingalira kwa graph. Fotokozani gawo limene ntchitoyi idzalengedwe.

Kuwerengetsa

Pitani ku gawo lotsatira. M'pofunika kulemba momwe ntchitoyo ikuyendera "Excel". Mndandandawo udzamangidwa pa maziko ake. Zonsezi za mkonzi wa tebulo zinayamba ndi chizindikiro "=". Zomwe zimagwiritsidwa ntchitoyi zimapangitsa kuti pakhale ndondomeko yopanga grafu. Mwachitsanzo, simukusowa kulowa mndandanda wosankhidwa mmizere yonse. Otsatsa a Excel amaganizira kuti sizingakhale zabwino. Choncho, tambani chingwecho, ndipo chidzamangidwa mumaselo onse. Ingolani pa malo omwe mukugwirizana nawo.

Zambiri pakutambasula

Timapitiriza ntchito yomanga ntchito mu "Excel". Mutatha kumaliza masitepewa, kanyumba kakang'ono kamangowoneka kumbali ya kumanja ya selo. Timalozera cholozerapo kuti pointer yake isinthe. Tsopano gwiritsani botani lamanja la mouse ndi kutambasula ndondomeko ku chiwerengero chofunikira cha maselo. Zotsatira zake, zochita zoterezi zingathandize kukhazikitsa ndondomeko ya ntchito ya Excel.

Malangizo

Timayendetsa molunjika kumangidwe. Mu "Menyu" sankhani tabu "Insert". Pa mndandanda wa zosankhidwazo timagwiritsa ntchito "Chithunzi". Timasankha zithunzi zonse zomwe zilipo. Dinani "Zotsatira". Timafunikira chithunzi cha mfundo. Tsopano ife tikuuzani chifukwa chake. Mawonekedwe ena sadzakulolani kupanga ntchito imodzi ndi ndewu. Mtundu wamtengo wapatali umagwiritsira ntchito liwu la maselo ofunikira. Chifukwa cha zochita zomwe chatsopano chatsopano chikuwonekera, mmenemo timatsindikiza batani "Row".

Pitani ku gawo lotsatira. Pangani mndandanda pogwiritsa ntchito batani "Add". Firiji lotsatila lidzawoneka, momwe ife tikukhalira njira yofufuzira zoyenera zofunika kuti timange grafu yofunikira. Kuti musankhe maselo omwe mukufuna, dinani pa thumbnail ya Excel spreadsheet. Tchulani maselo ofunika omwe ali patebulo. Posakhalitsa ntchito yofunika imawoneka pa pepala, mtengo mu "Excel" wayamba kale, ndipo umangotsala kuti ulimbikire "Kuchita". Grafu yamangidwa. Ngati mukufuna, zikhoza kukhala zazikulu komanso zovuta zosiyana.

Zina

Ndi funso la kumanga ntchito ndi ma grafu kwa iwo, tinasankha, koma mkonzi wa spreadsheet ali ndi zinthu zina zomwe muyenera kudziwa kuti zingakhale zosavuta kugwira nawo ntchito. Polankhula za mwayi wa masamu wa Excel, simungathe kudutsa ntchito yochotsa. Kuti muone kusiyana pakati pa manambala awiri, dinani selo limene zotsatira zake zidzawonetsedwa. Timayambitsa chizindikiro chofanana. Ngati nkhaniyi ikuyamba ndi ndondomeko iyi, Excel akuganiza kuti selo ili ndi ntchito yeniyeni ya masamu kapena ndondomeko. Pambuyo pa chizindikiro chofanana, popanda kugwiritsa ntchito danga, timayimba chiwerengero chochepetsedwa, kuika chotsitsa ndi kulowa mkati. Pambuyo palowetsani. Kusiyana pakati pa nambala ziwiri kumawoneka mu selo.

Ganizirani njira yomwe deta yamagetsi imayenera kutengedwa kuchokera ku maselo ena. Mwachitsanzo, kuti selo B5 liwonetse nambala yocheperachepera 55, ili mu selo D1, dinani pa B5. Timayambitsa chizindikiro chofanana. Pambuyo pake yesani selo D1. Chizindikiro cha kufanana chidzatsatiridwa ndi kutchulidwa kwa selo losankhidwa ndi ife. Mukhozanso kulembetsa adiresi pamanja, popanda kugwiritsa ntchito mbewa. Zitatha izi, timayambitsa chizindikiro chochotsa. Tchulani nambala 55. Dinani kulowera. Kenaka Excel imadziwerengera ndi kusonyeza zotsatira.

Pofuna kuchotsa mtengo wa selo limodzi kuchokera kumzake, timagwiritsa ntchito njira yolumikizirana yomweyi. Timayambitsa chizindikiro chofanana. Timayipeza adiresi kapena timagwiritsa ntchito chithunzithunzi mu selo yomwe ili ndi phindu lochepa. Pambuyo pake, sankhani. Lowani kapena dinani selo limene mtengo wochotsedwera ulipo. Gwiritsani chinsinsi cha Kulowa. Ntchito yatha.

Zatchulidwa kale pamwambapa kuti mayendedwewa amagwiritsidwa ntchito pomanga ntchito ku Excel, motero m'pofunika kudziŵa bwino zomwe zimachitika pachilengedwe chawo. Pali malamulo angapo awa. Zina mwazinthu, mayendedwe amakulolani kuti muzitha kupanga pokhapokha ndondomeko ya kuwerengera miyezo yomwe inalowa mu maselo. Tiyeni tiyambe kuyambira pachiyambi pomwe. Kuthamanga Excel. Onetsetsani mosamala mawonekedwe odziwika bwino. Mndandanda wa machitidwe akufotokozedwa ndi makalata fx. Ndizo zomwe tikusowa.

Kuti tipeze njira yowonjezera, timafotokozera kufunika kwa selo mwa kulemba chizindikiro chofanana pamaso pake. Pambuyo pokanikiza Enter, tiwona zotsatira. Mukhoza kugwiritsa ntchito njira zingapo zolowera deta. Dinani pa selo yopanda kanthu A1. Timayika phindu linalake, kutsogolo ndi chizindikiro "chofanana". Timadutsa ku selo lotsatira B1. Timafotokozera chinthu china cha chiwerengerocho. Timapitirizabe kuchita zomwezo mpaka zonse zomwe zikuperekedwa mu ntchitoyi zalowa mu tebulo. Chizindikiro chofanana chimayikidwa mu selo lopanda kanthu.

Pitani ku gawo lotsatira. Timasankha selo A1. Tikayika mmenemo chizindikiro cha masamu (kugawa, kuchulukitsa, kuwonjezera). Timasankha selo lina, mwachitsanzo, B2. Dinani ku Enter. Pangani mawonekedwe oyambirira mwa kuwirikiza kawiri pa selo ndikukakamiza Ctrl ndi "Apostrophe".

Kotero ife tinalingalira momwe tingamangire graph ya ntchito ya Excel, ndipo taphunziranso momwe tingagwiritsire ntchito ndi machitidwe ndi machitidwe omwe angafunike pa izi.