Kana iwe wakamboshanda muExcel, mukana ndewekuti wakaishandisa kuchengeta uye kuita maverengero pamhando dzakasiyana dze data, senge integers, decimals, uye muzana. Nekudaro, zvinogona kuitika kuti iwe unofanirwa kushanda muExcel nehunhu mufomu zvidimbu zvakajairikaZvakaita se 1/2 (sekondi imwe) kana 2/3 (zvikamu zviviri muzvitatu), pasina kutendeukira kuzvikamu zvegumi.
Semuenzaniso, isu tine resipi yechokoreti chip makuki uye tinoda kuifometa muMicrosoft Excel. Recipe inoda chisanganiswa - 1/4 teaspoon munyu, inofanira kunyorwa muchikamu B, sechikamuwo zvacho.
Tisati tatanga kupinda muzvigadzirwa, tinoda kuchinja chimwe chinhu patafura yedu. Sezvaunorangarira (kusanganisira kubva muzvidzidzo zvedu), unogona kushandisa yakakosha fomati kune chero sero muExcel, kureva nhamba yemafomati. Excel ine chidimbu chenhamba fomati iyo inokutendera iwe kuti uise kukosha sezvikamu. Kuti tiite izvi, tinosimbisa column B uye ipapo pane tab Home (Kumba) mune yekudonha pasi rondedzero Nhamba Format (Nhamba fomati) sarudza chinhu Chidimbu (Minor).
Ndapota cherechedza kuti tiri kushanda muExcel 2013 mumuenzaniso uyu, asi nzira iyi ichashanda muExcel 2010 uye 2007 nenzira imwecheteyo. YeExcel 2003 uye yapfuura, sarudza maseru aunoda uye wodzvanya nzira yekudimbudzira keyboard Ctrl + 1kuseta mafomati enhamba. Ndokumbira utarise kuti sarudzo iyi haiwanikwe muGoogle Sheets.
Ikozvino iyo fomati yenhamba yakamiswa, tagadzirira kuisa zvikamu muchikamu B.
Ziva kuti nhamba dzinogona kuratidzwa sezvikamu zvakasanganiswa, muchimiro 2 3 / 4 (makota maviri nematatu). Kana ukasarudza rimwe remaseru aya, uchaona mubhari yeformula kuti Excel inonyatso inobata izvo zvakakosha semadecimals - chimiro chechikamu chinongochinja maratidziro anoita nhamba musero. Semuyenzaniso, 2 3 / 4 zvakangofanana ne 2.75.
Iwe unogona kushandisa zvikamu zvakajairika mumafomula uye mabasa. Fungidzira kuti iyi resipi ndeyemasevhisi maviri ekiki. Kana iwe uchida kugadzira mana masevhisi emakuki, unogona kaviri resipi uchishandisa Excel. Kana tichida kuwedzera kaviri huwandu hwemunyu mune resipi, tinofanira kuwedzera kukosha kwesero B2 2; formula ichava seizvi: = B2 * 2. Uye ipapo isu tinokwanisa kukopa fomura kune mamwe maseru mukoromo C nekusarudza sero uye nekukwevera iyo autofill mubato.
Tine hutsva hutsva hwemhando yekubika yedu yakapetwa kaviri! Sezvauri kuona, kushandisa nhamba yakadaro fomati muExcel kunoita kuti zvive nyore kushanda nezvikamu, kunyanya kana iwe usingade kushandura zvakajairwa mafractions kuita decimals.