can any one give the format of writing test cases in excel
sheet.
Answers were Sorted based on User's Feedback
Answer / himanshu ambekar
Hi,
Right now i cant upload the excel sheet.
but the test case should contain following fields:
Project:___________ Version:________
Module:____________ Screen:________
Operating System:_____ Browser ( if any ):________
Created By:___________ Reviewed By:_________
Date of creation:_________ Date of review:_______
Objective:___________________________________________
These are the common field which will be at the hedder of
the test case.
Following are the column names for the test case:
Sr.No.
Type of testing
Pre-requisit
Aim
Input data (if necessary)
Steps
Excepected Result
Actual Result
Pass/Fail
Assumptions/comments
These should be the fields of the test case.
| Is This Answer Correct ? | 31 Yes | 5 No |
Answer / ranjithreddy
the format for wrinting test cases in excel sheet is
project name:...... date:.. document reference:..
module name:.... prepared by:... secpage/ref no:...
from ref:.... approval by:......
tescaseid
testcse name
test description
input/action
expected
actual
pass or fail/result
if am wrong plz correct me
| Is This Answer Correct ? | 15 Yes | 7 No |
Answer / divya
Hai friend, what our friend Mr.Himanshu Ambekar said is
right, u have to include the Requirement Id/Functional Id
inthe test case design, which will be helpful in preparing
the tracebiity matrix, we can know on the spot which
requirement got failed.
If i am wrong pls correct me
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / mamta
hi friends,
The format for writing test cases in excel sheet-
set up condition- operatimg system should be installed
pre-requisite condition-perticular window should be open &
s/w should be installed .
these two are headings
now coloumns are like this-
Test case ID
Test case name
objective
steps to be taken
test data
expected result
actual result
status
remark
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / poornimavn
can any one give the format of writing test cases in excel
sheet.
first column:test case id
sec column:test serial number
third column:test case description
fourth colum:test case input
fifth column:expected result
sixth column:actual result
seventh colu:status/remarks(pass r fail)
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / n.srikanth
Test Identification No :
Description of Test Item :
Environment :
Tester Name :
Date :
TestCase No
TestCase
Description
Action/Input
Expected output
Actual Result
Pass/Fail
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / srikanth
Defect Id
Testcase Id
Description
Date Posted
Module/Screen
Severity
Detected By
Status
Date Fixed
Fixed By
Remarks
Assigned To
| Is This Answer Correct ? | 4 Yes | 4 No |
Answer / krishna kishroe
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 ? | 3 Yes | 3 No |
Answer / sampath kumar
Fields in test cases:
Assumption:
Test data variables:
Steps to be Executed:
Expected Result:
Actual Result:
Pass/Fail:
Comments:
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / murali kalavakunta
Hi,friends.
write the test cases in excel sheet format is following
given fields.
S.No:
Test case ID:
Purpose:
Preconditions:
Action:
Desired behaviour:
Remarks:
Result:
QA commernts:
If any mistakes Plz let me known
| Is This Answer Correct ? | 6 Yes | 7 No |
How can we write a good test case?
what are the test case scenario for epos/pos testing,and how to initiate the process
in any software company how we got the srs document.how we get it is it available in version control or in mannual we get the document
7 Answers AppLabs, Pinsoftek Infosolutions, TCS,
(questions asked in interview)hi every one can any one please answer to this questions.these questions were asked in an interview.i have another interview next week . 1.when the time schedule is tight how will you approch the testing,and the relese is nearing and we need to finish testing how can we follow in that case.do we need to exicute all the test cases or can priortise and leave some to next relase. 2. when a new feature is added to the existing application we need to add new test cases but after that do we need to change all the existing test cases and while running do we need to exicute entire application test cases or only the new feature test cases and related new feature test cases. 3.do you have any situation where you have to write and exicute the test cases same time, how will you follow.does it happens in real time. 4.example of bug which is not reproducible.like tester say that there is bug and developer say no can some example of such bugs. 5.during regression testing some times do we need to add new some additional test cases to test that bug.
In an online shopping application there are 3 text boxes.One of Login,Add to the shopping cart and Purchase goods.Which & How many test cases can be written for these 3 text boxes?
How to write test case for android application,alarm clock,LCD display screen. And after seeting alarm mobile get switch off how to write test case..
how to write test case for GUI testing and tell me in brief about GUI and all related WEB based testing..if possible then pls give example of its test case...m new in testing........thannx for help in advance
what test case is written specifically for web applications?
10 Answers Aricent, Mind Tree,
Difference between Automation testing and manual testing.
If there are 3 modules what would be test for that three modules but that 3 modules are not developed or what are the test case for that 3 modules
Explain the sanity testing?
i am preparing for interviews in real time job what test cases we have to prepare please explain with example?