首页 | 本学科首页   官方微博 | 高级检索  
相似文献
 共查询到20条相似文献,搜索用时 515 毫秒
1.
黄利红 《科教文汇》2010,(21):89-89,92
Excel中的数组公式在生产中非常有用,尤其在不能使用工作表函数直接得到结果时,数组公式显得特别重要,它可建立产生多值或对一组值而不是单个值进行操作的公式。  相似文献   

2.
Excel为用户提供了大量的函数,这些函数都是Excel预定义的公式.函数处理数据的方式与公式处理数据的方式是相同的,而使用函数可以使公式变得更加简单.Excel统计函数为方便灵活地进行数据统计提供了可能.  相似文献   

3.
金连鸿 《中国科技纵横》2011,(2):236-236,234
Excel是教学工作中最常用的办公自动化软件,但是作为一套办公自动化软件,教师们在使用它时,仅仅是进行简单的表格制作、数据录入、总分计算和排版等'更多的是手动输入,Excel的办公自动化没能得到更好的体现。本文旨在深入介绍Excel函数和公式的运用,使用一些函数和公式编辑出具有一定功能的“自动化”统计表。  相似文献   

4.
闫保权 《内江科技》2007,28(9):41-42
本文通过用excel自动统计学生成绩的实例,介绍了excel函数、数组公式、加密、模板等功能的应用,以期读者在应用中挖掘它的功能,提高工作效率  相似文献   

5.
用Excel进行水文频率计算的方法研究   总被引:1,自引:0,他引:1  
提出了利用Excel软件绘制海森机率格纸、进行频率计算、点绘经验频率点据、绘制P-Ⅲ型理论频率曲线以及优选水文变量统计参数的方法。该方法不需要编写程序代码,直接利用Excel软件内置的函数进行计算,利用Excel软件图表功能输出频率曲线图。  相似文献   

6.
《科技风》2015,(15)
Microsoft Excel强大的数据处理功能是基于公式和函数来实现的。本文旨在帮助初学者快速掌握Excel中公式与函数的应用。  相似文献   

7.
裴清福  孙航 《黑龙江科技信息》2011,(22):138+137-138,137
Excel是日常工作中经常使用的数据处理软件,由于具有强大的数据处理能力被广泛地应用于自动处理、统计计算、制作图表等领域。在奖学金评定中,使用Excel的函数、统计汇总以及模板功能,可以帮助班主任轻松准确的完成评定工作。  相似文献   

8.
Excel软件具有强大的数据统计分析功能。笔者介绍了Excel函数IF、UPPER、COUNTIF、SUM在图书馆日常统计报表使用方法,并以2012年~2016年图书文献馆藏量和借阅量为例,阐述了回归方程和相关指数的计算方法及图书馆借阅量的预测趋势曲线绘制方法与流程。实践证明,Excel在图书馆文献资源统计管理中能缩短统计报表编制周期,减少冗余劳动量,提高工作效率,具有较好的推广价值,应将Excel统计函数更好地融入图书馆日常统计或办公中去。  相似文献   

9.
蒋勇 《黑龙江科技信息》2009,(24):70-70,130
Excel是一个具有强大统计和计算功能的表格数据管理软件,它的数据统计计算和数据处理的各种功能能够有效地处理人们日常工作中遇到的很多的数据表,主要讲述了利用Excel软件制作成电子版的试卷分析,图文并茂地展现了Excel的数据计算功能和图表的使用以及数据表格的打印问题。解决了学校中的试卷分析一直是手工统计绘制易出错,不美观的缺点。  相似文献   

10.
Excel是最广泛的办公软件之一,它具有友好的人机交互界面和强大的数据处理功能。通过Excel在教师课酬结算中的数据规范、数据汇总、数据查询、数据透视等几个应用实例,论述了挖掘利用Excel强大的数据处理能力,灵活运用其内置函数、公式等功能,能准确高效解决教师课酬结算中大量数据处理的问题,有效提高工作效率和管理水平。  相似文献   

11.
CAS should stick to the principle of rendering service to, and giving impetus for, the development of China's science enterprise by making S&T innovations, said CAS President LU Yongxiang. The CAS president made the remarks in a recent talk to communicate the gist of the winter session of the Party's Leading-member Group at CAS, which was held from 7 to 11 January in Beijing.  相似文献   

12.
This study examined how students who had no prior experience with videoconferencing would react to the use of videoconferencing as an instructional medium. Students enrolled in seven different courses completed a questionnaire at the beginning of the semester and again at the end of the semester. Students at the origination and remote sites did not differ in their reactions toward videoconferencing but there was a significant difference for gender. Women reacted less favorably to videoconferencing. Compared to the beginning of the semester, students reported significantly less positive attitudes toward taking a course through videoconferencing at the end of the semester. There were no significant differences in students' attitudes toward videoconferencing across courses at the beginning of the semester but there were significant differences across the courses at the end of the semester. The results suggest the need for better preparation for both students and instructors.  相似文献   

13.
With great care, Dr. ZHOU Zhonghe takes out a package wrapped by cotton tissue from a drawer and says: "This is the gem of our collections: the fossil of a bird that lived 125 million years ago!" Then, pointing at a tiny mound, he explains: "Look, this is the claw and that is the head. It was in the egg shell and ready to hatch ... The species fell into a family of waterside inhabitants."  相似文献   

14.
Ajoint study by Prof. ZHANG Zhibin from the CAS Institute of Zoology and his co-workers from Norway, US and Swiss have indicated that historical outbreaks of migratory locusts in China were associated with cold spells, suggesting that China's projected climate warming could decrease the pest's numbers. The study was published in Proceedings of theNational Academy of Sciences on 17 September, 2007.  相似文献   

15.
A computer-mediated group is a complex entity whose members exchange many types of information via multiple means of communication in pursuit of goals specific to their environment. Over time, they coordinate technical features of media with locally enacted use to achieve a viable working arrangement. To explore this complex interaction, a case study is presented of the social networks of interactions and media use among members of a class of computer-supported distance learners. Results show how group structures associated with project teams dominated who communicated with whom, about what, and via which media over the term, and how media came to occupy their own communication niches: Webboard for diffuse class-wide communication; Internet Relay Chat more to named others but still for general communication across the class; and e-mail primarily for intrateam communication. Face-to-face interaction, occurring only during a short on-campus session, appears to have had a catalytic effect on social and emotional exchanges. Results suggest the need to structure exchanges to balance class-wide sharing of ideas with subgroup interactions that facilitate project completion, and to provide media that support these two modes of interaction.  相似文献   

16.
Electronic data interchange (EDI) provides means for interorganizational communication, creates network externalities, requires an advanced information technology (IT) infrastructure, and relies on standards. In the diffusion of such innovations, institutional involvement is imperative. Such institutions contain governmental agencies, national and global standardization organizations, local government, and nonprofit private organizations like industry associations. The last type of organizations we call intermediating institutions. They intermediate or coordinate ("inscribe") the activities of a group of would-be adopters. Unfortunately, little is known of how these organizations shape the EDI diffusion trajectory. In this article we examine one specific type of intermediating organizations?industry associations?and how they advanced the EDI diffusion process in the grocery sectors of Hong Kong, Denmark and Finland. We identify six institutional measures, placed into a matrix formed by the mode of involvement (influence vs. regulation) and the type of diffusion force (supply push vs. demand pull), that can be mobilized to further the EDI diffusion. Industry associations were found to be active users of all these measures to varying degrees. Their role was critical especially in knowledge building, knowledge deployment, and standard setting. Furthermore, institutional involvement varied due to policy and cultural contingencies and power dependencies.  相似文献   

17.
The increasing prospects of digital piracy has prompted the perceived need by electronic publishers to adopt technical systems of protection, and governments to reform their copyright laws. This article is a preliminary study of the management of intellectual property by electronic publishers, defined as those involved in the production of online databases, and CD-ROMs. It focuses on three main issues: (1) how electronic publishers view the increasing threat of piracy; (2) the methods of protection employed to protect intellectual property in digital format; and (3) the importance of technological protection of intellectual property in electronic publications. The analysis is based on a sample of 23 UK electronic publishers. The interviews revealed an interesting assortment of protection methods and did not show that technological protection was a preferred way. Instead, the means of protection, in addition to copyright law, comprised niche markets, pricing, trust, bad publicity, and nontechnical and technical means.  相似文献   

18.
Long-standing conflict between domain name registrants and trademark holders prompted the Internet Corporation for Assigned Names and Numbers (ICANN) to create a global, mandatory arbitration procedure known as the Uniform Dispute Resolution Policy (UDRP). The UDRP has been used in 2166 cases involving 3938 domain names as of 1 November 2000. The policy gives the initiator of a complaint, generally a trademark holder, the right to choose which ICANN-accredited dispute resolution service provider (RSP) will handle the case. During the preparation of the UDRP,some feared that complainant selection would lead to "forum shopping" that might bias the results. This article performs a statistical assessment of the forum-shopping thesis and finds support for it. There are statistically significant differences in the various RSPs' propensity to take away names from defendants; there are also major differences in the number of cases brought to each RSP. RSPs who take away names have the larger share of cases. The study examines other variables that might explain differences in market share, such as price, the plaintiff's nationality, or the time taken to decide a case. It finds that nationality and time also are correlated with market share. The study concludes that shopping for a favorable outcome is an important factor in the UDRP.  相似文献   

19.
Prof. Raymond C.K. Chen, a neuropsychologist with the CAS Institute of Psychology, has made novel progress in his studies of schizophrenia. His work has been reported by a recent issue of Behavioural Neurology.  相似文献   

20.
Prof. SUN Changpu from the CAS Institute of Theoretical Physics and coworkers from University of Basel in Switzerland have worked out a way --at least in theory --to split a beam of molecules according to their chirality. The technique involves passing the molecules through three different laser beams and is similar to the famous Stern-Gerlach effect, whereby a beam of atoms passing through a magnetic field is split in two according to the atoms' spin states (Phys. Rev. Lett. 99 130403).  相似文献   

设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号