Gano darajar darajar tare da Ayyuka na AVEL ta Excel

Yi amfani da aikin AVERAGE don gano mahimmancin mahimmanci don lissafin lambobi

Harshen lissafi, akwai hanyoyi da yawa na auna yawan al'amuran tsakiya ko, kamar yadda ake kira da yawa, matsakaicin matsayi na dabi'u. Wadannan hanyoyi sun haɗa da mahimmanci na mahimmanci , tsakiyar tsakiya , da kuma yanayin .

Mafi yawan ma'auni na ma'auni na tsakiya shine ƙididdigar mahimmanci - ko sauƙi - kuma an ƙidaya ta ƙara wata ƙungiyar lambobi tare sannan rarraba ta ƙidaya waɗannan lambobin. Alal misali, yawancin 2, 3, 3, 5, 7, da 10 ne 30 kashi 6, wanda shine 5.

Don yin sauki don auna ma'auni na tsakiya, Excel yana da ayyuka masu yawa waɗanda zasu lissafta dabi'un da aka fi amfani dasu da yawa. Wadannan sun haɗa da:

• Ayyukan aikin AVERAGE - sami alamar lissafi don lissafin lambobi
• Ayyukan MEDIAN - sami adadi na tsakiya ko tsakiyar cikin lissafin lambobi
• Ayyukan MODE - sami yanayin ko mafi yawan lamarin da ke faruwa a jerin lambobi

HALITAR GABATARWA DA GUDATARWA

Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .

Haɗin aikin aikin AVERAGE shine:

= KYAU (Number1, Number2, ... Number255)

• Number1 - (da ake buƙatar) bayanan da za a iya ɗaukar nauyi ta wurin aiki.
• Number2 zuwa Lamba 255 - (Zaɓuɓɓuka) ƙarin ƙarin bayanai don haɗa su cikin matsakaici. Matsakaicin adadin shigarwar da aka yarda shi ne 255.

Wannan hujja zata iya ƙunsar:

• Jerin lambobin da za su kasance masu girma;
• Siffofin da aka kwatanta da sassan layi na bayanai a cikin takardun aiki;
• Hanyoyin tantancewar salula;
• Sunan mai suna.

Sakamakon aikin gyaran fuska

Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:

1. Rubuta cikakken aikin , irin su = BINCIKE (C1: C7) a cikin sashin layi na aiki;
2. Shigar da aikin da muhawara ta amfani da akwatin maganganun aikin;
3. Shigar da aikin da muhawara ta amfani da hanyar hanya ta hanyar Excel.

BABI NA GASKIYA Hanya

Excel tana da gajeren hanya don shigar da aikin AVERAGE - wani lokaci ana kiransa AutoAverage saboda ƙungiyarsa tare da fasalin AutoSum mafi kyau - wanda yake a kan shafin shafin shafin rubutun .

Alamar a kan kayan aiki don wadannan da wasu wasu ayyukan da aka fi sani shine rubutun Helenanci Sigma ( Σ ). Ta hanyar tsoho, aikin AutoSum yana nunawa kusa da gunkin.

Sashen na atomatik na sunan yana nufin gaskiyar cewa lokacin da aka shiga ta amfani da wannan hanya, aikin yana zaɓi abin da ya gaskata shi ne kewayon kwayoyin da za'a tara ta wurin aikin.

Gano darajar tare da AutoAverage

1. Danna kan tantanin C8 - wurin da aka nuna sakamakon aikin;
2. Kamar yadda aka nuna a cikin hoton da ke sama, kawai C7 ya kamata a zaɓa ta hanyar aikin - saboda gaskiyar cewa C6 cell ne ta blank;
3. Zaɓi madaidaicin madaidaicin don aikin C1 zuwa C7 ;
4. Latsa maɓallin shigarwa akan keyboard don karɓar aikin;
5. Amsar 13.4 ya kamata ya bayyana a C8 cell.

Ayyukan HUKUMI NA Excel misali

Matakan da ke ƙasa suna rufe yadda za a shiga aikin AVERAGE da aka nuna a jere hudu a cikin misalin a cikin hoton da ke sama ta amfani da gajeren hanya zuwa aikin AVERAGE da aka ambata a sama.

Shigar da aikin NASIHIYA

1. Danna kan tantanin halitta D4 - wurin da za a nuna sakamakon dabara;
2. Danna kan shafin shafin shafin rubutun
3. Danna maɓallin ƙasa kusa da maɓallin AutoSum akan rubutun don buɗe jerin abubuwan da aka sauke
4. Danna kalma Tsakanin cikin jerin don shigar da aikin AVERAGE a cikin cell D4
5. Danna kan Aikace- aikace a kan kayan aiki a sama da don buɗe jerin abubuwan da aka saukewa;
6. Zaži Matsakaici daga lissafi don sanya kwafin kwafin aikin a cikin dakin D4;
7. Ta hanyar tsoho, aikin zai zaɓi lambobi a cikin tantanin halitta D4;
8. Canja wannan ta hanyar nuna sauti A4 zuwa C4 don shigar da waɗannan nassoshi kamar yadda zance akan aikin kuma latsa maɓallin Shigar da ke keyboard;
9. Yawan lamba 10 ya kamata ya bayyana a cell D4. Wannan shine adadin lambobi uku - 4, 20, da 6;
10. Lokacin da ka danna kan salula A8 cikakken aikin = BABI NA AYA (A4: C4) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.

Ka riƙe waɗannan bayanan a hankali:

• Kwayoyin mutum guda, maimakon wani ci gaba mai ɗorewa za'a iya ƙara su a matsayin muhawara amma dole ne a raba raƙuman tantanin halitta ta hanyar wakafi.

• Rubutun rubutu da kwayoyin da ke dauke da dabi'un Boolean (TRUE ko FALSE) da kuma kwayoyin da ke cikin kullun suna watsi da aikin kamar yadda aka nuna a layuka 6, 8 da 9 a sama.

• Bayan shigar da aikin, idan an yi canje-canjen zuwa bayanai a cikin sel da aka zaɓa, aikin, ta tsoho, ta sake saukewa ta atomatik don nunawa canji.

Ta yaya AutoAverage Zabi Yanayin Magana

• Ƙunbin tsohuwar ya haɗa da kwayoyin da ke dauke da lambobi, adadin lambobin da aka zaɓa an katse ta da kwayar da take ɗauke da rubutu ko cell salula.
• An tsara aikin aikin AVERAGE don a shigar a kasan wani shafi na bayanai ko kuma a gefen dama na jere na bayanai. Ya dubi na farko don yawan bayanai a sama sannan sannan a hagu.
• Tun da aikin AVERAGE shine, a sakamakon haka, zatowa a kewayon da ya zaɓa domin Magana mai lamba, wannan zaɓin ya kamata a bincika don daidaitawa kafin danna maɓallin Shigar da ke keyboard don kammala aikin.

Cells Blank vs. Zero

Idan ya zo ne da gano ƙananan dabi'u a Excel, akwai bambanci tsakanin nau'in kullun ko kullun da kuma waɗanda suke dauke da nau'i maras nauyi.

Kwayoyin raguwa ba su kula da aikin AVERAGE, wanda zai iya zama mai amfani tun lokacin da ya sa gano ƙayyadadden ƙwayoyin marasa jigilar bayanai kamar yadda aka nuna a jere na 6 a sama.

Sel ɗin da ke dauke da darajar zabin, duk da haka, an haɗa su cikin matsakaicin kamar yadda aka nuna a jere 7.

Nuna Zeros

Ta hanyar tsoho, Excel yana nuna nau'i a cikin sel tare da darajar zabin - kamar sakamakon lissafin, amma idan an kashe wannan zaɓin, waɗannan ƙwayoyin sun bar blank, amma har yanzu an haɗa su cikin ƙididdiga.

Don kunna wannan zaɓi daga:

1. Danna kan fayil na rubutun don nuna jerin zaɓin menu;
2. Danna Zabuka a cikin jerin don buɗe akwatin maganganu na Excel Zabuka .
3. Danna maɓallin Babba a cikin hagu na hannun hagu na maganganun don ganin samfuran da aka samo.
4. A cikin dama na hannun dama, a cikin Zaɓuɓɓukan Nuni don wannan ɓangaren ƙungiya suna nuna akwati don Nuna samame a cikin sel wanda ke da kwakwalwar ajiyar zabin .
5. Don nuna nau'ikan nau'ikan (0) a cikin kwayoyin sun tabbatar da cewa nuna Zama a cikin sel wanda ke da kwakwalwar ajiyar zabin da aka zaba.