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 |
"search"test cases on Linkedin website and how will you write test cases on it?
What is the correct answer of basic types of test cases ?
Requirement from Market “Alice is talking to Bob. Bob thinks that Alice should talk to Chris for more information. Currently, Bob will pass on the directory number of Chris to Alice; Alice/Bob will disconnect the call and then Alice will initiate a new call to Chris. What we need need, Bob should be able to transfer the call to Chris, without Alice making another call.” Implementation done by Unified CM Development Team When a basic call is connected, a new softkey “Transfer” will be displayed on the IP Phone. User (say, Bob) can press that and dial a target (say, Chris). Bob has two options (1) wait for Chris to answer and then tell Chris about call from Alice and then press “transfer” again to complete transfer (2) press “Transfer” immediately; when Chris answers he will be connected to Alice Please come up with test cases thinking from a user perspective, let’s say from a Bank (there could be users such as receptionists, accountants, managers etc.) – in what all scenarios transfer can happen, any negative scenarios (cases where we don’t get a positive response always). If you think you need an enhancement to the feature, please go ahead and suggest that as well.
Write a test case for a chair to check whether it will last for next 10 years and check the quality of the chair and it’s durability.
write a test case for authentication of a login page from database
For example out of 100 test cases if I ask you to automate how many you can automate?
13 Answers HCL, MBT,
What is the syntax testing?
how many test cases do u need to ship a product?
Hi My name is Hari Priya i had completed by b-tech csit 2008 pass out i had joined in testing tools does freshers having good opportunities in testing field? what are the topics to be stressed in the subject to have the good knowledge If any one have good collecton of testing topics can mail me padmajapriyam@gmail.com thank you.
What are the Test Cases for an email id for username and password?
pls i want test cases for oss? whts the process of oss testing
How to write test scenarios for a Web application, with an example?
3 Answers Deloitte, LiveTech, TCS,