Lesson 10: Data and Numbers on SpreadSheets

• Microsoft Excel - is a widely used spreadsheet program.
• spreadsheet program - is a software for entering, editing, manipulating, and printing information in a tabulated form.

  It is a program mainly used for handling numbers. A CLASS workbook follows as our example of a Microsoft Excel application.
• Classwork book - example of a microsoft excel application
• workbook - which is what an excel file is called. is composed of worksheets
• Cells - are identified by their cell addresses, composed of the letter of the column together with the number of the row
• Column - the vertical divisions
• row - the horizontal divisions
• Components of SpreadSheet

  1. Formula Bar
  2. Tab splitbox
  3. Sheet tabs
  4. Tab Scrolling Buttons
  5. Column Headings
  6. Row Headings
  7. Active Cell
  8. Select all Button
  9. Namebox
• Formula Bar - Shows the contents of the active cell and can be used to edit it.
• Tab Split Box - You can drag this to the left or right in order to adjust the area allocated for displaying the sheet tabs. To reset the tab display, simply double-click the tab split box.
• Sheet Tabs - Contain the names of the available worksheets in the current workbook. These tabs enable you to switch to a specific sheet in the workbook. Right-click any sheet tab to show a shortcut menu to insert, delete, rename, move, or copy worksheets.
• Tab Scrolling buttons - Used to scroll through the sheet tabs in your workbook, allowing you to view other worksheets in the workbook.
• Column headings - Horizontal bars on top of the worksheet. They are labeled with letters from A to XFD.
• Row headings - Vertical bars at the left side of the worksheet. They are labeled with numbers from 1 to 1,048,576.
• Active cell - The cell that is currently selected.
• Select all button - Used for selecting the entire worksheet.
• Name box - Contains the cell address of the active cell. You can click the arrow to the right of the name box to show a drop-down list that displays any name you have defined for the current workbook.
• Two kinds of data you can enter into the cells:

  1. labels
  2. values
• labels - are alpha numeric characters that you do not perform mathematical calculations with
• values - are the numbers that you use for calculation
• Statistics - numerical value or data of a particular interest; the discipline of collecting
• Worksheet - a grid of labeled columns & rows
• Data Region - a block of cells containing data and bounded by empty cells