Game da wannan tantancewa

Gwajin Ƙwarewar Excel

30 tambayoyimintuna 12

Yi gwajin Gwajin Gwanintar Excel Ƙara koyo game da wannan gwajin

KyautaSakamako nan take · mintuna 12

Menene Gwajin Gwanintar Excel?

Wannan gwajin Excel ne na yanayi: yanayi 30 na irin waɗanda ke faruwa a cikin takardar aiki, kowanne da amsa ɗaya madaidaiciya. Dabarar da aka ja wacce ke dawo da sifili a hankali. Binciken da ke aiki ga wasu layuka amma ba wasu ba. Rukunin da aka jera shi kaɗai, wanda ya raba kowane mutum da albashinsa. Za ku zaɓi amsar da za ta warware matsalar.

Tambayoyi 30 sun shafi fannoni huɗu — dabaru da lissafi, bincike da ishara, sarrafa bayanai, da tsarawa da gabatarwa. Waɗannan fannoni huɗu su ne abin da tallan aiki ke nufi idan ya lissafa “Advanced Excel” ba tare da faɗin waɗanne sassa ba, kuma su ne abin da gwajin masu ɗaukar ma'aikata ke dubawa. Za ku sami maki a kowane ɗayan, don haka raunin fanni zai bayyana a matsayin raunin fanni maimakon a matsayin ƙaramin jimillar maki.

Ci gaba da karatu

Yana ɗaukar kimanin mintuna goma sha biyu, babu rajista, kuma babu wani abu a ciki da ya shafi gwajin hadda. Kowane tambaya tana bayyana matsala kuma tana tambayar abin da za ku yi game da ita, saboda wannan shi ne bambancin tsakanin sanin cewa wata aiki tana nan da kuma amfani da ita a ƙarƙashin matsin lamba.

Abin da Za Ku Gano

Duba wanne daga cikin fannoni huɗu na Excel ne ainihin ke hana ku ci gaba

Samu rarrabuwa ta fanni — dabaru, bincike, sarrafa bayanai, gabatarwa

Gano wane mataki kuke ciki: mai farawa, matsakaici, na gaba, ko gwani

Gwada inda kuke a kan abin da tallace-tallacen aiki ke nufi da “Advanced Excel”

Yadda Tambaya Take Kama

Tambaya ta 1 cikin 30

Sel B1 na ɗauke da adadin VAT. A cikin C2 kun rubuta =B2*B1 kuma kuka ja shi zuwa ƙasa a jeren, amma kowane layi a ƙasan na farko ya dawo da sifili. Menene ba daidai ba?

Sauran 29 bayan wannan · jimlar mintuna 12Amsa wannan

Yadda Yake Aiki

1
Amsa
Tambayoyi 30, mintuna 12. Ci gaba ta atomatik — babu danna Na gaba da hannu.
2
Duba sakamako
Rarrabuwar bayanan martabarku nan take. Kyauta, ana iya rabawa, ana adanawa idan kun shiga.
3
Zurfaɗa
Biyan kuɗi na musamman yana buɗe cikakken rahoto — sana'o'i, ƙarfi, hanyoyin haɓaka.

Tambayoyin da Aka Fi Yawan Yi

Wane matakin Excel wannan gwajin ke auna?

Ya haɗa daga matakin mai farawa zuwa gwani a zama ɗaya. Tambayoyin farko sun shafi abubuwan da kowane mai amfani da takardar aiki ke fuskanta — ishara cikakku, SUMIF, dalilin da yasa lamba ke bayyana a matsayin alamun zane. Na baya-bayan nan sun shiga cikin binciken da ke aiki ko da abokin aiki ya saka wani rukunin, teburan pivot, tabbatar da bayanai da kariyar takardar aiki. Makin ku zai sanya ku a ɗaya daga cikin matakai huɗu, kuma sunayen matakan da gangan aka sa su zama waɗanda tallace-tallacen aiki ke amfani da su.

Ina buƙatar wani nau'in Excel na musamman?

A'a. Tambayoyin sun shafi ƙwarewar takardar aiki ne maimakon wuraren menu, kuma inda sabon aiki ya bayyana, ana kuma karɓar tsohuwar hanyar — tambayar bincike tana karɓar INDEX tare da MATCH kamar yadda take karɓar XLOOKUP. Babu wani abu a nan da ya dogara da Microsoft 365 musamman, kuma babu wani abu da ya dogara da Windows akan Mac.

Shin wannan daidai yake da gwajin Excel na mai ɗaukar ma'aikata?

Yana gwada fannoni huɗu iri ɗaya da yawancin gwaje-gwajen masu ɗaukar ma'aikata ke gwadawa, a cikin tsarin yanayi iri ɗaya, wanda shine dalilin da yasa yake aiki a matsayin shiri. Ba kwafin wani takamaiman gwajin mai ɗaukar ma'aikata bane, kuma samun maki mai kyau a nan ba takardar shaida bace. Abin da yake gaya muku shi ne wanne daga cikin fannoni huɗu za ku rasa maki a ciki, wanda shine abu mai amfani da za a sani mako guda kafin a yi gwaji.

Yaya tsawon lokacin da ake ɗauka?

Kimanin mintuna goma sha biyu. Babu mai ƙidayar lokaci a kan kowace tambaya — gwajin yana auna ko kun san matakin da ya dace, ba saurin da za ku iya danna ba. Kuna iya yin tunani game da tambaya har tsawon lokacin da kuke so.

Dole ne in yi rajista?

A'a. Kuna iya yin gwajin kuma ku ga makin ku da rarrabuwar fannoni ba tare da asusu ba. Ƙirƙirar asusu yana da amfani ne kawai idan kuna son a adana sakamakon don ku iya kwatanta shi da wani gwaji na gaba.

Zan ga waɗanne tambayoyi na yi kuskure?

Za ku sami maki ga kowane ɗayan fannoni huɗu, don haka za ku iya ganin inda asarar ta fi yawa, tare da shawarwarin da aka yi niyya ga matakin da kuka sauka. Gwajin ba ya buga takardar amsa ga kowace tambaya, saboda tambayoyin suna juyawa kuma buga amsoshi zai sa makin ya zama maras amfani ga duk wanda ke amfani da shi don shiri.

Zan iya amfani da wannan don tantance 'yan takara?

Ƙwarewar Excel abu ne da za a iya karewa don tantancewa lokacin da aikin ya buƙace su da gaske, kuma wannan gwaji ne na daidai-ko-kuskure maimakon auna halaye, don haka ba ya ɗauke da matsalolin adalci da gwaje-gwajen nau'in halaye ke da shi. Idan kuna son aika shi ga masu nema kuma ku tattara sakamako a wuri ɗaya, wannan yana gudana ta ɓangaren ɗaukar ma'aikata na JobCannon maimakon ta wannan shafin.

Gwajin Gwanintar Excel

Kafin ku fara

Dokoki da lokaci

Sanarwa