SpreedSheet

• Spreadsheet Application


  A software application used to perform mathematical equations without manual computation. It shows only the results to the given operations and data.
• Microsoft Excel


  A spreadsheet application used to perform mathematical equations without manual computation. It shows only the results to the given operations and data.
• Microsoft Excel


  • Essential to daily life, specifically the four basic arithmetic operations
  • Used for on-the-spot computation
  • Replaces manual computation
• Workbook


  The term for an Excel document
• Spreadsheet


  A portion (a page) of the workbook
• Parts of an Excel Document

  • Quick access toolbar
  • Ribbon
  • Name box
  • Formula bar
  • Column letter
  • Row number
  • Sheet tabs
  • Status bar
• Tabs found in the ribbon of Excel documents

  • File tab
  • Home tab
  • Insert tab
  • Draw tab
  • Page layout
  • Formulas tab
  • Data tab
  • Review tab
  • View tab
• Other spreadsheet options

  • Add spreadsheet
  • Rearrange spreadsheet
  • Rename, color, move, delete spreadsheet
  • Protect spreadsheet
• What can we do with cells in Excel

  • Select an entire row or column
  • Select a group of cells
  • Insert or delete a row or column
  • Adjust the size of rows and columns
• Basic Formatting


  • Font face, size, alignment, and colors
  • Number formats
• Types of Operators

  • Arithmetic
  • Comparison
  • Text concatenation
  • Reference
• Formulas


  Work like normal arithmetic operations but the equal sign (=) must be entered first before other values
• Factors to consider before creating formula

  • Locate the cell reference of each piece of data or use the point-click method
  • Use fill handle to copy formulas
• Creating a basic formula

  1. Select the cell where formula will be entered

  2. Type the equal sign and select the cell that has the value/s to be computed using the point-click method

  3. Add the operator needed in the formula (arithmetic, comparison, concatenation, or reference)

  4. Select another cell with a desired value (use point-click method) and hit enter
• Spreadsheet Functions

  • Predefined operations using different formulas
  • Named after their function
• Parts of a Function

  • Equal sign
  • Function name
  • Argument