UiPath-ADPv1 Advanced Data Manipulation Practice Question
A UiPath process reads a monthly sales workbook where each sheet uses the same layout but the sheet name is appended with the region, for example 'Sales_EMEA'. The workbook path and region are provided as arguments at runtime. You must extract every data row from the sheet matching that region and load it into a DataTable. (Choose two.)
⚠ Common exam trap
Many candidates confuse the Range property, which expects cell addresses, with the SheetName property, which is the one that accepts a dynamic sheet identifier.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the Read Range activity inside an Excel Application Scope, setting the SheetName property to a dynamic expression that concatenates the 'Sales_' prefix with the region argument.
Reading the correct region sheet requires targeting it dynamically at runtime. Read Range accepts a dynamically built SheetName, and Get Workbook Sheets allows resolving the exact name when suffixes vary. Both approaches open the workbook through the Excel activities and yield the region's rows as a DataTable. Specifying a range address, filtering before reading, or writing sheets do not perform the required read of the region-specific worksheet.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Read Range with the Range property set to the region argument so that only cells whose content equals the region are returned.
Why it's wrong here
The Range property expects a cell or cell-range address such as 'A1:D50', not a region name. Passing a region value there either throws an invalid-range error or returns nothing meaningful, and no filtering by cell content occurs. This misuses the activity's contract and would not produce a DataTable of the region's rows, so it fails the scenario's requirement even though the syntax looks superficially plausible.
- ✗
Use the Filter Data Table activity with a condition on the region column, without specifying a sheet, to isolate the region's rows.
Why it's wrong here
Filter Data Table operates on a DataTable that has already been loaded; it cannot select which worksheet to read and does not open the workbook. Invoking it without a prior read step leaves no input data to filter, and it has no concept of sheet names. While filtering on a region column is a valid operation after loading all sheets, it does not satisfy the need to read the correct region sheet into a DataTable here.
- ✓
Use the Read Range activity inside an Excel Application Scope, setting the SheetName property to a dynamic expression that concatenates the 'Sales_' prefix with the region argument.
Why this is correct
Read Range accepts a dynamically evaluated SheetName expression, so concatenating the literal prefix with the region argument targets the correct worksheet at runtime without hardcoding a name. Placing it inside an Excel Application Scope ensures the workbook is open and the sheet is resolvable. This satisfies the requirement to load the region-specific rows into a DataTable while keeping the automation reusable across regions by simply varying the argument value.
- ✗
Use the Write Range activity with the region argument as the sheet name to normalize the workbook so all regions share a single sheet.
Why it's wrong here
Write Range writes a DataTable into a worksheet; it does not read or consolidate existing sheets, and it requires an input DataTable that this workflow has not yet produced. Pointing it at a region-named sheet would overwrite or create that sheet, risking data loss rather than extracting rows. This activity is the wrong direction of data flow for the stated goal of loading region rows into a DataTable.
- ✓
Use the Get Workbook Sheets activity to enumerate sheet names, then select the name whose suffix matches the region argument before reading it.
Why this is correct
Get Workbook Sheets returns the collection of worksheet names, letting the workflow locate the sheet whose name ends with the region argument rather than assuming the exact concatenation. This is robust when sheet names include unexpected spacing or casing variations, and the resolved name can then be passed to Read Range. It directly supports extracting the correct region's rows into a DataTable while tolerating minor naming inconsistencies in the source workbook.
Visual reference
About these practice questions
Courseiva writes every UiPath-ADPv1 question from scratch — 276 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official UiPath exam blueprint
This UiPath-ADPv1 practice question is part of Courseiva's free UiPath certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the UiPath-ADPv1 exam.