Caribbean Secondary Education Certificate - Information Technology/Introduction to Spreadsheet

From WikiEducator
Jump to: navigation, search

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.

SPREADSHEET LESSONS

LESSON ONE

LESSON TWO

LESSON THREE

LESSON FOUR

LESSON FIVE

LESSON SIX

LESSON SEVEN

Reference

Introduction to Spreadsheet