Caribbean Secondary Education Certificate - Information Technology/Introduction to Spreadsheet

DEFINITIONS

 * Absolute Reference: A cell reference that does not adjust when the formula is pasted to a new location.
 * Active Cell: The worksheet cell with a dark border; text or numbers you type appear in this cell and in the formula bar.
 * Alignment: The placement of cell data in a cell.
 * Auto Fill: A feature that enables you to fill in a series of numbers, dates, or other items automatically in a specified range.
 * Auto Sum: A feature that you can use to insert a formula that sums a range of cells automatically.
 * Bar Chart: Compares individual items. Categories are organized vertically, values horizontally to place more emphasis on comparing values than on time.
 * Cell: The intersection of a row and column.
 * Cell Reference: Identifies a particular cell.
 * Chart: Graphic representation of worksheet data.
 * Chart Title: Identifies the purpose of the chart.
 * Chart Wizard: A series of dialog boxes that lets you create a chart and customize it as you create it.
 * Column Chart: Shows changes in data over a period of time or illustrates comparisons among items.
 * Data Label: Identifies specific points or series.
 * Data Series: A group of related data points plotted in a chart that originates from rows or columns on a single worksheet.
 * Fill Handle: The small black square on the bottom right corner of a selected cell.
 * Formula: A sequence of values, cell references and operators used to produce a new value from existing cells.
 * Formula Bar: Displays the contents of the current or active cell, located above the worksheet column headings.
 * Function: A predefined function in Excel.
 * Gridlines: Optional lines on a chart.
 * Insert Function: A button loacted on the formula bar that allows quick access to the Insert Function dialog box.
 * Legend: Key to the data represented by a chart.
 * Line Chart: Shows trends in data at equal intervals.
 * Merge and Center: To combine adjacent, or contiguous, cells into one large cell and center the data.
 * Operators: Addition (+), Subtraction (-), Multiplication (*), and Division (/), also the colon that separates cells in a range.
 * Order of Precedence: The order in which excel processes operations in a formula with more than one operation.
 * Pie Chart: Shows the relationship of items that make up data series to the sum of the items.
 * Range: A colon inserted between two cell references.
 * Sheet Tab: A means to access the different sheets in a workbook, located at the bottom of the spreadsheet.
 * Spreadsheet: A table of values arranged in rows and columns.
 * Task Pane: Provides a quick means to execute commands. Displays when you start Excel and and enables you to create new workbooks or open and existing one.
 * Templates: ready-made pages format, complete with margins, fonts, headers and footers, numbering, logos or any other kind of formatting the designer wants to appear on each page.
 * Toolbars: A series of buttons and menus in an application, which allows the user to perform functions quickly using the mouse.
 * Workbook: An Excel file that contains one or more worksheets.
 * Worksheet: A work area comprised of rows and columns, also known as a spreadsheet.
 * Value: The number resulting from the execution of a formula.

Reference
Introduction to Spreadsheet