The article about How to write test cases in excel sheet. This article complete written based on practical industry experiences. It will help you to crack your interviews.
How to write test cases in excel sheet example
Before sharing practical experiences. You can read some basic definition and standard parameters of the Test Cases.
What is Test case?
A test case is a document, which contain set of test data, prerequisite, Action, expected results and post conditions, developed for a particular test case scenario to verify compliance against a specific functionality requirement.
Test Case act as the starting point for the test execution, and after providing set of input values or test data, the application has a final outcome and leave the system at some end point or also known as execution post condition.
Following standard Test Case Parameters as:
Test Case ID
Test Case Description
Valid and invalid Test Data
Status – Pass or Fail
Let’s I am going to share with you practical industry experiences. It will help you additionally.
In the organization regularly or practically we are using test case execution tools like Quality Centre, Microsoft Test Manager (MTM) to write a test cases. Each tool has define their own test case template structure.
Like I work with Microsoft Test Manager (MTM) and writing the test cases in following way.
Test Case parameters are:
|Scenario Description : User successfully login to application by using valid credentials|
|1||Login Screen: Log in to ABC application using valid user. User ID: admin and Password: admin||Home screen is displayed|
|2||Home Screen: Verify the following sections are displayed Home Content search Document Search Calendar User Profile Help||Following sections are displayed as: Home Content search Document Search Calendar User Profile Help|
|3||Home Screen: Click on “User Profile” tab section and Verify the “User Profile” page is displayed||User Profile screen is displayed|
|4||User Profile Screen: Verify the default User details are displayed including User ID and Passwords||User details are displayed including User ID and Passwords|
|5||User Profile Screen: Enter the User registration date and click on “Save” button||User Profile Screen successfully updated with specified registration date.|
Always maintain the valid and invalid test data with you. Because, while preparing test execution report you should provide set of all executed test data.
Above information were primary article about “How to write test cases in excel sheet example”. Soon I will publish more in my next article.