Quiz: Excel and Data Tables

What expression would you use to instantiate a dictionary variable that pairs names (key) with ages (value)? A. New Dictionary(of String, Int32) B. Dictionary (String, Int32) C. New Dictionary(of Int32, String) D. Dictionary (Int32, String)

A

You have included a Sort Data Table activity in your workflow. The DataTable variable is called dt_Usernames. The Input DataTable field is set to the dt_Usernames variable and the Output DataTable field is also set to dt_Usernames. The activity will sort the Data Table values and: A. Store them in the B. Display them in the Output panel C. Store them as a different variable D. Store them in a .CSV file E. Store them in an Excel file

A

From an automation potential standpoint, a process in which changes are frequent, the system environment is volatile, and multiple manual (even non-digital) actions are required belongs to the ... A. High-Cost RPA category B. No RPA category C. None of the above D. Semi-Automation category

B

This project type is recommended for simple, linear workflows without multiple decision nodes. A. State Machine B. Sequence C. Flowchart

B

What activities can you use to create a data table from unstructured data? A. Output Data Table B. Generate Data Table C. Build Data Table

B

Which activity can be used to read an entire sheet from an Excel file? A. Read Cell B. Read Range C. Get Table Range

B

What activity can you use if you want to add data to an existing .xlsx document without overwriting existing data? A. Excel Write Cell B. Workbook Append Range C. Workbook Write Range D. Excel Append Range

B, D

Can Excel related activities run on a machine that does not have the Excel application installed? A. Yes, but only for xls files B. No C. Yes, but only for .xlsx files D. Yes, for every Excel file type.

C

What happens if you use a Write Range activity and try to write data in an .xlsx file that does not exist? A. It will throw an error B. It will continue the execution without writing the data. C. It will create that file for you and write the data in it.

C

Which activity would be your first choice to loop through all the rows of a data table? A. While B. For Each C. Join Data Table D. For Each Row

D