How to write test cases in excel sheet example

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 Scenario

Test Case Description

Test Steps

Prerequisite

Valid and invalid Test Data

Actual Result

Expected Result

Test Parameters

Environment Information

Comments

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

Action


Test Data

Expected Result

Scenario Description : User successfully login to application by using valid credentials
No Action Expected Result
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.

Share This Post

2 Comments - Write a Comment

  1. The testing performed in order to learn each function of the application and explore it is known as exploratory testing. It is applied when requirement document is not available or insufficient details are provided.
    ex: To explore new features of a mobile phone without reading instruction manual.

    Reply

Post Comment