摘要
本文在C语言中对数据区域元素实现了相对应用与相对引用。对Excel中的绝对引用与相对引用进行了定量分析，得到结论：含相对引用的公式复制后，公式位置变化，则相对引用的单元格的位置也会发生变化，可实现运算不变而操作数可变，使公式一次建立可多次使用。工作表左匕角，不会因公式复制而位置变化，因此公式中的单元格绝对引用不会因公式复制位置变化而变化，可存放公式共享数据。
This article realizes the relative reference and the absolute reference in the C language to the data area element Carrying on the quantitative analysis of the absolute reference and the relative quotation in the Excel, the article draws the conclusion： after the formula including relative quotation is duplicated, formula position as well as the standards position of the relative quotation＇s unit will vary, then the operation will be invariable, but the operand will be variable,thus getting a formula to be used many times once established. The top left-hand comer of work sheet doesn＇t change its position with the formula duplication, therefore the unit absolute reference in the formula doesn＇t vary with the formula duplication and may store the formula＇s shared data.
出处
《教学与科技》
2010年第3期29-32,共4页
Teaching and Science Technology
关键词
数据区域
相对引用
绝对引用
data area
relative reference
absolute reference
