Mabasa "Excel": sei kuvaka

Nhasi tiri kutarisa sei kuvaka girafu pakati mashandiro, "Excel" kutibatsira ichi. Maivawo muchidimbu zvimwe anobatsira zviri spreadsheet mupepeti.

kunyoresa

Saka, tinofanira kuenda mubvunzo sei kuvaka mashandiro ari "Excel". Iri tafura mupepeti ndiyo wakakwana chishandiso basa muhofisi uye kumba. Excel akakwana kuti kushandisa kwaunoita mari kana kuti chakakomba zvemari pakugumisa basa boka guru. The Table Editor ane zhinji features, asi nhasi tichakurukura chimwe chezvinhu vakatsvaka.

kuronga

Tinogona kuvaka girafu zviri basa iri "Eksele" kwakajairika kana chokuita zvakaoma kwemasvomhu kushandiswa. Kuti aite izvi, isu kuita nhanho shomanana. Zarura Excel jira yakachena kana nezvekutanga basa idzva. Gadzira mbiru mbiri. Uyezve, muna wokutanga kunyora nharo. Zvakananga kushanda mu "Eksele" vari kuita rechipiri mbiru. We mberi kusvika padanho rinotevera. Inotaurawo ari mbiru wokutanga X, zvinodiwa kukarukureta uye Plotting. We kuona penguva umo mashandiro zvichabviswa akasikwa.

kukarukureta

Enda rinotevera mbiru. unofanira kunyora payakavakirwa "Excel" basa mairi. Purogiramu ichavakwa yawo hwaro. Vose zvokuimba ose spreadsheet mupepeti rinotanga chiratidzo "=". Application zvinhu gadzirisa zvikuru muitiro paakasika purogiramu. Somuenzaniso, hazvina kunodiwa kuinyora kuti wasarudza nzira mumitsara zvose. Excel Developers vakatora nhoroondo kuti hazvina nyore chaizvo. Saka, chete achizvuzvurudza nzira yemaitiro, uye ichavakwa nerimwe masero. Imi chete vanofanira tinya kuMudzidzisi munda.

Details pamusoro Munotatamura

Tinoenda muitiro kuvaka mashandiro "Eksele". Apedza matanho pamusoro rezasi rworudyi kukona sero richava diki akaenzana. We kutungamirira cursor pairi zvokuti akachinja Pointer. Zvino tinoenderera yakarurama mbeva bhatani uye anodhonzera nzira yemaitiro nokuda inodiwa nhamba nemasero. Somugumisiro, zviito izvi kuchabatsira kuti pave girafu "Excel" basa.

kurayira

We mberi kuti kuvakwa. Mu "Menu" Tab, sarudza "Insert". Pane zvakarongwa zvaungasarudza aronga kushandiswa chinhu "Mufananidzo". Sarudza chimwe iripo pfungwa charts. Click "Next". Tinofanira chete pfungwa chati. Zvino tichazvidudzira iwe sei. Other machati havazobvumirwi kuti asike chete muchimiro nerevane uye nharo. View kukosha anoshandisa nezve zvinodiwa boka nemasero. Somugumisiro pamusoro zviito achamuka mumwe nhaurirano itsva, mairi achizviendesa bhatani "nhamba."

We mberi kusvika padanho rinotevera. Gadzira nhamba uchishandisa "Wedzerai" bhatani. Pachava inotevera hwindo, sezvamakaropafadzwa zvakafanorongwa nzira aida tsika kutsvaga kuvaka runodiwa purogiramu. Kuti kusarudza sero zvakanaka, tinya Thumbnail mufananidzo Excel Spreadsheets. Kutaridzwa zvaida masero ari patafura. Nokukurumidza pasi jira runodiwa basa unoratidzwa, mutengo mu "Eksele" vari akatosarudza, uye anogona chete tinya "Finish." Purogiramu inovakwa. Kana kutsvakwa, zvinogona upi Ukuru uye kunosiyana kunzwisisa.

zvimwe zvinhu

Panyaya pakuvaka mashandiro uye yevhiki navo, isu mawana kunze, asi tafura mupepeti ane zvimwe zvinhu, idzo anofanira kuziva kuti zviite basa naye. Achitaura pamusoro kwemasvomhu nezvaanogona pakati Excel, haukwanise kuenda apfuura kubvisa ishande. Kuverenga musiyano pakati nhamba mbiri, tinya sero umo mugumisiro unoratidzwa. Tinopinda ane vakaenzana chiratidzo. Kana kugutsikana rinotanga notation ichi, Excel anofunga kuti sero anoiswa mune imwe kwemasvomhu kushanda kana mutoo. Pashure akati chiratidzo vakaenzana, pasina kushandisa nzvimbo, kunoderedza nhamba iri vataipa, tikaisa kubvisa kuzozivisa subtracted. Zvadaro vakasundira Enter. Sero kuchava musiyano pakati nhamba mbiri.

Chimbofunga pachake umo mashoko yepakutanga anogona kutorwa mamwe masero patafura. Somuenzaniso, kuti sero B5 zvakaratidzwa mune kwakaderedza nhamba chikamu 55, iri muchitokisi D1, shandai B5. Tinopinda ane vakaenzana chiratidzo. Zvadaro vakasundira muchitokisi D1. The wakaenzana chiratidzo anoteverwa kubatana kune vakasarudzwa kuonana keji. Unogonawo dhayira zvinodiwa kero manually, pasina kushandisa mbeva. Pashure paizvozvo, isu kupinda chiratidzo kubvisa. Kutaridzwa nhamba 55 Press Enter. Next Excel vachangoerekana overenga uye kuratidza mugumisiro.

Kuti bvisa kukosha sero rimwe chete pakati zviratidzi vemamwe, uchishandisa imwe algorithm. Tinopinda ane vakaenzana chiratidzo. Kuwana kero kana kuvaparadzanisa cursor kuti sero umo minuend ukoshi. Pashure paizvozvo, tikaisa kubvisa. Chiyamuro kana negonzo tinya sero umo kukosha subtrahend. Shandisa Enter kiyi. Action zvakakwana.

It watopiwa akanongedza kuti pakuvaka basa iri Excel yemaitiro kushandiswa, saka unofanira kuzivana naye peculiarities zvisikwa zvavo. Kuti aite izvi, pane dzimwe mitemo chaiyo. Pakati vamwe, kuti Masvomhu kubvumira kuti michina muitiro pakuverenga chiyamuro netsika muzvitokisi. Ngatitange kubva pakutanga. Run Excel. Nyatsoongorora kutarisa yaizivikanwa inowanikwa. Tambo Masvomhu akasarudzwa tsamba fx. Zvakanga iye, uye tichizvida.

Kupinda nyore inonyatsoita, vakapiwa mumasero vaida ukoshi nokunyorera kwaari chiratidzo wakanyatsojeka. Mushure zvenzara Pindai, tinoona mugumisiro. Unogona kushandisa nzira dzakawanda kupinda mashoko. Click on chinhu muchitokisi A1. Pinza mariri mumwe ukoshi kuburikidza chakapfuura nazvo chiratidzo "vakaenzana". Kutamira pedyo muchitokisi B1. Kunyatsovatsanangurira nayo chimwe chinhu pamusoro nzira. Tinoenda matanho zvakafanana kusvikira ose parameters apa dambudziko hazvizozivikanwi kupinda tafura. Chiratidzo "akaenzana" kuisa muchitokisi zvakanyanyisa chinhu.

We mberi kusvika padanho rinotevera. Sarudza muchitokisi A1. Pinza mariri arithmetical chiratidzo (nokupesana, chokuwanziridza, Uyezve). Kusarudza mumwe sero, semuenzaniso, B2. Press Enter. Sikai yepakutanga okuti kubudikidza kaviri nekudzvanya pamusoro muchitokisi uye kudzvanya Ctrl uye "apositurofi".

Saka isu afunga kuti vanyengere mashoko "Excel" chinhu, uyewo vakadzidza sei kushanda Masvomhu uye algorithms kuti kungadiwa kuti ichi.