TC-43-001 - Excel data handling
| Test Case ID | TC-43-001 |
| Author | Alena Galysheva |
| Date of creation | 13.06.2023 |
| Class | Functional |
| Type | --- |
Update history
- version 0.1 - 13.06.2023 - Alena Galysheva - test case created
- version 0.2 - 05.07.2023 - Alena Galysheva - test name fixed
Test case description
This test case verifies the functionality of the FEA-43-power-automate-emailing. The goal of this test is to verify that Excel sheet properly stores data entered to it manually.
Source for the test
This test is based on the following feature requirement:
- Use case: Use Case # 1 Creation of Hashes, Automated Email Generation and Delivery
- Feature: FEA-43-power-automate-emailing
Prerequisites and test steps
Prerequisites
- Ensure that the Excel sheet with the required structure for the Power Automate emailing feature is implemented.
- Prepare test data that covers various scenarios and includes entries with different first names, last names, companies, and email addresses.
- Grant the test engineer access to the Excel sheet, allowing them to view and modify the data as needed during testing.
- Create a backup copy of the Excel sheet to safeguard against accidental deletion or modification by the test engineer. This backup ensures that the original data can be restored if necessary.
Test steps
| # | Action | Expected result |
|---|---|---|
| 1 | Open the Excel sheet as an authorized user. | The Excel sheet is successfully opened, allowing authorized access to the data. |
| 2 | Attempt to access the Excel sheet as an unauthorized user. | The unauthorized user is unable to access the Excel sheet and is denied permission. |
| 3 | The unauthorized user is unable to access the Excel sheet and is denied permission. | Every column required for the Power Automate emailing feature is present and correctly labeled. |
| 4 | Check for the presence of the "Send" button in the Excel sheet. | The "Send" button is visible in the main Excel sheet. |
| 5 | Add a row of valid test data to every column except for the Send column. | The test data is successfully added to the Excel sheet, populating each corresponding column. The Send column remains empty be default. |
| 6 | Input valid data to the corresponding row cell in the Send column. | Data is successfully added to the Send column. |
| 7 | Input invalid data into the same cell in the Send column. | The cell displays #VALUE! error. |
| 8 | Add one more row of test data, leaving a column empty. | Data is successfully added to the columns. |
| 9 | Input a row containing a name that already exists in the table. | Data is successfully added. |
| 10 | Input a row containing a name and email that already exist in the table. | Data is added successfully. |
| 11 | Input a row containing a hash that already exists in the table. | The hash cell displays an error. |
| 12 | Test CRUD (Create, Read, Update, Delete) operations on the main table. | All CRUD operations are successfully performed on the main table, allowing data manipulation. |
| 13 | Check the existence of tables within the Excel sheet. | The Excel sheet contains a main table specifically for emailing and a secondary table to store submitted duplicate data. |
| 14 | Check the structure of the duplicate data table. | The duplicate data table mirrors the main table's columns. It does not have a selection column. The email of the user who sent the duplicate data isn't stored. |
| 15 | Test CRUD (Create, Read, Update, Delete) operations on the duplicate table. | CRUD operations can be successfully performed on the duplicate data table, allowing data manipulation within its columns. |
End state
The system should store data entered manually in the Excel sheet without any errors or issues.
To be taken into account during test
N/A
PASS/FAIL Criteria
- PASS: All test steps are completed successfully, and the output matches the expected results.
- FAIL: Any of the test steps fail, or the output does not match the expected results.