Mmene Mungagwiritsire ntchito Google Spreadsheets NTCHITO Ntchito

Pali njira zingapo zowunikira chizoloŵezi chachikulu kapena, monga momwe zimatchulidwira kawirikawiri, chiwerengero, kuti zikhale zoyenera.

Kawirikawiri chiwerengero cha chizoloŵezi chapakati ndi mathemati amatanthawuza - kapena osawerengeka owerengeka - ndipo amawerengedwa powonjezera chiwerengero cha ziwerengero palimodzi ndikugawanika ndi chiŵerengero cha nambala imeneyo. Mwachitsanzo, pafupifupi 4, 20, ndi 6 anawonjezerapo pamodzi ndi 10 monga momwe tawonedwera mzere 4.

Google Spreadsheets ili ndi ntchito zambiri zomwe zimapangitsa kuti zikhale zosavuta kupeza zina mwa zomwe amagwiritsidwa ntchito kwambiri. Izi zikuphatikizapo:

• Ntchito YOPHUNZITSIRA - imapeza chiwerengero cha masamu kumatanthauza mndandanda wa nambala.
• Ntchito ya MEDIAN - imapeza mtengo wapakati pa mndandanda wa manambala.
• Ntchito ya MODE - imapeza phindu lofala kwambiri mndandanda wa manambala.

Syntax ndi Zokangana Zogwira Ntchito

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Mawu omasulira a NTCHITO ntchito ndi:

= AVERAGE (nambala_1, nambala_2, ... nambala_30)

• nambala_1 - (yofunika) deta kuti ikhale yofanana ndi ntchitoyo
• nambala_2 kuti iwerengere_30 - (zosankha) zina zowonjezera chiwerengero cha deta zikhale zofanana. Chiwerengero chazowonjezera chololedwa ndi 30

Chiwerengero cha nambala chingakhale nacho:

• Mndandanda wa manambala omwe angakhalepo;
• Maumboni a magulu kumalo a deta mu worksheet;
• Mafotokozedwe osiyanasiyana a selo;
• Dzina lotchulidwa.

Zindikirani: Mauthenga ndi mauthenga omwe ali ndi ma Boolean (TRUE kapena FALSE) amanyalanyazidwa ndi ntchito monga momwe akuwonetsera mzere 8 ndi 9 mu chithunzi pamwambapa.

Ngati maselo omwe alibe kanthu kapena ali ndi malemba kapena ma Boolean amasinthidwa kuti akhale ndi manambala, ambiri adzabwezeretsanso kuti athe kusintha.

Maselo osajambulidwa ndi Zero

Pokhudzana ndi kupeza malingaliro ambiri mu Google Spreadsheets, pali kusiyana pakati pa zopanda kanthu kapena maselo opanda kanthu ndi omwe ali ndi chiwerengero cha zero.

Maselo osajambulidwa amanyalanyazidwa ndi NTCHITO YOPHUNZITSIRA, yomwe ingakhale yopindulitsa kwambiri chifukwa imapeza kuti maselo osagwirizana a deta ndi ovuta kwambiri monga momwe akuwonedwera mzere 6 pamwambapa.

Maselo okhala ndi chiwerengero cha zero, komabe, akuphatikizidwa pafupipafupi monga momwe tawonedwera mzere 7.

Kupeza NTCHITO YA Ntchito

Mofanana ndi ntchito zina zomangirila mu Google Spreadsheets, ntchito YOULEMBA ikhoza kupezeka mwa kuwonekera Khalani > Ntchito m'mamenyu kuti mutsegula mndandanda wa ntchito zomwe amagwiritsidwa ntchito zomwe zikuphatikizapo NTCHITO YA ntchito.

Mwinanso, chifukwa chimagwiritsidwa ntchito, njira yowonjezera kuntchito yowonjezeredwa ku barugulu la pulogalamu, kuti zikhale zosavuta kupeza ndi kugwiritsira ntchito.

Chithunzi pa toolbar cha ichi ndi ntchito zina zambiri zotchuka ndi kalata yachi Greek Sigma ( Σ ).

Google Spreadsheets CHIPHUNZITSO CHA NTCHITO Chitsanzo

Masitepe omwe ali m'munsiwa akuthandizira momwe mungaloweretse ntchito YAM'MBUYO YOTSATIRA yomwe ikuwonetsedwa mu mzere wachinayi mu chitsanzo pa chithunzi pamwambapa pogwiritsa ntchito njira yopita ku NTCHITO imene tatchula pamwambapa.

Kulowa Ntchito YOTSATIRA

1. Dinani pa selo D4 - malo omwe zotsatira zake zidzasonyezedwe.
2. Dinani pazithunzi zamagetsi pazomwe mungapange pa tsamba lothandizira kutsegula mndandanda wa ntchito.
3. Sankhani Avereji kuchokera pa mndandanda kuti muikepo kopanda kanthu kopanda kanthu mu selo D4.
4. Sungani maselo A4 ku C4 kuti mulowetse maumboniwa ngati zifukwa za ntchitoyi ndi kukanikiza fungulo lolowamo mukhiyi.
5. Nambala 10 iyenera kuoneka mu selo D4. Ichi ndi chiwerengero cha nambala zitatu - 4, 20, ndi 6.
6. Mukasindikiza pa selo A8 ntchito yonse = AVERAGE (A4: C4) ikuwonekera pa bar barolomu pamwamba pa tsamba.

Mfundo:

• Maselo aumwini, m'malo mokhalapo mosalekeza akhoza kuwonjezeredwa ngati zotsutsana koma selo lililonse liyenera kukhala losiyana ndi chida.
• Pambuyo polowera ntchitoyo, ngati kusintha kumapangidwira ku deta mu maselo osankhidwa, ntchitoyo, mwachisawawa, imangobwerezanso kuti iwonetse kusintha.