He aha ka Polokalamu Electreadread Spreadsheet a he aha ka mea i hoʻohanaʻia no?
- Definition: Ma mua, he pakuhi ka, a hiki i kēia manawa, he pepa i hoʻohanaʻia e mālama a hōʻike i nāʻikepili kālā.
ʻO kahi polokalamu lolopalapala'elekole he polokalamu kamepiula pilikino e like me Excel, OpenOffice Calc, a iʻoleʻo Google Sheets e hana ana i kahi lapaʻau pepa.
E like me ka pepa pepa, hoʻohanaʻia kēiaʻano noi no ka mālamaʻana, hoʻonohonohoʻana a me ka mālamaʻana i nāʻikepili , akā, he mauʻano a me nā mea hana i kūkuluʻia, e like me nāʻoihana , nā hoʻopihapiha, nā kāmera, a me nā lako hanaʻikepili. e hana a mālama i nāʻikepili nui.
Ma Excel a me nā hoʻohana hou aku, ua hāʻawiʻia nā waihona pāpili pāpili hoʻokahi i mau pepa hana .
Kāleka Pūnaewele Pakili
Ke nānāʻoe i kahi papahana pāʻani ma ka nānā - e like me ka mea iʻikeʻia ma ka kiʻi ma luna -ʻikeʻoe i kahi papaʻaina a iʻole ka laina o nā lālani a me nā koluma . ʻO nā laina kaulike e heluʻia e nā helu (1,2,3) a me nā poʻomoli vertical me nā huapalapala o ka pī'āpā (A,ʻoʻoe ka papahana baseB, ceaC). No nā koluma ma kahi o 26, uaʻikeʻia nā koluma e nā lekaʻelua aʻoi aʻe paha e like me AA, AB, AC.
ʻO ka māhele waena ma waena o ke kolamu a me ka lālani he pahu kikoʻikuʻi liʻiliʻi iʻikeʻia heʻokoʻa puna kai. ʻO kahi pūnaewele no ka mālamaʻana i nāʻikepili i ka pakuhi. Hiki i kēlā me kēia keʻena ke hoʻopaʻa i kahi helu a iʻole kahi kikowaena.
ʻO ka hōʻuluʻulu o nā laina a me nā pou o nā pūnaewele e hana i kahi pepa pepa - e pili ana i kahiʻaoʻao aʻaoʻao paha i loko o kahi pukamahi.
Ma muli o ka waihona hana i nā mano o nā pūnaewele, hāʻawiʻia kēlā me kēia i kahi kuhi pūnaewele aiʻole kahi helu pūnaewele no kaʻikeʻana. ʻO ka papa helu pūnaewele he hui pūʻia o ka leka kaomi a me ka helu helu e like me A3, B6, AA345 .
No laila, i ka hoʻopili pūʻana i kahi papahana, e like me Excel, hoʻohanaʻia e hana i nā papa hana lima me kahi aʻoi aku paha o nā pepa hana i nā kolamu a me nā lālani o nā pūnaewele mālama waihona.
Nā'IpiliʻIkepili, Nā'Akuhi, a me nā Hana
ʻO nāʻano o nāʻikepili i hoʻopaʻaʻia e kahi pūnaewele he mau helu a me ka'ōlelo.
ʻO nā kulekele - kekahi o nā kikola nui o ka pūnaewele kahepa - hoʻohanaʻia no ka heluʻana - pinepine i nāʻikepili i loko o nā pūnaewele'ē aʻe. Aia nā papahana pūnaewele i kahi o nā hanana i kūkuluʻia i kapaʻia he mau hana i hiki ke hoʻohanaʻia e hoʻokō i nāʻano hana likeʻole a paʻakikī.
Ka mālamaʻana i nāʻikepili kālā ma kahi Pālepa
Hoʻohui pinepineʻia ka laha e mālama i nāʻikepili kālā. ʻO nā kulekele a me nā hana i hiki ke hoʻohanaʻia no nāʻikeʻike kālā,ʻo:
- Ke hanaʻana i nāʻoihana'elematika maʻamau e like me ke kolamu kolamu a me nā lālā o nā huahelu.
- Keʻike nei i nā waiwai e like me ka uku a me ka poho.
- Ke helu nei i nā hoʻolālā hoʻololi no nā loina a i nā moraki paha.
- Keʻike nei i kaʻawelike, ka palena, a iʻole nā palena palenaʻole i loko o kahi hōʻaia o nāʻikepili.
Nā hoʻohana'ē aʻe no kahi pulla pūnaewele
ʻO nā hana maʻamau'ē aʻe e hiki ke hoʻohana i kahi pakuhi no kēia mau mea:
- ka hōʻike 'ana a iʻole kaʻikepili hōʻailona e kōkua i nā mea hoʻohana i kaʻikeʻana i nā loiloiʻikepili;
- ke hoʻokaʻina a me ka kānanaʻana i nāʻikepili no ka huliʻana i nāʻike kiko'ī
ʻOiai ua hoʻohana nuiʻia nā paʻipaʻi no ka hūnāʻikepili,ʻaʻole lākou i nā mana like no ka hoʻolālāʻana a iʻole e noiʻi i nāʻikepili e like me nā polokalamu noi pūnaewele holoʻokoʻa piha.
Hiki ke hoʻokomoʻia nāʻike i mālamaʻia i loko o kahi waihona pūnaewele i nā hōʻikeʻike pūnaewele, i nā palapala pūnaewele, aiʻole i paʻiʻia ma ka palapala pūnaewele.
ʻO ka Original & # 34; Killer App & # 34;
ʻO nā pīpī i nā polokalamu killer mua no nā polokalamu pilikino. ʻO nā papahana papahana mua, e like me VisiCalc (i hoʻokuʻuʻia i ka makahiki 1979) a me Lotus 1-2-3 (i hoʻokuʻuʻia i ka makahiki 1983),ʻo ia ke kumu nui o ka uluʻana o ka laulima o nā kamepiula e like me Apple II a me ka IBM PC i mea hana waiwai.
Ua hoʻokuʻuʻia ka puka mua o Microsoft Excel i ka makahiki 1985 a ua holo wale ma nā kamepiula Macintosh wale nō. No ka mea i hanaʻia no ka Mac, ua hoʻokomoʻia i kahiʻokoʻa mea hoʻohana pūnaewele i hoʻokomo i ka hukiʻana i nā menus a me ka heluʻana a kaomi i nā pūnaewele me ka hoʻohanaʻana i kahi kī. ʻAʻole hiki i ka makahiki 1987 ka hoʻokuʻuʻiaʻana o ka Windows version (Excel 2.0).