Yadda ake ninkawa a cikin Excel. Umarnin kan yadda ake yin multiplication a cikin Excel

Marubucin Excel shiri ne na ayyuka da yawa wanda ke ba ku damar aiwatar da adadi mai yawa na ƙididdiga daban-daban. Shirin yana aiwatar da ayyukan ƙididdiga masu sauƙi da kuma hadadden lissafin lissafi. Wannan labarin zai dubi hanyoyi da yawa don aiwatar da ninkawa a cikin maƙunsar rubutu.

Yin ninkawa a cikin shirin

Dukanmu mun san sarai yadda ake yin irin wannan aikin lissafi kamar ninkawa akan takarda. A cikin maƙunsar bayanai, wannan hanya kuma mai sauƙi ce. Babban abu shine sanin daidaitattun algorithm na ayyuka don kada ku yi kuskure a cikin lissafin yayin aiki tare da adadi mai yawa.

"*" - alamar alama tana aiki azaman ninkawa a cikin Excel, amma ana iya amfani da aiki na musamman maimakon. Don ƙarin fahimtar batun, la'akari da tsarin ninkawa ta amfani da takamaiman misalai.

Misali 1: ninka lamba da lamba

Samfurin ma'auni 2 shine ma'auni kuma bayyananne misali na aikin lissafi a cikin maƙunsar rubutu. A cikin wannan misali, shirin yana aiki azaman madaidaicin ƙididdiga. Tafiya tayi kama da haka:

1. Muna sanya siginan kwamfuta akan kowane tantanin halitta kyauta kuma zaɓi shi ta latsa maɓallin linzamin kwamfuta na hagu.
2. Shigar da alamar "=" a ciki, sannan rubuta lamba ta 1.
3. Mun sanya alamar samfurin a cikin nau'i na alamar alama - "*".
4. Shigar da lamba ta 2.

5. Danna maɓallin "Enter" akan maballin.
6. Shirya! A cikin sashin da kuka shigar da tsari mafi sauƙi, an nuna sakamakon ninkawa.

Muhimmin! A cikin ma'auni na Excel, lokacin aiki tare da ƙididdiga, ƙa'idodin fifiko iri ɗaya suna aiki kamar yadda ake amfani da lissafi na yau da kullun. A wasu kalmomi, ana aiwatar da rarraba ko samfur da farko, sannan a ragi ko ninka.

Lokacin da muka rubuta magana tare da maɓalli akan takarda, alamar ninkawa yawanci ba a rubuta ba. A cikin Excel, ana buƙatar alamar ninkawa koyaushe. Misali, ɗauki darajar: 32+28(5+7). A cikin ɓangaren na'ura mai sarrafa tebur, muna rubuta wannan magana a cikin tsari mai zuwa: =32+28*(5+7).

Ta danna maɓallin "Shigar" akan madannai, za mu nuna sakamakon a cikin tantanin halitta.

Misali 2: ninka tantanin halitta da lamba

Wannan hanya tana aiki bisa ga ƙa'idodi iri ɗaya kamar misalin da ke sama. Babban bambancin ba samfurin lambobi guda biyu bane, amma haɓaka lamba ta ƙimar da ke cikin wani tantanin halitta na maƙunsar rubutu. Misali, muna da faranti wanda ke nuna farashin naúrar kowane samfur. Dole ne mu lissafta farashin tare da adadin guda biyar. Tafiya tayi kama da haka:

1. Mun saita siginan kwamfuta a cikin sashin da ya wajaba don yin ninkawa. A cikin wannan misali, wannan shine cell C2.
2. Mun sanya alamar "=".
3. Muna tuƙi a cikin adireshin tantanin halitta wanda lambar farko ta kasance. A cikin wannan misali, wannan shine cell B2. Akwai hanyoyi guda biyu don tantance wannan tantanin halitta. Na farko shi ne shigarwa mai zaman kanta ta amfani da madannai, na biyu kuma yana danna wannan tantanin halitta yayin da yake cikin layi don shigar da tsarin.
4. Shigar da alamar ninkawa a cikin hanyar alamar alama - "*".
5. Shigar da lamba 5.

6. Danna maɓallin "Shigar" akan maballin kuma sami sakamakon ƙarshe na lissafin.

Misali 3: ninka tantanin halitta ta tantanin halitta

Ka yi tunanin cewa muna da tebur tare da bayanan da ke nuna adadin samfuran da farashin su. Muna buƙatar lissafin adadin. Jerin ayyuka don ƙididdige adadin a zahiri bai bambanta da hanyar da ke sama ba. Babban bambanci shi ne cewa yanzu ba mu shigar da kowane lambobi da kanmu ba, kuma don ƙididdigewa muna amfani da bayanai kawai daga sel na tebur. Tafiya tayi kama da haka:

1. Sanya siginan kwamfuta a sashin D2 kuma zaɓi shi ta latsa maɓallin linzamin kwamfuta na hagu.
2. Shigar da magana mai zuwa a cikin mashin dabara: = B2*C2.

3. Danna maɓallin "Shigar" kuma sami sakamakon ƙarshe na lissafin.

Muhimmin! Ana iya haɗa tsarin samfurin tare da ayyuka daban-daban na lissafi. Ƙididdigar ƙididdiga na iya samun adadi mai yawa na ƙididdiga, ƙwayoyin da aka yi amfani da su, da ƙima iri-iri. Babu ƙuntatawa. Babban abu shi ne a hankali rubuta ma'auni na maganganu masu rikitarwa, kamar yadda za ku iya rikicewa da yin lissafin da ba daidai ba.

Misali 4: ninka shafi da lamba

Wannan misali ci gaba ne na misali na biyu, wanda yake a baya a wannan labarin. Mun riga mun sami sakamakon ƙididdigewa na ninka ƙimar lamba da sashin don cell C2. Yanzu kuna buƙatar ƙididdige ƙimar a cikin layin da ke ƙasa ta hanyar shimfiɗa dabarar. Bari mu dubi wannan dalla-dalla. Tafiya tayi kama da haka:

1. Matsar da siginan linzamin kwamfuta zuwa ƙananan kusurwar dama na sashin tare da sakamakon da aka nuna. A wannan yanayin, shi ne cell C2.
2. Lokacin da aka shawagi, siginan kwamfuta ya juya zuwa gunki mai kama da ƙaramar ƙari. Riƙe maɓallin linzamin kwamfuta na hagu kuma ja shi zuwa layin ƙasan tebur.
3. Saki maɓallin linzamin kwamfuta na hagu lokacin da kuka isa layin ƙarshe.

4. Shirya! Mun sami sakamakon ninka dabi'u daga shafi na B ta lamba 5.

Misali na 5: ninka shafi ta shafi

Wannan misalin ci gaba ne na misali na uku da aka tattauna a baya a wannan talifin. Misali na 3, an yi la'akari da tsarin ninka wani yanki zuwa wani. Algorithm na ayyuka kusan bai bambanta da misalin da ya gabata ba. Tafiya tayi kama da haka:

1. Matsar da siginan linzamin kwamfuta zuwa ƙananan kusurwar dama na sashin tare da sakamakon da aka nuna. A wannan yanayin shi ne cell D
2. Lokacin da aka shawagi, siginan kwamfuta ya juya zuwa gunki mai kama da ƙaramar ƙari. Riƙe maɓallin linzamin kwamfuta na hagu kuma ja shi zuwa layin ƙasan tebur.
3. Saki maɓallin linzamin kwamfuta na hagu lokacin da kuka isa layin ƙarshe.

4. Shirya! Mun sami sakamakon samfurin shafi B ta shafi C.

Yana da kyau a kula da yadda tsarin shimfida tsarin, wanda aka bayyana a cikin misalai guda biyu, yana aiki. Misali, cell C1 ya ƙunshi dabara =A1*V1. Lokacin jan dabarar zuwa ƙananan cell C2, zai ɗauki nau'i =A2*V2. A wasu kalmomi, daidaitawar tantanin halitta yana canzawa tare da wurin da sakamakon da aka nuna.

Misali na 6: ninka shafi ta tantanin halitta

Bari mu bincika hanyar ninka shafi ta tantanin halitta. Misali, wajibi ne a lissafta rangwame don jerin samfuran da ke cikin shafi B. A cikin sashin E2, akwai alamar ragi. Tafiya tayi kama da haka:

1. Da farko, a cikin ginshiƙi C2, mun rubuta dabarar samfuran sassan B2 ta E2. Tsarin tsari yayi kama da haka: = B2*E2.

2. Kada ku danna maɓallin "Shigar" nan da nan, tunda a yanzu ana amfani da nassoshi dangi a cikin dabarar, wato, yayin aiwatar da kwafin zuwa wasu sassan, canjin daidaitawa da aka tattauna a baya zai faru (sashin B3 zai ninka ta E3. ). Cell E2 ya ƙunshi ƙimar rangwame, wanda ke nufin cewa dole ne a gyara wannan adireshin ta amfani da cikakkiyar tunani. Don aiwatar da wannan hanya, dole ne ka danna maɓallin "F4".
3. Mun ƙirƙiri cikakken bayani saboda yanzu alamar “$” ta bayyana a cikin dabarar.

4. Bayan ƙirƙirar cikakkun hanyoyin haɗin gwiwa, danna maɓallin "Shigar".
5. Yanzu, kamar yadda yake a cikin misalan da ke sama, muna shimfiɗa dabarar zuwa ƙananan ƙwayoyin cuta ta amfani da abin cika.

6. Shirya! Kuna iya bincika daidaiton lissafin ta hanyar kallon dabarar a cikin tantanin halitta C9. Anan, kamar yadda ya wajaba, ana yin ninka ta sashin E2.

PRODUCT mai gudanarwa

A cikin ma'auni na Excel, ana iya aiwatar da samfurin masu nuna alama ba kawai ta hanyar tsara tsarin ba. Akwai aiki na musamman a cikin editan da ake kira PRODUCT, wanda ke aiwatar da ninka dabi'u. Tafiya tayi kama da haka:

1. Muna danna sashin da muke son aiwatar da lissafin kuma danna maɓallin "Saka aikin" kusa da layin don shigar da ƙididdiga.

2. Tagan "Wizard Aiki" zai bayyana akan allon. Fadada jeri kusa da rubutun "Kategori:" kuma zaɓi kashi "Mathematical". A cikin toshe "Zaɓi aiki:" muna samun umarnin PRODUCT, zaɓi shi kuma danna maɓallin Ok.

3. Tagan muhawara yana buɗewa. Anan zaka iya ƙididdige lambobi na yau da kullun, dangi da cikakkun bayanai, da kuma gardama da aka haɗa. Kuna iya shigar da bayanai da kanku ta amfani da shigarwar hannu ko ta ƙayyade hanyoyin haɗi zuwa sel ta danna su tare da maɓallin linzamin kwamfuta na hagu akan takardar aikin.

4. Cika duk gardama kuma danna Ok. A sakamakon haka, mun sami samfurin sel.

Muhimmin! Ana iya barin "Mayen Ayyuka" idan mai amfani da maƙunsar bayanai na Excel ya san yadda ake shigar da dabara don ƙididdige magana da hannu.

Bidiyo akan ayyukan ninkawa a cikin Excel

Idan umarnin da ke sama da misalai ba su taimaka muku aiwatar da ninkawa a cikin maƙunsar rubutu ba, to kallon bidiyon na iya taimaka muku:

Bidiyo, ta yin amfani da takamaiman misalai, ya bayyana hanyoyin da yawa na ninkawa a cikin shirin, don haka yana da daraja kallo don ganin yadda ake aiwatar da waɗannan matakai.

Kammalawa

Yana yiwuwa a aiwatar da ninkawa a cikin ma'auni na Excel ta hanyoyi masu yawa. Kuna iya ninka darajar sel, ninka lamba ta wani yanki, yi amfani da nassoshi na dangi da cikakkun bayanai, sannan kuyi amfani da aikin lissafi. Samfurin. Godiya ga irin wannan zaɓi mai yawa, kowane mai amfani zai iya zaɓar hanya mafi dacewa don kansa kuma ya yi amfani da shi lokacin aiki tare da bayanai a cikin maƙunsar rubutu.