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 / ravishankar

steps to write test case template as follows.
it has 3 parts..

header, body, footer

header contains:
1.testcase number,
2.requirement number,
3.module name,
4.sevoirity,
5.precondition,
6.test data,
7.test case type,
8.brief description.

body contains:

1.step number,
2.action,
3.input,
4,expected result,
5.actual result,
6.status,
7.comments/remarks.

footer contains:

1.author,
2.reviewed by,
3.approved by,
4,last modified.

Is This Answer Correct ?    10 Yes 6 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

Post New Answer

More Test Cases Interview Questions

What is quick test professional and what test environment it supports?

0 Answers  


They were asking sily questions and definitions rather than practical experience related questions. More focused on Definitions.

0 Answers  


Which testing is important, positive testing or negative testing. Test cases for postive and negative testing for a given functionality.

2 Answers  


(questions asked in interview)hi every one can any one please answer to this questions.these questions were asked in an interview.i have another interview next week . 1.when the time schedule is tight how will you approch the testing,and the relese is nearing and we need to finish testing how can we follow in that case.do we need to exicute all the test cases or can priortise and leave some to next relase. 2. when a new feature is added to the existing application we need to add new test cases but after that do we need to change all the existing test cases and while running do we need to exicute entire application test cases or only the new feature test cases and related new feature test cases. 3.do you have any situation where you have to write and exicute the test cases same time, how will you follow.does it happens in real time. 4.example of bug which is not reproducible.like tester say that there is bug and developer say no can some example of such bugs. 5.during regression testing some times do we need to add new some additional test cases to test that bug.

3 Answers  


Q.1)how write negative & positive test cases Q.2 )write negative & positive test cases for i-pod

1 Answers  






What is mean by Equal Partitioning

4 Answers   Infosys,


Explain the scalability testing?

0 Answers  


how to test stand alone programs?

0 Answers   Accenture, Google,


Can any body explain How to Install the QC9.0 on XP OS

0 Answers  


What are the test cases, we can write for Data Grid. Anybody can help me..Thanks in advance.

5 Answers   Siemens,


In manual testing, I have query regarding data conversion testing. I am working on xml document. How do we write test cases for below input as well as for output Input: <text>1. software Testing</text> Output: <paragraph><text><desig>1.</desig>software testing</text></paragraph>

0 Answers  


is it necessary to write test cases in tabular form or will point wise will do.

3 Answers   Google, Zycus Infotech,


Categories