Chinhu chinoshanda kwazvo muMicrosoft Excel chirongwa ndechekusarudzwa kweparamende. Asi, kwete chero mushandisi anoziva nezve kugona kwechishandiso ichi. Nayo, unogona kusarudza kukosha kwekutanga, kusundidzira kubva pamhedzisiro yekupedzisira kuti iwe unofanirwa kuzadzisa. Ngatitsvagei kushandisa nzira yekushandisa paramende yekusarudza chimiro muMicrosoft Excel.
Hunhu hwebasa
Kana ikarerutswa kuti utaure nezve kukosha kwekusarudzwa kwesangano kweparamende, ipapo iri kunoreva chokwadi kuti mushandisi anogona kuverenga iyo inodiwa data kuti uwane imwe mhedzisiro. Ichi chimiro chakafanana neyisarudzo chishandiso chishandiso, asi isarudzo yakareruka. Inogona chete kushandiswa mune imwechete mafomula, kureva kuti, kuverenga muchero wega wega waunoda kumhanya nguva dzese ichi chishandiso zvakare. Uye zvakare, iyo paramende yekusarudza basa inogona kungoshanda chete pane imwe chete yekutanga sumo, uye imwe yezvinoreva, iyo inoratidza, sechishandiso chine mashoma mashandiro.Basa rekushandisa mukuita
Kuti unzwisise kuti ichi chiitiko chinoshanda sei, zvakanakira kutsanangura zvakaringana pameso anoshanda. Tichatsanangura basa rechishandiso pamuenzaniso weMicrosoft Excel 2010 Chirongwa, asi zviito Algorithm zvinowanzoitika mune imwe shanduro dzechirongwa ichi, uye muna 2007.
Tine tafura yekubhadhara yekubhadhara uye vashandi vebhizinesi. Kune chete awards evashandi. Semuenzaniso, bhonasi reumwe wavo - Nikolaev A. D, ndeye 6035.68 rubles. Zvakare, zvinozivikanwa kuti premium inoverengerwa nekuwanza muhoro pane iyo coeff fialient ye 0.28. Isu tinofanirwa kuwana muhoro wevashandi.
Kuti utange basa iri mu "data" tab, tinya pa "kuongororwa" kana ", iyo iri mu" kushandira nedata "block block pane tepi. Menyu inoonekwa menyu yaunoda kusarudza "kusarudzwa kweparamende ...".
Mushure meizvozvo, iyo paramende yekusarudza hwindo rinovhura. Mu "Isa muchitokisi" munda, iwe unofanirwa kutaura kero yayo ine data rekupedzisira dzinozivikanwa kwatiri, izvo zvatichagadzirisa kuverenga. Mune ino kesi, ichi chishandiswa iyo mushandi wemushandi weNikolaev akaiswa. Kero yacho inogona kutsanangurwa nemurume nekuchengetedza marongero ayo kune iyo inoenderana munda. Kana iwe ukaona zvakaoma kuita, kana funga nezvazvo, wobva wangotinya muchitokisi chaunoda, uye kero ichaiswa mumunda.
Iyo "kukosha" munda inoda kutsanangura kukosha kwakananga kwemberi. Kwatiri, ichave 6035.68. Mu "kushandura sero" munda, unopinda kero yayo ine iyo data sosi yatinofanira kuverenga, iyo ndeyekuti, huwandu hwemari yevashandi. Izvi zvinogona kuitwa nenzira dzakafanana dzatakataura pamusoro: kutyaira marongero nemaoko, kana tinya pachiteshi chakakodzera.
Kana zvese paramende hwindo data izere, tinya pane bhatani OK.
Mushure meizvozvo, kuverenga kwacho kunoitwa, uye tsika dzakasarudzwa dzakakodzera mumasero, sezvakataurwa newindo rinokosha ruzivo.
Kuvhiya kwakadaro kunogona kuitirwa mamwe mitsara yetafura, kana kukosha kweiyo mari yehuwandu hwebasa rose rinozivikanwa.
Kugadzirisa equations
Uye zvakare, kunyangwe ichi chisiri chimiro cheichi chiitiko, chinogona kushandiswa kugadzirisa equations. Chokwadi, mudziyo wekusarudza paramende wakashandiswa zvinobudirira kushandiswa chete neruremekedzo kune equations neinoshamisa.
Ngatiti isu tine equation: 15x + 18x = 46. Rekodha chikamu chayo chekuruboshwe, senzira, mune imwe yemasero. Kana iri chero formula muExle, pamberi peiyo equation, tinoisa chiratidzo "=". Asi, panguva imwe chete, panzvimbo yechiratidzo x, iwe unoisa kero yemusero umo mhedzisiro yeiyo kukosha kwaunoda icharatidzwa.
Kwedu isu, isu tinonyora formula muC2, uye kukosha kwaunoda kucharatidzwa muB2. Saka, rekodhi iri muC2 cell ichave iyo inotevera fomu: "= 15 * B2 + 18 * b2".
Isu tinotanga basa nenzira imwe chete sezvakatsanangurwa pamusoro, kureva kuti, nekudzvanya "kuti kana" "patepi," uye kusarudzwa kwe "kusarudzwa kweparamende ...".
Mune paramende yekusarudza hwindo rinovhura, mu "kuisa muchitokisi" munda, taura kero yatairondedzera equation (C2). Mu "kukosha", pinda nhamba yacho makumi matanhatu, nekuti tinoyeuka kuti equation inyaya inotevera: 15x + 18x = 46. Mu "shanduko yesero" munda, tinonyora kero iyo x kukosha kweX kunoratidzwa, kureva, chaizvo, mhinduro ye equation (b2). Mushure mekunge tapinda iyi data, tinya iyo "OK" bhatani.
Sezvauri kuona, Microsoft Excel akabudirira kugadzirisa equation. Iyo x kukosha kweX ichave 1.39 munguva.
Pashure pokuongorora paramende yekusarudza chishandiso, takazoona kuti yakapusa, asi panguva imwe chete inobatsira uye yakakodzera nyaya yekuwana nhamba isingazivikanwe. Inogona kushandiswa zvese zvevaviri patafura computa uye kugadzirisa equations ney isingazivikanwe. Panguva imwecheteyo, maererano nekushanda, yakaderera kune imwe yakasimba solutions chishandiso.