Answer
1. a. To execute activities in a linear order.
2. b. Excel Process Scope
3. a. By specifying a file path.
4. c. DataTable
5. b. Open Browser
6. b. 30 seconds
7. b. row("ColumnName").ToString
8. a. Simulates typing text into a specified field.
9. a. Selector
10. c. String
11. a. By specifying the sheet name and cell address.
12. c. The entire sheet is read.
13. c. Any Excel-compatible files
14. b. Simulate Type
15. b. Get Text
16. False
17. True
18. False
19. False
20. True
21. True
22. True
23. False
24. True
25. False
Answer 1
26. A Sequence organizes activities in a linear, step-by-step fashion, suitable
for predictable workflows.
27. Excel Process Scope ensures that Excel is properly opened and closed,
avoiding resource conflicts during automation.
28. Use Excel File allows operations within a specific Excel file context,
ensuring the file is always accessible for automation tasks.
29. A DataTable is a tabular data structure; Read Range converts Excel sheet
data into a DataTable for easy processing.
30. Open Browser launches a web browser and navigates to a specified URL
for further web-based automation tasks.
31. For Each Row processes every row in a DataTable, allowing actions like
reading, writing, or processing data.
32. Type Into simulates typing into input fields, such as search boxes or text
areas, with support for background execution.
33. Click simulates a mouse click on a UI element, such as buttons or links,
ensuring interactivity in automation.
34. Get Text extracts visible text from a UI element and stores it as a string for
further use.
35. Write Cell updates a specific cell in an Excel sheet with a given value,
requiring the sheet name and cell address.
36. a. Use Excel File → Read Range → For Each Row → Type Into → Click
37. b. Disable Add Headers
38. b. Use wildcards in the selector.
39. b. Use Excel File → Write Cell
40. b. Click
41. False
42. True
43. True
44. False
45. True
Answer 2
46. b. Simulate Type
47. c. Includes headers in the DataTable.
48. b. Screen Scraping
49. a. Use Try-Catch
50. a. Write Cell
Answer 3