UiPath-ADAv1 Excel and Email Automation Practice Question
You are automating a monthly report using the Modern Excel activities. The workflow opens 'Report.xlsx' with a Use Excel File activity, reads data into a DataTable, and then must write the processed DataTable back into a new worksheet named 'Summary' in the same file. Which activity should you use to create the new sheet and write the DataTable in a single step?
⚠ Common exam trap
The trap here is assuming Append Range can create a missing sheet and write a full DataTable, when it only appends rows to an existing range.
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
✓
Write DataTable to Excel
The Modern Excel Write DataTable to Excel activity creates the target sheet if absent and writes the whole DataTable in one operation, which matches the requirement to add a 'Summary' sheet and populate it. Append Range, Write Cell, and Create Table all fail to both create the sheet and write the full DataTable in a single step.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Write DataTable to Excel
Why this is correct
Write DataTable to Excel creates the specified sheet if it does not exist and writes the entire DataTable starting at the given cell. It operates within the Excel Process Scope and the Use Excel File context, so it is the correct single-step activity for adding a 'Summary' worksheet and populating it with the processed DataTable.
- ✗
Create Table
Why it's wrong here
Create Table formats an existing range as an Excel table. It does not write DataTable contents and does not create a new sheet with data. Using it here would leave the 'Summary' sheet empty or missing, and the processed DataTable would not be persisted to the workbook.
- ✗
Write Cell
Why it's wrong here
Write Cell writes a single value to one cell. To write an entire DataTable with Write Cell you would need to loop through every row and column, which is inefficient and error-prone. It also does not create a new worksheet automatically, so it cannot satisfy the requirement in a single step.
- ✗
Append Range
Why it's wrong here
Append Range adds rows to the end of an existing range or sheet. It does not create a new named worksheet when the target sheet is missing, so using it for a brand-new 'Summary' sheet would fail or place data incorrectly. It is intended for appending data, not for creating and writing a full DataTable.
About these practice questions
This UiPath-ADAv1 question is part of Courseiva's 285-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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-ADAv1 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-ADAv1 exam.