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




Answers were Sorted based on User's Feedback



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

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

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

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

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

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




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

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

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

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

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

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

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

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

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

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

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

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

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

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

write test case for optical mouse.

8 Answers   Mphasis,


Need help to write test case for "Check Availability" field. Any help would be highly appreciated!

1 Answers   TCS,


Can any body please tell me how to test Anti-virus software? I have been asked this question many times in interview.They asked this question for a security tester,performance tester & functional tester perception. Hope u guys will reply me. Any suggestions welcome.........

2 Answers  


how to write test cases for "Browse" button.

6 Answers   Accenture,


What are the test scenario's for pen like high priority high seviority?

4 Answers   NetWeb,






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

4 Answers   Infosys,


give an example of how to write functional test case.in this test case can we write all +ve and -ve conditions?

7 Answers  


could u please tell the testcases to test gmail

13 Answers   Jamcracker, Snap On,


why we need a test plan

11 Answers  


What is STATEMENT COVERAGE testing

1 Answers  


How to write test case for this scenario. If the Zip Code field is populated, the system shall compare  the zip code value entered to the zip code value in  the Family Individual Information Tab

0 Answers  


how to prepare unit test scripts for accrued interest calculation.

1 Answers  






Categories