Caribbean Secondary Education Certificate - Information Technology/Introduction to Spreadsheet
From WikiEducator
Contents
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.