指定要显示在图表中的单元格引用。
Specify the cell references that you want to appear in the chart.
当公式中包含单元格地址时,叫做单元格引用。
When a formula contains a cell address, it is called a cell reference.
单击文档中含有要计算其反余弦的值的单元格。您也可以将单元格引用键入下框中。
Click the cell in your document that contains the value for which you want to find the arcosine. You can also type the cell reference into the box below.
那么引用单元格,与直接输入计算的值有什么区别呢?如何单元格引用,单元格中的值在修改时,公式本身不需要修改,这样可以大大节省编辑的时间。
Creating a formula with cell references is useful because you can update data in your worksheet without having to rewrite the values in the formula.
从表的单元格到表单字段再到链接,您都能通过其特征和css属性惟一地引用和修改。
Anything from table cells to form fields to links, you can uniquely reference and modify client side through both their attributes and CSS properties.
因此,事实上,如果可以只引用包含固定值的单元格,可以更省事。
So, in fact, it saves effort if you can refer to only cells that contain fixed values.
基于卡片的表单中的字段可以像表格中的单元格一样引用,可以包含数据,也可以包含能在运行时确定数据的表达式。
The fields in the card-based forms can be referenced like cells in a spreadsheet and can contain either data or an expression that determines the data at run-time.
引用必须是活动工作表的单个单元格。
相对引用使用的场合比较多,但有时候也会用到绝对引用,这时候复制或者填充单元格时,单元格中的行与列的位置不会发生改变。
There may be times when you do not want a cell reference to change when copying or filling cells. You can use an absolute referenceto keep a row and/or column constant in the formula.
按每个单元格在表中的位置引用单元格。
我们也可以把A列中的名字做为另一单元格数据有效性序列的源区域,然后在VLOOKUP函数中引用这个单元格。
You also can use the names in column a as the Source range for a list in another cell by selecting Data Validation list. Then reference the cell housing this list in your VLOOKUP function.
此单元格内的公式引用了空单元格。
The formula in this cell refers to cells that are currently empty.
绝对引用设计时,要在公式中单元格的列号或者行号前面添加$符号,可以添加一个,也可以添加两个。
An absolute reference is designated in the formula by the addition of a dollar sign ($) . It can precede the column reference, the row reference, or both.
此示例引用位于表的第一行第一列的单元格;
This example refers to the cell located in the first row and the first column of the table;
此示例引用位于表的第一行第一列的单元格;
This example refers to the cell located in the first row and the first column of the table;
应用推荐