Candidates must configure Excel and email activities correctly, validate file readiness for attachments, handle missing columns gracefully, and move processed emails. The single most important thing is ensuring files are closed and saved before attachment, and that email moves target the correct message.
Start practicing
Excel and Email Automation — choose a session length
Free · No account required
Domain overview
This domain covers automating Excel workbooks and email workflows using UiPath's Excel and Outlook activities, plus SMTP, IMAP, and Exchange integrations. Questions test file readiness for attachments, missing column handling, IOException causes, and moving emails after processing. Expect scenario-based items that require selecting the correct activity and configuring properties for reliable runtime behavior.
Exam objectives
Using Excel Application Scope and Read Range to extract data from workbooks.
Sending emails with attachments via SMTP, Outlook, or Exchange activities.
Handling missing columns by validating schema before processing rows.
Moving emails with Move Outlook Mail Message after processing.
Forgetting to close or save the generated file before attaching it, causing a sharing violation.
Assuming Read Range always returns expected columns; missing columns throw exceptions later.
Using Get Outlook Mail Messages without filtering, then moving wrong emails to subfolders.
Click any question to see the full explanation and answer options, or start a focused practice session above.
You are automating an Excel process that reads a 50,000-row dataset. Which approach ensures the highest performance when extracting data for processing?
2Which TWO actions are necessary when using the 'Use Excel File' and 'Read Range' activities within an Excel Process Scope to ensure the file is properly closed after the process completes?
3Refer to the exhibit. The automation fails to send an email with a 20MB attachment. Which is the most likely cause and solution?
4Which activity should be used to move an email from the Inbox to a specific subfolder after it has been processed?
5Which THREE criteria are commonly used to filter emails when using the 'Get Outlook Mail Messages' activity to ensure only relevant items are retrieved?
6Refer to the exhibit. Why is the Read Range activity throwing an exception even though 'Data.xlsx' exists and contains data?
7You need to send an email with an attachment that is generated during the runtime. What is the critical step to ensure the file is ready to be attached?
8Which activity is best suited for updating a specific cell value in an Excel file without loading the entire sheet into a DataTable?
9Which TWO of the following are true regarding the use of 'Get Outlook Mail Messages' in a production environment?
10How can you ensure that an automation gracefully handles an Excel file that is missing a column required for the business logic?
11Which property in the 'Send SMTP Mail Message' activity should be configured to ensure the email is sent as a high-priority message?
12Refer to the exhibit. Why does the automation throw an IOException when the workflow attempts to access 'FileA.xlsx'?
13You are automating an Excel process that reads a large dataset and performs calculations. Which approach is considered best practice for performance and reliability when interacting with Excel?
14You 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?
15You are building a UiPath automation that reads an Excel file with the Modern Excel activities. The file is stored on a network share, and the robot runs unattended. You need the workflow to reliably open the workbook, read a range, and then close the file without leaving Excel processes running. Which TWO activities or settings are required to achieve this? (Choose two.)
16You are automating an email notification workflow. After processing an invoice, the robot must send a summary email with a PDF attachment to the finance team using the company's SMTP server. Which activity should you use to send the email with the attachment?
17You are automating an Excel process where you need to write a DataTable to an Excel file. You want to ensure that the existing data in the sheet is not overwritten but appended below the last row. Which activity and configuration should you use?
18You are building a workflow to process emails from a shared mailbox using the 'Get Outlook Mail Messages' activity. The workflow must filter emails with a specific subject and save attachments to a local folder. Which two properties or actions are required to achieve this? (Choose two.)
19You are automating a report generation process using UiPath Studio. The workflow opens an Excel file with the 'Use Excel File' activity, writes data to the 'Report' sheet, and then needs to save the file in .xlsx format to a network share. The file must remain open for subsequent steps in the same Excel scope. Which activity should you use to save the workbook while keeping the Excel application open?
Candidates must configure Excel and email activities correctly, validate file readiness for attachments, handle missing columns gracefully, and move processed emails. The single most important thing is ensuring files are closed and saved before attachment, and that email moves target the correct message.
The Courseiva UiPath-ADAv1 question bank contains 19 questions in the Excel and Email Automation domain. Click any question to see the full explanation and answer breakdown.
Start with a 10-question focused session to identify your baseline accuracy in this domain. Read every explanation — even for questions you answer correctly — to understand the reasoning. Once you score consistently above 80%, move to a 20–30 question session to confirm depth before moving to the next domain.
Yes — the session launcher on this page draws questions exclusively from the Excel and Email Automation domain. Choose 10, 20, 30, or 50 questions for a focused session, or click individual questions to review them one by one.
Save your results, see per-domain analytics, and get readiness scores — free, for every certification.
Sign Up FreeFree forever · Every certification included