Can any one tell me the format/columns for writing test
scenarios in excel sheet?

Answers were Sorted based on User's Feedback



Can any one tell me the format/columns for writing test scenarios in excel sheet?..

Answer / avinash chava

Hello friend,

Here are the columns you need to have while
writing test cases anywhere.

1) TestCaseID
For this we will give some unique number
2) TestCase
Here we will write the condition to be tested
3) Description
Here we will write the steps how to test that
particular condition
4) Expected Result
What is the expected result of this
particular operation
5) Actual Result
What is the actual result while executing on
the build.
6) Status
What is status of this particular testcase.
Either it is PASS/FAIL
7) Priority
Here we will write the priority of that
particular test case. We will write Either High/Medium/Low.

All the fields are same even though you use an
excel sheet or any other management tool like quality center.

Is This Answer Correct ?    11 Yes 5 No

Can any one tell me the format/columns for writing test scenarios in excel sheet?..

Answer / abdul sameer

Might gone wrong in reading the question properly The
question is related to Test Scenario columns( template) not
Test case template.

Scenario template changes from company to company but
normally these are the minimum things which it should have

1. Test Scenario Identifier
2. Requirement Traceability Matrix
3. Test Scenario Summary
4. Test Scenarios
5. References


1. Test Scenario Identifier is an unique identifier to
recognize the Scenario.

2. Requirement Traceability Matrix:- Provide a reference to
the location of the matrix that specifies the traceability
of requirements for that scenario. Mapping requirement to
that scenario.

3.Test Scenario Summary:- Provides a summary description to
that summary

4. Test Scenario:- In-detail how this scenario should be
giving complete understand wht is this scenario is of.

5. The reference document which talks abt the scenario.



Now keeping this as list, testers creates n no. of test
cases for each and every scenario and the test case template
would be as defined in the above answer.

Is This Answer Correct ?    8 Yes 3 No

Can any one tell me the format/columns for writing test scenarios in excel sheet?..

Answer / jocelyn - test manager

Venkatesh they are asking about test scenario format but not test case format. There is lot of difference between test case and test scenario . The one Avinash and venkatesh described are related to test case format but not test scenario.

Test cases comes from test scenario.It is like Test scenario is parent and childrens are test cases for those scenario. The second answer is related to test scenario which is right

Is This Answer Correct ?    4 Yes 1 No

Can any one tell me the format/columns for writing test scenarios in excel sheet?..

Answer / venkatesh

Hi Friends..
This is the possible test case design
Test case ID
Test Case Description
Test Pre-requisite
Test Input
Expected Result
Actual Result
Status
Priority
Seviority
Comments

Is This Answer Correct ?    0 Yes 7 No

Post New Answer

More Manual Testing Interview Questions

what is server-side testing? what is automation framework?

1 Answers   HCL,


diff b/w stress testing and load testing?

5 Answers   Accenture,


Please anybody explain the interaction of tester with developers and team lead regarding bugs or any issue, how they interact? How they discuss... Plz be clear in detail

6 Answers   eSymbiosis, Infosys,


How many testcases have you written till, now as an average per project?

1 Answers   AppLabs,


one deffectis found then we send it to the developers.and they released a new build.What we test in that build?The whole application or the only test cases where we got the deffect.

3 Answers  






Please can any one tell me 1).Types of reports 2).Types of Meetings.

0 Answers  


What is Cycle Testing? Not Testing Life Cycle?

2 Answers  


any one please send me any test case examples with tabular columns in manual testing

0 Answers   Satyam,


Explain about "Compatibility Testing" in Web based Application?

2 Answers   Crea,


is it necessary to write neagtive test cases for each and every field

1 Answers  


what is the difference between maintenence release and hot fix release?

2 Answers   i2,


what is advantages and disadvantages of the Waterfall Model and V-Model

5 Answers   CSC, SSI Small Scale Industries,


Categories