Test Cases Template

1. README sheet

Explains the purpose of the file.

How to use each sheet.

Notes about English and Arabic examples.

Acts as quick guidance for anyone opening the file.

2. Test_Cases sheet

This is the main sheet where you manage all test cases.

Columns included:

Test Case ID

Module/Feature

Title

Description

Steps

Expected Result

Actual Result

Status (Pass, Fail, Blocked, Not Run)

Priority (High, Medium, Low)

Severity (Critical, Major, Minor)

Type (Functional, Regression, Smoke, etc.)

Environment

Build

Tester

Execution Date

Comments

Comes with sample test cases in both English and Arabic.

Conditional formatting highlights status:

Green = Pass

Red = Fail

Yellow = Blocked

3. Test_Data sheet

Stores input data used during test execution.

Columns: Category, Key, Value, Notes.

Example included in English and Arabic (like email addresses).

4. Lookups sheet

Contains dropdown options for:

Status (Pass, Fail, Blocked, Not Run)

Priority (High, Medium, Low)

Severity (Critical, Major, Minor)

Type (Functional, Regression, Smoke, etc.)

Helps keep test data consistent.

5. Metrics sheet

Summarizes execution results for reporting.

Columns: Module, Total Cases, Passed, Failed, Blocked, Not Run.

Example data filled for Login and Registration.