Absolute cell reference - is when a formula is copied to other cells; part of the cell reference does not change as the formula is modified. E.g. $A$4, Application software - programs designed for an end user to do a particular task, such as word-processing and spreadsheet programs., Cell - where a single piece of data is entered into a spreadsheet. The data is referred to as a piece of text, number or formula. Each cell is referenced by a letter and a number such as C4., Cell reference - the set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3., CSV - stands for comma separated value. Data can be imported into a spreadsheet using a CSV file., Data validation - an Excel (spreadsheet) feature that you can use to define restrictions on what data can or should be entered in a cell, and to display messages that prompt users for correct entries and notify users about incorrect entries., Formula - a sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=)., Function - a prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations. E.g. =SUM(A1:A100), Merged cell - a single cell that is created by combining two or more selected cells, Range - Two or more cells on a sheet. E.g. A1:B6, Relative reference cell - this changes a formula’s cell references to refer to the next cell(s) when the formula is copied down a column or across a row., Spreadsheet - is an application often used to process and display financial or statistical information. It is used for performing calculations and drawing charts. It is used by people in many different occupations such as engineers, scientists, teachers, designers and people who run their own business. A spreadsheet can consist of many different worksheets., Workbook - a spreadsheet program file that you create in Excel. A workbook contains worksheets of rows and columns in which you can enter and calculate data., Worksheet - the primary document that you use in Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.,

Spreadsheets - Key Terms

由
打印
嵌入

排行榜

视觉风格

选项

切换模板

恢复自动保存：？