Buga Ayyukan Gudanarwar Ayyukan Kira na Gidan Gida

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. Don yin sauƙi ga mahimmanci, ma'anar Office Calc yana da aikin ginawa, wanda ake kira, ba abin mamaki ba, aikin AVERAGE.

01 na 02

Yaya aka kiyasta Ƙimar

An ƙidaya matsakaici ta hanyar ƙara ƙungiyar lambobi tare sannan rarraba ta ƙidaya waɗannan lambobin.

Kamar yadda aka nuna a misali a cikin hoton da ke sama, matsakaita ga dabi'un: 11, 12, 13, 14, 15, da 16 yayin da raba ta 6, wanda shine 13.5 kamar yadda aka nuna a C7 cell.

Maimakon gano wannan a hannunka da hannu, duk da haka, wannan tantanin yana dauke da aikin AVERAGE:

= KYAU (C1: C6)

wanda ba wai kawai ya gano mahimmanci na mahimmanci na halin kirki na yanzu ba amma zai ba ku amsar da aka sabunta yayin da bayanai a wannan rukuni na kwayoyin sun canza.

02 na 02

Haɗin Hanya GABA

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara

Haɗin aikin aikin AVERAGE shine:

= GARANTI (lamba 1; lambar 2; ... number30)

Zuwa lambobi 30 za a iya ƙaddara ta aikin.

BABI NA GASKIYAR GABAWA

lambar 1 (da ake buƙata) - bayanan da za a iya ɗauka ta hanyar aiki

lamba 2; ... number30 (na zaɓi) - ƙarin bayanai da za a iya karawa zuwa ƙayyadaddun lissafi.

Ƙwararrun zasu iya ƙunsar:

• jerin lambobin da za su kasance masu girma
• tantanin halitta sunyi bayanin wuri na bayanan a cikin takardun aiki
• wani kewayon tantancewar salula

Misali: Nemi Ƙimar Darajar Kayan Lissafi

1. Shigar da bayanai masu zuwa cikin sel C1 zuwa C6: 11, 12, 13, 14, 15, 16;
2. Danna kan tantanin halitta C7 - wurin da za a nuna sakamakon;
3. Danna maɓallin Wizard na Wurin aiki - kamar yadda aka nuna a cikin hoton da ke sama - don buɗe akwatin maganganun Wizard ;
4. Zaɓi Bayanan lissafi daga Jerin jerin sunayen;
5. Zaži Matsakaici daga lissafin Yanki;
6. Danna Next;
7. Sanya sassa C1 zuwa C6 a cikin maƙallan don shigar da wannan zangon cikin akwatin maganganu a layin jigidar lamba 1 ;
8. Danna Ya yi don kammala aikin kuma rufe akwatin maganganu;
9. Lambar "13.5" ya kamata ya bayyana a cikin tantanin halitta C7, wannan shine matsakaici ga lambobin da aka shiga cikin sassan C1 zuwa C6.
10. Lokacin da ka danna kan maɓallin C7 cikakken aikin = BABI NA (C1: C6) ya bayyana a cikin layin rubutun sama da takardun aiki

Lura: Idan bayanan da kake so a matsakaici shine yadawa a cikin kwayoyin halitta a cikin takardun aiki maimakon a cikin wani shafi ko jere, shigar da kowane tsinkayyar tantancewar mutum a cikin akwatin maganganun a kan layin jigilar bambanci - kamar lambar 1, lambar 2, lamba 3.