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

Answers were Sorted based on User's Feedback

Answer / murthy

Test Case ID
Requirement Id
Test Name
Description (Steps to execute)
Expecte Result
Actual Result

Is This Answer Correct ?    84 Yes 10 No

Answer / pradula

Different companies follow different testcase template.But
basically the tems we use is
1.Test case ID
3.Test Data
4.Expected result
5.Actual result
this is quite enough but in some companies they add

Is This Answer Correct ?    47 Yes 5 No

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

Answer / sham

Dear Freind, According to company, test case formats are
different. All our friends answers are correct. but
(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
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

Answer / sujili.c

2.Test plan ID
3.Test case ID
4.Test case description
5.Input data
6.Expected result
7.Actual result

Is This Answer Correct ?    20 Yes 10 No

Answer / we4

test case id
test case description
test case procedure
expected results
actual results

Is This Answer Correct ?    12 Yes 2 No

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

Answer / vanitha

1.)Testcase Id
2.)Testcase Description
3.)Input Data
4.)Expected Result
5.)Actual Result
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

Answer / satishkumar

1)test case title
2)test case id
6)input data
8)expected result
9)post condition
10)actual result
11)verdict pass/fail
12) remarks

Is This Answer Correct ?    3 Yes 1 No

Answer / anshul gupta

2)Test i.d
3)Test case
4)Execution status
5)expected result
8)developer comments
9)Q.a comments
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

i want to write the test cases for sorting the records in a table according to date wise.this is the functionality ,that is the latest record should come on the top can any one tell me the test cases for this thanks in advance:)

1 Answers   Cognizant,

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

1 Answers   TCS,

Please Tell me the Real Process of a Company. My company is very small & Developer explains me the feature and I prepare the test cases according to he explained .No one is there to review what I have written in the test cases.Test cases are ok but still I have the knowlege of real testing documents i.e which documents I have to prepare What is the flow starting from requirement gathering.Please tell me ,Thanks in advance .It will really helpful to me

1 Answers  

write a test case for telephone billing ?

0 Answers   CTS, TATA, Infosys,

write a test case for student admission form

2 Answers  

Can anybody tell test cases for the following condition? In a railway reservation form, 4 types of ticket ranges are there like a) age up to 3, NO TICKET. b) age up to 7, HALF TICKET. c) age up to 60, FULL TICKET. d) age from 61, SENIOR CITIZEN QUOTA. if you enter age into the text box the relevant message should be displayed..... Eg. FULL TICKET.

3 Answers  

if account balance less than 5000 for a month ,account should become in active. if bal greater than 5000 account should b active. Write test cases for the above scenario

17 Answers   Mind Tree,

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

4 Answers   NetWeb,

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

0 Answers  

suppose an interviewer asks you to write a testcase for a login window (and application is not given to test). Should we write actual results or expected results or both?

3 Answers  

What are the different check points for SIT and UAT while testing an Internet Banking application. Consider any one functionality of Internet Banking

0 Answers  

test cases for black board test cases for pencil

2 Answers