can any one give the format of writing test cases in excel
sheet.




Answers were Sorted based on User's Feedback



Answer / murthy

Test Case ID
Requirement Id
Test Name
Prerequisites
Description (Steps to execute)
Expecte Result
Actual Result
Status
Remarks

Is This Answer Correct ?    84 Yes 10 No

Answer / pradula

Hi
Different companies follow different testcase template.But
basically the tems we use is
1.Test case ID
2.Description
3.Test Data
4.Expected result
5.Actual result
this is quite enough but in some companies they add
6.pass/fail
7.severity

Is This Answer Correct ?    47 Yes 5 No

Answer / hi

hi murthy here y we can use requirement id already we are
using Test case id?
ones again y we are using requirement id?
plz explain for me

Is This Answer Correct ?    24 Yes 10 No




Answer / sham

Dear Freind, According to company, test case formats are
different. All our friends answers are correct. but
according to INTERNATIONAL SOFTWARE TESTING QUALITY BOARD
(ISTQB), it is software quality control board, they
specified a format for the test cases
1)Test Case ID
2)Test Description
3)Review History
4)Function to be Tested
5)Environment
6)Test Setup
7)Test Execution
8)Expected Result
9)Actual Result
10)Overall Result
11)Incase of Fail - Priority - High,Medium,Low
- Siviority- High,Medium,Low

with the banner like Project Title, Module, Developer,
Tested By, Reviewed By, Date, OS, Version etc..,

Is This Answer Correct ?    14 Yes 3 No

Answer / sujili.c

1.S.No
2.Test plan ID
3.Test case ID
4.Test case description
5.Input data
6.Expected result
7.Actual result
8.status
9.comments

Is This Answer Correct ?    20 Yes 10 No

Answer / we4

test case id
test case description
test case procedure
expected results
actual results
input
status

Is This Answer Correct ?    12 Yes 2 No

Answer / chandrasekharreddypadala

1. Test ID
2. Title
3. Pre/post Conditions
4. Steps
5. Expected Results
6. Priority Level
7. Pass/Fail
8. Defect Number

Is This Answer Correct ?    13 Yes 10 No

Answer / vanitha

1.)Testcase Id
2.)Testcase Description
3.)Input Data
4.)Expected Result
5.)Actual Result
6.)Results
7.)Comments
The above are the basic columns you find in any testcase
template.Depending on the organization this may vary

Is This Answer Correct ?    3 Yes 1 No

Answer / satishkumar

1)test case title
2)test case id
3)purpose
4)scenario
5)pre-requisite
6)input data
7)steps
8)expected result
9)post condition
10)actual result
11)verdict pass/fail
12) remarks

Is This Answer Correct ?    3 Yes 1 No

Answer / anshul gupta

1)S.No
2)Test i.d
3)Test case
4)Execution status
5)expected result
6)severiorty
7)priority
8)developer comments
9)Q.a comments
10)Status
11)remark
12)suggestion
13)issue found date
14)issue fix date
15)issue status


This is the excel format, which i am using...please help me , if there is any modular approach with excel.....

Is This Answer Correct ?    2 Yes 0 No

Post New Answer



More Test Cases Interview Questions

What is usability testing? What are the usability test cases for 'Save As' option in Notepad?

4 Answers   Infosys,


what are those parameters or matrixes for tesing a software user interface?

2 Answers  


Who will decide what the test cases you have written are correct?

4 Answers   Mind Q Systems, Satyam,


can someone tell me the test cases for following scenario of password: 1. Password should be minimum 6 chars and maximum 8 chars. 2. Password should consists of 1 uppercase letter. 3. Password should consists of 1 numeric. 4. Password should consists of 1 special character.

2 Answers  


Write all Possible (+ve and -ve) Test Cases for a Date Object (DD/MM/YYYY) which is entered manually?

7 Answers  






Can anybody post the format of a Requirement Traceability Matrix. And how to include this RTM in the reqirement document.?

1 Answers  


What is the difference between Test Input and Test Data??

2 Answers  


How about do we go as far as writing test cases is considered?

1 Answers  


Please can anybody tell me some good ideas to write test case for fan and test case for chair?

6 Answers   TCS,


can any body help me with providing a a case for usability testing...

0 Answers  


Give examples of boundary value and equivalence partitioning test cases.

10 Answers   IBM, Mind Tree,


As we are using QTP 9.1 version, is there is any method to connect the remote desk top?

1 Answers  






Categories