Practice Exercise - Excel Driven Testing - 1

The video tutorial explains how to work with a row-based API, focusing on iterating through rows and extracting data from specific columns. It covers the use of iterators to navigate rows and cells, and demonstrates how to extract and print data. The tutorial concludes with a discussion on storing data in arrays for use in test cases, emphasizing the importance of practice to master these concepts.

What is the primary focus of the API discussed in the video?

• Sheet-based methods

• Workbook-based methods

• Row and cell-based methods

• Column-based methods

What is the first step in scanning rows according to the video?

• Using a cell iterator

• Using a sheet iterator

• Using a workbook iterator

• Using a column iterator

What is the main goal when scanning a specific column in a row?

• To count all columns

• To find a specific value

• To iterate through all cells

• To delete a row

Which method is used to check for the presence of the next row?

• row.hasNext()

• row.next()

• row.previous()

• row.current()

How is the logic of iterating through rows described in the video?

• As a traditional Java code

• As a mathematical formula

• As a simple game

• As a complex algorithm

What should be done once a matching value is found in a row?

• Skip the row

• Delete the row

• Extract all cell values from the row

• Move to the next sheet

What is the role of the cell iterator in the process?

• To count the number of cells

• To iterate through each cell in a row

• To format the cells

• To delete cells

What is the purpose of storing data in an array after extraction?

• To print it in a file

• To delete it

• To display it on the console

• To send it to a test case

What is emphasized as crucial for mastering the concepts discussed?

• Attending lectures

• Practicing the code

• Watching more videos

• Reading books

What is the final step after extracting data from a row?

• Ignoring the data

• Deleting the data

• Storing it in an array

• Printing the data