How can you report the defect using excel sheet?

Answer Posted / satyajeet

defect id
summary
severity
priority
author name
status
date
description
attachments
-----------------------------------------------------------
Sample of writing defect report in excel
-----------------------------------------------------------
Defect Id :did_login_01
Summary :Login Module
First Name & Last Name
address
pin code
Telephone No
User ID & Password
User ID & Password
Severity :Medium
Priority :Medium
Author Name:Tester
Status :new
new
new
new
new
new
Date :
Description:First Name > 10 characters
Address > 50 characters
Pin code < 6 Digit
Telephone No > 10 Digit
User Id & Password did not match with the
requirement as per client data
User Id & Password did not match with the
requirement as per client data

Attachments

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the common in all s.o.p (standaed operating procedure)?

1505


How do you perform configuration management with typical revision control systems?

1649


What is a test scenario?

708


Hi Friends, I want to know the best institute in hyderabad which is giving training in 'SAP Testing' and who is the best faculty. Regards, Imtiyaz..

2553


What is early testing?

680






hai friends, I need clarifications for some doubts in testing terminology. 1.What is thread testing. 2.What is bucket testing and which automated tool is used to do this test. 3. ERP testin automation testing. 4.What is Data Warehousing testing? 5.What is Implementation testing? 6.What is Shake out testing? please let me have the clarifications in detail

1553


give me a example of writing a test case,take any good example which i can understand easily.

1660


i have done B.E. computer in 2009 i have done software testing course and also 6 months exp in testing on live project as trainee, now a days i am searching job in pune. can any one tell me any opening in pune?

1569


what are the tests u did in entire project? when it did in the project? (means at the release build to end of project) plz explain clearly

1664


what is entry and exit criteria and explain it?

1028


what are the functional test cases for enter user name,enter pass word,click on ok(only functional test cases)

1951


can u plz give an example for regression testing with example.

1609


What is the difference between a defect and a failure?

658


Explain the difference between severity and priority.

678


negative test cases on banking domain ?

3407