Spreadsheet Vocabulary | 电子数据表词汇
Axis 轴 | A fixed line of reference for measuring coordinates or values in math. | 在数学中用来测量同等的物或值的固定直线。 |
Cell 单元格 | An individual block of information in a “Table”. | 一个表格中的信息模块。 |
Column 分栏 | A vertical set of “Cells” in a “Table”. | 一个表格中的竖直单元格。 |
Equation 方程式 | A mathematical statement containing more than one value. | 指包括不止一个值的方程式。 |
Formula 公式 | An operation that solves a mathematical problem. On the computer “formulas” automatically calculate a value to an “equation”. If a referenced “cell” is changed, the final value being calculated will automatically update. Addition =SUM( # + # )Subtraction =SUM( # – # ) Addition (List of Numbers) =SUM( # : # )Multiplication =( # * # )Division =( # / # )Average =AVERAGE( # : # ) | 用来计算数学问题的方法。电脑里的“公式”自动计算一个“方程式”的值。如果一个“单元格”参数改变,那么计算的最终结果也会自动改变。 加法 =SUM( # + # )减法 =SUM( # – # )加法(数列) =SUM( # : # )乘 法 =( # * # )除法 =( # / # )平均数 =AVERAGE( # : # ) |
Graph 图表 | A diagram that shows a visual comparison of data,along 2 or more Axis. | 一种表示数据比较的表格,二维的或三维的或者是更为复杂的。 |
Numbers | The program used on Apple (MAC) for creating “spreadsheets”. | 在苹果电脑(MAC系统)里用来创建“电子数据表”格的程序。 |
Mathematical Order of Operations 数学运算法则 | The order in which mathematical functions must be solved in an “equation”. | 在解“方程式”时需要用到的数学运算顺序。 |
Microsoft Excel | The program used on Windows for creating “spreadsheets”. | 在Windows系统里用来创建“电子数据表”格的程序。 |
Row 行 | A horizontal set of “cells” in a “table”. | 表格中的水平的单元格。 |
Tab 标签 | Located in the bottom left corner of Excel. Tabs allow you to have Multiple “sheets” in a single document, allowing for the creation of complex reports. | “标签”位于Excel左下角,可以利用标签在一个文档中创建几个“工作表”,对于制作复杂的报告单时很有用。 |
Table 表格 | A Table is a method for organizing information in a document. It is made of many “cells” in horizontal “rows”, and vertical “columns”. | 表格是文档中组织信息的方式,是由多个小的垂直和水平栏的单元格组成。 |
Scientific Notation 科学计数法 | A way of writing numbers that are to big or small to be written conveniently. | 一种用来记录特别大或特别小的数字的数学方法。 |
Sheet 工作表 | A method of organizing data . “Sheets” are similar to a table. A simple sheet will contain a single “table”: However a “sheet” can also contain many “tables”. | 一种处理数据的方式。“工作表”类似于表格。简单的工作表只包括一个表格。当然一个“工作表”可以有很多表格。 |
Spreadshee 电子数据表 | A a document used to organize data. This term can be used to refer to a digital file or a printed version of the document. | 用来处理数据的方式。电子数据表格可以指一个数字文档或一个文档的打印形式。 |
X Axis X 轴 | Indicates width (Left to Right) | 指宽度(从左到右) |
Y Axis Y 轴 | Indicates Hight (Top to Bottom) | 指高的(从上到下) |
Z Axis Z 轴 | Indicates Depth (Front to Back) 3D only | 指深度(从签到后)仅限3D |