Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Answers were Sorted based on User's Feedback



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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Post New Answer

More Test Cases Interview Questions

Write a test case of login window?

0 Answers  


Given the following: Switch PC on Start "outlook" IF outlook appears THEN Send an email Close outlook A. 1 test for statement coverage, 1 for branch coverage B. 1 test for statement coverage, 2 for branch coverage C. 1 test for statement coverage. 3 for branch coverage D. 2 tests for statement coverage, 2 for branch coverage E. 2 tests for statement coverage, 3 for branch coverage

1 Answers   ISTQB,


Hai can anybody give me an idea about writing automated test cases in qtp using VB scprit.please respond as quicky as possible.

2 Answers  


what is the test plan for ms-word

0 Answers  


If for any software product, if the customers more often us few functions, and rarely use few othere functionality. what a tester can expect more deffects can be found, in what area, where the functionality frequently used OR where rarly used?

0 Answers  


How to write test scenarios for a Web application, with an example?

2 Answers  


wirte the test cases for triangle by using testing techniques

8 Answers   Blue Star, George Mason, HP,


how to execute test cases manually

1 Answers  


They were asking sily questions and definitions rather than practical experience related questions. More focused on Definitions.

0 Answers  


Sir I m student I mreading sytem testing as my core paper I want to know how I can make Test case for smple Login Form

4 Answers   IBM,


Can anybody post the format of a Requirement Traceability Matrix. And how to include this RTM in the reqirement document.?

1 Answers  


1.1 Purpose This tool is also a simple tool, but will be graphics- intensive, and will access the 3 databases (card databases) used in Tarot. 1.2 Scope Only for registered user. 1.3 User Interface - No questions asked, parrot pulls out tarot card - Inside Parrot application, User just have to click on a link saying ""XXXX"" to activate the tool. - Shown is the card of the day, from pack of Tarot cards(78 in number) with fixed graphics, animation, audio. Output: - Graphic-rich display of randomly selected card with detailed meaning, with links to tarot tool. - Graphics: Flying / walking parrot, emerging and choosing a card, displaying the same, and continuing to interact based on card meaning. - The cards also need to carry a brief 1/0 meaning, which will trigger a 1/0 behavior from the parrot (sympathy/making fun/crying or congratulating/smiling/winking)

0 Answers  


Categories