Mutane da yawa masu amfani ba su sani ba game da cikakken ikon Excel. To, a, mun ji cewa shirin don aiki tare da tebur, a'a suna amfani da shi, duba wasu takardu. Na yarda, na kasance mai amfani irin wannan, har sai na yi kuskure a kan wani abu mai sauƙi, aiki mai ban mamaki: lissafin ƙididdigar sel a ɗaya daga cikin allo na cikin Excel. Na yi amfani da shi a kan kalkaleta (yanzu yana da ban dariya: -P), amma wannan lokacin teburin yana da yawa, kuma na yanke shawarar cewa lokaci ya yi da zanyi nazarin akalla guda daya ko guda biyu ...
A cikin wannan labarin zan yi magana game da jimlar lissafin, don sauƙaƙa fahimtar, zamu dubi wasu misalai kaɗan.
1) Don ƙididdige kowane nau'i na lambobi, za ka iya danna kan kowane tantanin halitta a Excel kuma rubuta a ciki, misali, "= 5 + 6", sannan kawai latsa Shigar.
2) Sakamakon baiyi tsawo ba, a cikin tantanin salula inda kuka rubuta wannan tsari sakamakon shine "11". By hanyar, idan ka danna kan wannan tantanin halitta (inda aka rubuta lambar 11) - a cikin wannan tsari (duba hotunan sama, arrow lambar 2, a dama) - ba za ka ga lambar 11 ba, amma duk guda "= 6 + 5".
3) Yanzu za mu yi ƙoƙarin lissafin adadin lambobin daga cikin sel. Don yin wannan, fara zuwa sashe "FORMULA" (menu a sama).
Na gaba, zaɓar ƙwayoyin da yawa waɗanda suke son ƙidayawa (a cikin hotunan da ke ƙasa, nau'o'i uku na riba suna haske a kore). Sa'an nan kuma danna hagu a kan shafin "AutoSum".
4) A sakamakon haka, ƙididdigar kwayoyin baya guda uku za su bayyana a cikin tantanin halitta. Duba screenshot a kasa.
A hanyar, idan muka shiga tantanin salula tare da sakamakon, zamu ga ma'anar da kanta: "= SUM (C2: E2)", inda C2: E2 shine jerin kwayoyin da ake buƙata su zama folded.
5) Ta hanyar, idan kuna son lissafin kuɗin a duk sauran layuka a cikin teburin, to kawai ku kwafa dabarar (= SUM (C2: E2) zuwa duk sauran kwayoyin. Excel zai lissafta duk abin da ta atomatik.
Ko da wannan mahimman hanya mai sauƙi yana sanya Excel kayan aiki mai karfi don ƙididdige bayanai! Ka yi tunanin cewa Excel ba ɗaya bane, amma daruruwan abubuwa masu yawa (ta hanyar, Na riga na yi magana game da aiki tare da mafi mashahuri). Godiya ga su, za ku iya lissafa wani abu da wani abu, yayin da kuna adana yawan lokaci!
Wato, duk kullun.
