How to Create Test Cases for a Registration Form in Excel – 3 Steps

Written by Rafiul Haq

Last updated: May 14, 2024

Step 1 – Setting Up the Format

There will be ten columns in this template.

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: assign a unique identification number for each test case.
- Test Case: the subject for the test procedure.
- Pre-condition: existing pre-requisites for the test case.
- Test Steps: steps to carry out the test case.
- Test Data: data that needs to be entered.

Insert more columns –
- Date: the date of the test.
- Expected Output: the most likely output.
- Actual Output: the real output.
- Status: Pass, Skip or Fail.
- Comments: tester’s comments.

Read More: Prepare Test Cases for Gmail in Excel Sheet

Step 2 – Entering Relevant Data

Enter relevant data. Use the Wrap Text feature to format cell values and the AutoFit to adjust the rows.

Enter the values into the empty cells.

Select the range shown in the image below.
Go to the Home tab.
In Alignment, select Wrap Text .

Data will be correctly displayed.

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

Step 3 – Finding the Test Status

Combine the IF and OR functions to find the test case status.

Enter the following formula in I10.

=IF(OR(G10=H10,H10="As expected"),"Pass","Fail")

Press Enter.

Formula Breakdown

OR(G10=H10,H10=”As expected”)
- Output: True.
- This function checks whether the value of G10 is equal to H10 or the value of H10 is equal to “As expected”.
Then, the formula reduces to -> IF(TRUE,”Pass”,”Fail”)
- Output: Pass.
- As the condition is true, the formula returns “Pass”.

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

Read More: Test Cases for Banking Application in Excel Sheet

Test Cases for a Login Page in Excel Sheet

Create test cases for a login page.

Steps:

Prepare the template to enter the test cases.

Enter relevant values in the cells.

Enter this formula in I10 to return the test status. (The formula is the same as the one used in the registration form)

=IF(OR(G10=H10,H10="As expected"),"Pass","Fail")

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

Practice Section

Practice with this template.

Download Practice Workbook

Download the Excel file here.

Registration Form Test Cases.xlsx

Related Article

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

Get FREE Advanced Excel Exercises with Solutions!

SaveSavedRemoved 0

Tags: Excel Test Cases Template

Rafiul Haq

Rafiul Haq worked as an Excel and VBA Content Developer in Exceldemy for over two years and published almost 200 articles for the website. He is passionate about exploring new aspects of Excel and VBA. He received his Bachelor of Science in Mechanical and Production Engineering (MPE) from the Islamic University of Technology. Rafiul furthered his education by obtaining an MBA in Finance from the Institute of Business Administration (IBA) at the University of Dhaka. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply Cancel reply

Submit Excel Problem