| Excel条件格式在教务管理中的运用 |
| |
| 引用本文： | 陈喜华. Excel条件格式在教务管理中的运用[J]. 北京教育学院学报(自然科学版), 2015, 0(1): 17-22. DOI: 10.16398/j.cnki.jbjie(n)issn1673_6923.2015.01.004 |
| |
| 作者姓名： | 陈喜华 |
| |
| 作者单位： | 广州工商学院,广东 广州,510850 |
| |
| 摘 要： | Excel条件格式可以根据单元格内容有选择性地自动应用格式,能给教师的教务管理工作带来许多便利。尤其结合公式灵活应用条件格式,可以快速地标识包含文本的单元格,标识两个列表中不相同的数据,标识前几名的数据,标识满足特殊条件的日期,让工作表间隔固定行显示阴影,判断输入数据的正确性,显示选中单元格所在行、列,快速查找和定位数据,自动绘制进度图表。
|
| 关 键 词： | Excel 条件格式 公式 |
The Application of Excel Conditional Format in Teaching |
| |
| Ghen Xihua. The Application of Excel Conditional Format in Teaching[J]. Journal of Beijing Institute of Education(Natural Science Edition), 2015, 0(1): 17-22. DOI: 10.16398/j.cnki.jbjie(n)issn1673_6923.2015.01.004 |
| |
| Authors: | Ghen Xihua |
| |
| Abstract: | Excel conditional format can selectively and automatically apply format according to the content of the cell, which can bring much more convenience for teaching. Gombining with the formula, excel conditional format can apply flexibly and identify cells that contain text, as well as the different data in two lists. It can also identify dates that meet the special conditions, shadow display the fixed line interval of the work table, judge the correctness of the input data, display the specific row and column of the selected cells, search and locate data quickly, and at last, draw a progress chart automatically. |
| |
| Keywords: | Excel conditional format formula |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
