How to Prepare Test Cases for Gmail in Excel Sheet (with Easy Steps)

Step 1: Setting Up Format

To create test cases for Gmail in an Excel sheet, follow these steps:

  • Create the Template:
    • Set up a format with nine columns.
    • Divide the template into two parts for better visualization.
    • The first part includes the following fields:
      • Test Scenario: Describes the scenario for the test cases.
      • Tester: Indicates the person responsible for the testing process.
    • The second part includes the following columns:
      • ID: Assign a unique identification number to each test case.
      • Test Case: Specify the subject of the test procedure.
      • Pre-condition: If there are any prerequisites for a test case, input them here.
      • Test Steps: List the required steps to carry out a test case.
      • Test Data: Use this column to enter any necessary data.

Setting Up Format to Prepare Test Cases for Gmail in Excel Sheet

  • Additional Columns:
    • Add more columns:
      • Date: Record the date when the test is carried out.
      • Expected Output: Describe the most likely output if everything works perfectly.
      • Actual Output: Document the real output obtained from a test case.
      • Status: Indicate whether the test case passed, was skipped, or failed.
      • Comments: Use this column for any additional comments by testers.

Read More: Create Test Cases for Login Page in Excel Sheet

Step 2: Entering Relevant Data

  • Enter the relevant data into the empty cells.

Entering Relevant Data to Prepare Test Cases for Gmail in Excel Sheet

  • To improve readability, apply the Wrap Text feature to format cell values.

  • You may also need to adjust row heights using AutoFit.

Test Cases for Gmail in Excel Sheet

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

Step 3: Determining Test Status

In this step, we’ll create a formula using the IF and OR functions to find the test case status for Gmail in the Excel sheet.

  • Type the following formula in cell I10:

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

Finding Test Status to Prepare Test Cases for Gmail in Excel Sheet

  • Press Enter to apply the formula.

Formula Breakdown

  • OR(G10=H10,H10=”As expected”) evaluates to True if either:
    • The value of cell G10 equals the value of cell H10, or
    • The value of cell H10 is “As expected.”
  • The formula simplifies to -> IF(TRUE,”Pass”,”Fail”), resulting in “Pass” as the output.
  • Use the Fill Handle to fill the formulas to the rest of the cells.

Read More: How to Create Test Cases for Registration Form in Excel Sheet

Step 4: Creating Another Test Scenario

Follow these steps to create test cases for the Gmail sign-in page in an Excel sheet:

  • Set up the format.

Creating Another Test Scenario to Prepare Test Cases for Gmail in Excel Sheet

  • Enter relevant data and apply Wrap Text.

  • Use the same formula as in the account creation form to determine the test status:

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

Read More: Test Cases for Banking Application in Excel Sheet

Download Practice Workbook

You can download the practice workbook from here:

Related Article

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

Get FREE Advanced Excel Exercises with Solutions!
Rafiul Haq
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

Advanced Excel Exercises with Solutions PDF