Maintaining Test Cases in Excel

Applications may sometimes have test cases maintained in Excel Sheet.

Usually the columns are something like this:

  1. USE CASES
    1. S. No.
    2. Description
    3. Category (Functional Or Non-Functional)
    4. SubCategory (Security, Data, Exception, Performance etc.)
    5. Comments
  2. TEST CASES
    1. Test Case No.
    2. Use Case No.
    3. Initial State
    4. Test Case Description
    5. Expected Result
    6. Comments
  3. SCREENSHOTS and LOGS of the test results can be maintained (for every test case) in a doc file.
Advertisements