How can you report the defect using excel sheet?
Answer Posted / mukesh sharma
Bug List in excel sheet contains mentioned fields:
Bug ID : Unique no./name for future reference.
Description : Summary about bug/defect/error.
Raised in Build/ Release/ Version/ Sprint : The version no. of current build, in this build test engineers detected the bug.
Feature : The name of module / function / feature, in that area test engineers found the bug.
Test Case Name : The name of failed test case, in that case execution test engineer found this bug.
Status : Life cycle of the bug.
New : A new bug detected by a tester
Open : A bug that has been reviewed and verified as a true bug
Rejected : A bug that has been found not to be a bug
Assigned : A bug that has been verified by development and is now assigned to developers for fixing
Fixed : A bug that has been fixed and is ready for retesting
ReTest : A bug that has been fixed by developers, which is once again tested to be closed
ReOpen : A bug that has failed testing during ReTest
Closed : A bug that has successfully passed retesting
Deferred : A bug that has been mutually agreed to move to the next release or later releases.
Duplicate : If the bug is repeated twice or the two bugs mention the same concept of the bug, then the recent/latest bug status is changed to “duplicate“.
Not A Bug : If there is no change in the functionality of the application. Work as expected.
Severity : The seriousness of bug in terms of functionality.
High : Not able to continue testing with out resolving this bug (show stopper)
Medium : Able to continue remaining testing, but mandatory resolve.
Low : Able to continue remaining testing and may / may not to resolve.
Priority : Importance of bug to resolve in terms of customer (High, Medium, Low)
Detected By : Name of test engineer.
Assigned To : The name of responsible person at development side to receive this bug report.
Open Date : Date of bug found.
Closed Date : Date of bug fixed.
Verified in Build/ Release/ Version/ Sprint : The version no. of current build, in this build test engineers tested and verified the bug.
Testers Comments : Comments related to Bug Status, Severity, Priority, Suggestion to fix etc. Comments by testers.
Developers Comments : Comments by developers
Attachment : Screenshot or video Link.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
1.what promted you to become involved in QA/Testing?
Hi Could someone please provide Siebel Testing Interview questions for 5 years exp.
Negatives test cases of gmail login page With its severity , priority and expected results columns Through test case template-oodles technologies gurgoan
how to explain banking domain project in testing?
what are the 3 test tool categories and describe what each can do.
What is a code walk through?
Hi,all i have a desktop App. which have a feature, It's a demo version if u want full version then u have to perches it. Pls give me some idea ASAP how can i break the App.
What is a top-down and bottom-up approach in testing?
What is client server application testing?
If I want to check compability of software in a MAC OS then which steps shold I follow?
can anybody send the project you have tested with the clear descriptions,and recent bugs u found in that
What is a test severity and test priority? difference between them with suitable examples?
define Testing of Procedure, Triggers and Functions in data base testing ?
Explain user acceptance testing.
Test Cases For Router&Switch