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

Hi, i attended interview in seimens they asked me suppose u have a car which is used by VIP and it has 2 alarms one is at front and other is back when ever smoke or fire is near to car it will detect it and beep alaram so wat r the possible test cases u can write plz give the answer

2 Answers   Siemens,


how to write test cases for a text field that should have maximum 250 characters

9 Answers  


Write a test case scenario for Web-based address book?

0 Answers  


How to write testcases for username creation?Given requirements are min 6characters,atleast one alphabet,alpha,alphanumric

2 Answers  


write a test case for a pen and paper regarding writing.

11 Answers   HCL, Wipro,






In any Hyderabd institute you can find these word commomly used by faculties ... Yes or no / Right or wrong so funny...

0 Answers  


write test cases for hospitality management system

0 Answers   Infosys,


Anyone can please inform me about how to write test cases for any mathematical calculations. Say for example, we have a formula in a given scenario for calculating the interest. The given formula for interest is: (principle * 5)/(12 * 100) In this case, the principle amount may vary. Would like to know how many test cases can be written for this scenario and how can we decide over this. I will be very thankful for the answer....

3 Answers  


what is not present in the test case? 1>requirment ID 2>test case ID 3>bug ID 4>objective

30 Answers   TCS,


write the test case flipart.com

2 Answers   Satyam,


Is there any formula to find the number of test cases needed

4 Answers   Satyam,


Positive and Negative test cases for the speedometer?(minimum 5 each)

0 Answers   Bosch,


Categories