How to Create Test Cases for an ATM Machine in Excel – 3 Steps

Step 1: Setting Up Format

Set up a format for the test cases for the ATM machine in the Excel sheet: nine columns, here.

• Create the following fields –
  • Test Scenario: The test scenario for the test cases.
  • Tester: The person responsible for the testing process.
• Create the following columns –
  • ID: A unique identification number for each test case.
  • Test Case: The subject for a test procedure.
  • Pre-condition: If there is any prerequisite for a test case.
  • Test Steps: Required test steps to carry out a test case.
  • Test Data: If any data needs to be entered.

• Insert more columns –
  • Date: The date when the test is carried out.
  • Expected Output: The most likely output.
  • Actual Output: The real output.
  • Status: Pass, Skip or Fail.
  • Comments: If a tester needs to make comments.

Read More: How to Write Test Cases in Excel Sheet

Step 2: Entering Relevant Data

Use the Wrap Text feature to format cell values.  AutoFit the rows.

•  Enter the values into the empty cells.

• Select the cell range.
• Go to the Home tab, select Wrap Text in Alignment.

• Data is adequately displayed.

Read More: Test Cases for Banking Application in Excel Sheet

Step 3 – Finding the Test Status

• Enter the following formula in I10.

• Press Enter.

• Drag down the Fill Handle to see the result in the rest of the cells.

• This is the output.

Read More: Test Cases for E-Commerce Website in Excel

Download Practice Workbook

Download the Excel file here.

Related Articles

• Prepare Test Cases for Gmail in Excel Sheet
• How to Create Test Cases for Registration Form in Excel Sheet
• Create Test Cases for Login Page in Excel Sheet 
• How to Export Test Cases from ALM to Excel

<< Go Back to Excel Test Cases Template | Excel Templates