page 14

Subdecks (1)

Cards (157)

  • MS Excel or Microsoft Excel
    Ø  Spreadsheet software
    Ø  Tracks data, creates charts, performs calculations
    Ø  Stores information in columns, rows
    Ø  Up to 256 columns, 65,536 rows per worksheet
  • MS Excel  Projects:
    -          Budgeting displays
    -          Checkbook registers
    -          Enrollment records
    -          Inventories
    -          Coded surveys
    -          Field and laboratory research data
    -          Financial and accounting
  • Major uses of Excel
    Ø  Widely used in financially-related activities
    Ø  Creates new spreadsheets for custom formulas, quarterly forecasts, annual reports
    Ø  Organizes and tracks information like sales leads, project status reports, contact lists, invoicing
    Ø  Useful for scientific, statistical analysis with large data sets
    Ø  Performs variance analysis, chi-square testing, charts complex data
  • How Excel Works
    Ø  Excel document called Workbook
    Ø  Workbook has at least one Worksheet
    Ø  Worksheet is grid for storing, calculating data
    Ø  Many worksheets in a workbook, each with unique name
    Ø  Worksheets laid out in columns (vertical), rows (horizontal)
    Ø  Intersection of row, column is a cell for entering information, date, number, formula
    Ø  Each cell formatted individually with border, background color, font color/size/type
  • Cell: Individual data box with corresponding Column, Row heading
  • Cell Reference: Name of cell, column heading before row heading (e.g., A1 for first cell)
  • Reference - A1 (Column A, Row 1)
  • Formula and Function Management
    Ø  Formulas enable calculations in a worksheet.
    Ø  Excel recalculates values automatically based on changes in cell data.
    Ø  To enter a formula, start with = sign followed by the calculation.
    Ø  For example, =A1+B1 adds the values in cells A1 and B1.
    Ø  Functions are predefined formulas performing specific operations.
    Ø  Functions accept arguments and return results.
    Ø  Results can be calculations, text, references, logical values, or arrays.
    o   Examples include determining loan payments or calculating investment returns.