|
|||||
|
|
| Excel数据有效性的应用 | |
| 引用本文： | 周贤善,朱光耀. Excel数据有效性的应用[J]. 长江大学学报, 2010, 0(2): 298-300 |
| 作者姓名： | 周贤善 朱光耀 |
| 作者单位： | [1]长江大学计算机科学学院,湖北荆州434023 [2]长江大学文理学院,湖北荆州434020 |
| 摘 要： | Excel数据录入是一项既枯燥又烦琐,且容易出错的工作。从实例出发,探讨Excel数据有效性在实现下拉列表选择录入中的应用,利用预定的条件校验数据,防止无效数据的产生。从而使得Execl数据录入变得轻松、准确。 |
| 关 键 词： | 数据有效性 Excel 选择录入 校验数据 |
Application of Excel Data Validity |
|
| ZHOU Xian-shan,ZHU Guang-yao. Application of Excel Data Validity[J]. Journal of Yangtze University, 2010, 0(2): 298-300 | |
| Authors: | ZHOU Xian-shan ZHU Guang-yao |
| Affiliation: | ZHOU Xian-shan,ZHU Guang-yao (Yangtze University,Jingzhou 434023) |
| Abstract: | The Excel data entry is a very dull,tedious and error-prone task.Based on some examples,the article explores the application of Excel data validity in the achievement of the selective entry in the drop-down list.It is suggested that the data are verified by means of the pre-set condition to prevent the appearance of invalid data.Thus the Excel data are easy entry and accurate. |
| Keywords: | data validity Excel selective entry data verification |
| 本文献已被 CNKI 维普 等数据库收录！ | |