Maitiro ekubvisa mudzi muExcel. Mirayiridzo ine zvidzitiro zvekubvisa mudzi muExcel

Muspredishiti, mukuwedzera kune akajairwa arithmetic mashandiro, unogona zvakare kuita midzi yekubvisa. Kubva kuchinyorwa iwe unozodzidza chaizvo maitiro ekuita masvomhu akadaro muspredishiti.

Nzira yekutanga: kushandisa ROOT opareta

Kune akasiyana akasiyana-siyana evashandisi muExcel spreadsheet. Kubvisa mudzi ndechimwe chezvinhu zvinobatsira. Iyo general fomu yebasa inoita seizvi: =MUDZI(nhamba). Kufamba:

1. Kuti uite kuverenga, unofanirwa kuisa fomula musero risina chinhu. Imwe sarudzo ndeyekupinda mubhawa yeformula, wakambosarudza chikamu chinodiwa.
2. Mumabhuraketi, iwe unofanirwa kuisa chiratidzo chenhamba, mudzi watichawana.

3. Mushure mekuita zvese manipulations, tinya "Enter" kiyi iri pane keyboard.
4. Ready! Mhedzisiro inodiwa inoratidzwa muchikamu chakasarudzwa.

Teerera! Panzvimbo pechiratidzo chenhamba, unogona kupinda varongi vesero uko iyo nhamba pachayo iripo.

Kuisa fomula uchishandisa Function Wizard

Zvinogoneka kushandisa fomula rinoshandisa kubviswa kwemidzi kuburikidza nehwindo rinokosha rinonzi "Insert function". Walkthrough:

1. Isu tinosarudza chikamu chatinoronga kuita masvomhu ese atinoda.
2. Dzvanya pabhatani re "Insert Function", iro riri pedyo nemutsara wekupinda mafomula, uye rinotaridzika se "fx".

3. Hwindo diki rainzi "Insert Function" rairatidzwa pachiratidziri. Isu tinoratidza runyoro rwakakura rwuri padivi pechinyorwa "Chikamu:". Mune inodonhedza pasi rondedzero, sarudza chinhu "Mathematics". Muhwindo "Sarudza basa:" tinowana basa "ROOT" uye sarudza nekudzvanya LMB. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

4. Iwindo idzva rainzi "Function Arguments" rakaratidzwa pahwindo, iro rinofanira kuzadzwa nedata. Mundima ye "Nhamba", iwe unofanirwa kuisa chiratidzo chenhamba kana kungoratidza kurongeka kwechikamu umo inochengeterwa ruzivo rwenhamba.

5. Mushure mekuita zvese manipulations, tinya bhatani "OK".
6. Ready! Muchikamu chakafanosarudzwa, mhedzisiro yeshanduko yedu yakaratidzwa.

Kuisa basa kuburikidza ne "Formulas" chikamu

Nhanho-ne-nhanho tutori inoita seizvi:

1. Isu tinosarudza sero kwatinoronga kuita masvomhu ese atinoda.
2. Isu tinotamira kuchikamu che "Formulas", chiri pamusoro peiyo spreadsheet interface. Isu tinowana block inonzi "Function Library" uye tinya pane "Math" chinhu.

3. Ndaza refu yemarudzi ese emabasa emasvomhu yaburitswa. Isu tinowana mushandisi anonzi "ROOT" uye tinya pairi LMB.

4. Iwindo re "Function Arguments" rinoonekwa pachiratidziro. Mundima ye "Nhamba", iwe unofanirwa kuisa chiratidzo chenhamba uchishandisa kiibhodhi, kana kungoratidza kurongeka kwesero uko kunochengeterwa ruzivo rwenhamba.
5. Mushure mekuita zvese manipulations, tinya pakanzi "OK".

6. Ready! Muchikamu chakafanosarudzwa, mhedzisiro yeshanduko yedu yakaratidzwa.

Nzira yechipiri: kutsvaga mudzi nekusimudza kune simba

Iyo nzira iri pamusoro inobatsira kuburitsa zviri nyore sikweya midzi yechero kukosha kwenhamba. Iyo nzira iri nyore uye iri nyore, asi haigone kushanda nemacubic mataurirwo. Kuti ugadzirise dambudziko iri, zvinodikanwa kusimudza chiratidzo chenhamba kune simba rechikamu, apo nhamba ichave imwe, uye denominator ichava kukosha kunoratidza dhigirii. Iyo yakajairika fomu yeukoshi iyi ndeiyi inotevera: =(Nhamba)^(1/n).

Kubatsira kukuru kweiyi nzira ndeyekuti mushandisi anogona kubvisa mudzi wechero dhigirii nekungochinja "n" mudhinomineta kune nhamba yaanoda.

Pakutanga, funga kuti fomula yekubvisa square root inotaridzika sei: (Chiverengo)^(1/2). Zviri nyore kufungidzira kuti ipapo fomula yekuverenga iyo cube mudzi ndeiyi inotevera: =(Nhamba)^(1/3) etc. Ngationgororei maitiro aya nemuenzaniso chaiwo. Iyo yekufamba inotaridzika seiyi:

1. Semuenzaniso, zvakakosha kubvisa cube root yenhamba yenhamba 27. Kuti tiite izvi, tinosarudza sero yakasununguka, tinya pairi neLMB uye isa kukosha kunotevera: =27^(1/3).

2. Mushure mekuita zvese manipulations, tinya "Enter" kiyi.

3. Ready! Mune sero yakasarudzwa kare, mhedzisiro yeshanduko yedu yakaratidzwa.

Zvakakosha kucherechedza kuti pano, sepaunenge uchishanda neROOT opareta, panzvimbo yenhamba chaiyo kukosha, unogona kupinda kurongeka kwesero rinodiwa.

mhedziso

Mune spreadsheet Excel, pasina chero matambudziko, unogona kuita mashandiro ekubvisa mudzi kubva zvachose chero kukosha kwenhamba. Iko kugona kwespredishiti processor inobvumidza iwe kuti uite masvomhu kuti ubvise mudzi wemadhigirii akasiyana (square, cubic, zvichingodaro). Pane nzira dzinoverengeka dzekuita, saka mushandisi wega wega anogona kuzvisarudzira zvakamunakira iye.