Ngati mudagwirapo ntchito ku Excel, mwayi ndiwe kuti mudaugwiritsa ntchito posungira ndikuwerengera mitundu yosiyanasiyana ya data, monga ma integers, decimals, ndi maperesenti. Komabe, zitha kuchitika kuti muyenera kugwira ntchito mu Excel yokhala ndi mawonekedwe tizigawo wambaMonga 1/2 (sekondi imodzi) kapena 2/3 (ziwiri mwa zitatu), popanda kusinthira ku tizigawo ta decimal.
Mwachitsanzo, tili ndi njira yopangira ma cookie a chokoleti ndipo tikufuna kuyipanga mu Microsoft Excel. Chinsinsicho chimafuna chosakaniza - 1/4 supuni ya tiyi mchere, iyenera kulembedwa mu gawo B, monga gawo wamba.
Tisanayambe kulowa zosakaniza, tiyenera kusintha chinachake pa tebulo lathu. Monga mukukumbukira (kuphatikiza kuchokera m'maphunziro athu), mutha kugwiritsa ntchito masanjidwe apadera pa cell iliyonse mu Excel, mwachitsanzo mtundu wa manambala. Excel ili ndi manambala ang'onoang'ono omwe amakulolani kuti mulowemo ngati tizigawo. Kuti tichite izi, tikuwunikira gawo B ndiyeno pa tabu Kunyumba (Kunyumba) pamndandanda wotsitsa Mtundu wa Nambala (Nambala mtundu) sankhani chinthu Chigawo (Wamng'ono).
Chonde dziwani kuti tikugwira ntchito mu Excel 2013 mu chitsanzo ichi, koma njirayi idzagwira ntchito mu Excel 2010 ndi 2007 mofanana. Kwa Excel 2003 ndi koyambirira, sankhani ma cell omwe mukufuna ndikudina njira yachidule ya kiyibodi Ctrl + 1kukhazikitsa mtundu wa nambala. Chonde dziwani kuti njirayi palibe mu Google Mapepala.
Tsopano popeza mtundu wa manambala wakhazikitsidwa, ndife okonzeka kuyika tizigawo tagawo B.
Dziwani kuti manambala amatha kuwonetsedwa ngati magawo osakanikirana, mu mawonekedwe 2 3 / 4 (magawo awiri ndi atatu). Mukasankha imodzi mwamaselo awa, muwona mu bar ya formula kuti Excel imagwiradi zikhalidwezo ngati ma decimals - mawonekedwe agawo amangosintha momwe nambala imawonekera mu cell. Mwachitsanzo, 2 3 / 4 ndi chimodzimodzi 2.75.
Mutha kugwiritsa ntchito ziwerengero zofananira pama formula ndi magwiridwe antchito. Tangoganizani kuti Chinsinsichi ndi cha magawo awiri a makeke. Ngati mukufuna kupanga ma cookie anayi, mutha kuwirikiza maphikidwewo pogwiritsa ntchito Excel. Ngati tikufuna kuwirikiza kawiri kuchuluka kwa mchere mu Chinsinsi, tiyenera kuchulukitsa mtengo wa cell B2 ndi 2; formula idzakhala motere: =B2*2. Kenako titha kukopera fomula kumaselo ena omwe ali mugawo C posankha selo ndi kukoka chogwirizira chodzaza.
Tili ndi zikhalidwe zatsopano zamaphikidwe athu owirikiza kawiri! Monga mukuwonera, kugwiritsa ntchito mitundu yotereyi mu Excel kumapangitsa kuti zikhale zosavuta kugwira ntchito ndi tizigawo, makamaka ngati simukufuna kusintha magawo wamba kukhala ma decimals.