计算机应用第四章（Computer applications fourth chapters）.doc

计算机应用第四章（Computer applications fourth chapters） Fourth chapters Two. NOUN explanation: 1.: the cell is the smallest unit of work table, each cell to locate by line and column. P170 2. Workbook: is a most commonly used Excel2000 document, which is stored as a file in the disk, the file extension is .Xls P169 3. worksheet: usually called spreadsheet, which is used to store and process data in the form page. P170 4.: the cell reference in the formula in calculation is the cell address the storage of data, rather than the data itself, this formula calculation results always use the current data in the cell, such as if the change of the original data, the calculation results can also be changed by sharp. 5. relative reference: refers to a cell reference that changes with the location of the cell where the formula is located. P182 6., classification summary: the use of class data for the sum of the mean, count, the maximum, minimum and other operations. P191 The 7. formula consists of operators, constants, cell references, and functions. P179 8. absolute reference: adding the $sign to the line number and the column number represents the absolute reference. P182 9. edit bar: used to display the contents of a cell, enter and edit the contents of a cell. On the left is the name box, which is used to display the name of the cell or region. 10. sheet label: refers to the name of the worksheet, located at the bottom of the workbook document window, with an initial value of Sheet1, SHEET2, sheet3. P170 11. status bar: important information that reflects the current operation at the bottom of the window. 12. data removal: refers to the data in the cell deleted, the cell is still in place. P176 13. paste selectively: a cell or region contains many properties, such as numeric values, formats, annotations, formulas, borders, etc., and data replication often involves only copying some of its features. These can be achieved by selective paste. P178 15. automatic summation: summing ope