emptech 4

• A spreadsheet is a tool used in accounting for presenting book keeping ledgers.
• A electronic spreadsheet is an application program that simulates the function of a paper worksheet
• the vertical part of the worksheet, are typically identified by numbers.

  Columns
• the horizontal part of the worksheet, are typically identified by numbers

  Rows
• is the basic unit of a worksheet

  Cell
• is a group of cells in a worksheet.

  Range
• is the combination of the heading names of the intersecting column and row the form the cell.

  Cell adress
• Microsoft Excel or Excel is one of the most popular electronic spreadsheet software in the market, developed by Microsoft.
• a function used to compute for the average of the number of a range.

  Average
• a function used to compute for the summation of the number of the range.

  Sum
• a function used to count the cells with content in a range.

  Count
• a function used to count the cells with a specified content within a range.

  COUNTIF
• a function used to compute for the average of a range if a certain condition is met.

  AVERAGEIF