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

For how many days (or) weeks you will test a product or software?

0 Answers  


How would you test a cup and or pencil?

2 Answers  


Can someone please explain me the life cycle of DAtabase testing,iam pretty good at SQL but i dont know anything about how to start the testing(backend especially),how and where to write test cases for backend testing?how to take snapshots?how to report the bugs....as simple i know SQL and i know working on quality center but how to work on both together?Please help me!!!

1 Answers  


test cases for bus transport (TNSTC)

0 Answers  


14. How many test cases are necessary to cover all the possible sequences of statements (paths) for the following program fragment? Assume that the two conditions are independent of each other : - ………… if (Condition 1) then statement 1 else statement 2 fi if (Condition 2) www.istqb.guru then statement 3 a. 2 Test Cases b. 3 Test Cases c. 4 Test Cases d. Not achievable Please explain this how to solve?

1 Answers   ISTQB,






We r developing one Web Site for construction company. In that Web site we have different option like About Us,Contact Us,Home,Sites,Site Map,Search Etc........ and front page of that web application contains 6 different pictures means single page contain 6 pics etc... write Test plan ,Test Scenarios,Test Case ....Plz answer this question ASAP

2 Answers  


build 1 bug is raised and it was closed by developer and build 2 is released in build 2 also same bug raised what is the satus of that bug. 1>reopen 2>open 3>new 4>defered

14 Answers   Accenture,


Smoke Test Checklist for Gmail please someone help!

2 Answers   Microsoft,


How to write test case for this scenario. The data entry field for city shall be removed from the screen

1 Answers   SpinSci,


If I have to write the test cases for any report & there is date box.then may I have to write only select date or have to write all steps required for selecting date

0 Answers  


how to write test cases for online restaurant table booking system?

0 Answers  


wht are the test cases, we have to write for check box, Anybody can help me. Thanks in advance.

5 Answers   AppLabs, Siemens,






Categories