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.

Gwada Ƙwarewar ku ta Excel

Gwada ƙwarewar ku ta Excel a fannin dabaru, bincike, sarrafa bayanai da gabatarwa. Tambayoyi 30 na yanayi, sakamako nan take a kowane fanni, kyauta ba tare da rajista ba.

tambayoyi 30mintuna 12

Yi wannan gwajin

Muhimman abubuwa

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.

Karanta ƙari

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.

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 samu