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

IF A > B THEN C = A – B ELSE C = A + B ENDIF Read D IF C = D Then Print "Error" ENDIF A. 1 test for statement coverage, 3 for branch coverage B. 2 tests for statement coverage, 2 for branch coverage C. 2 tests for statement coverage. 3 for branch coverage D. 3 tests for statement coverage, 3 for branch coverage E. 3 tests for statement coverage, 2 for branch coverage

1 Answers   ISTQB,


What is the differance between Bug and Defect.

17 Answers   Cap Gemini, CarrizalSoft Technologies,


Explain the system testing?

0 Answers  


plz explain vss?

7 Answers   MBT,


I have s/m which gives me square of numbers from 1 – 10000. How do u test it.

0 Answers   ACS,






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

8 Answers  


How many test cases can u write 1) File - open dialog box in notepad pleasse write

5 Answers  


There is a game in that there are 20 levels an ordinary person can play it up to 12th level.So if you are a tester and if you have to test that game up to 20th level then how u can test that game.

0 Answers  


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

6 Answers   TCS,


Who will take care of test plan and test case?

1 Answers  


write test case for button of google page?"i am feeling lucky" if button is not appear on page?

0 Answers   Google,


write the testcases for migrating data from one database to another database?

0 Answers   Wipro,


Categories