DataTables and Excel Automation 문제

Let's review the main concepts in Excel.

Consider a typical database of employees of a group of companies. What is the natural way of organizing it in an Excel file?

 

Match the concepts on the left with the data pieces on the right.

•  

• The hiring date of an employee - Cell
• The dates of birth of all employees - Column
• All the data of one employee - Row
• All the data of all the employees of one company in the group - Worksheet
• All the data of all the employees of all the companies in the group - Workbook

 

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...

• Choose one of the options below

 

Semi-automation category

 

High-cost RPA category

 

 

No RPA category

 

 

None of the above

 

 

Can activities which require an Excel Application Scope run on a machine that does not have the Excel application installed? 

• Choose one of the options below

 

Yes, but only for .xls files

 

No, these activities require Excel to be installed

 

 

Yes, but only for .xlsx files

 

Yes, for every Excel file type

 

 

Which activity can be used to read an entire sheet from an Excel file?

• Choose one of the options below

 

Get Table Range

 

 

Read Range

 

Read Cell

 

 

What happens if you use a Write Range activity and try to write data in an .xlsx file that does not exist?

• Choose one of the options below

 

It will create that file for you and write the data in it.

 

 

It will throw an error. 

 

It will continue the execution without writing the data.

 

 

Which activity would be your first choice to loop through all the rows of a data table?

• Choose one of the options below

 

While

 

For Each

 

 

For Each Row

 

Join Data Tables

 

 

Which of the following activities can you use if you want to add data to an existing .xlsx document without overwriting existing data?

• Choose all the options that apply

•  

  Workbook Write Range

•  

  Workbook Append Range

•  

  Excel Append Range

•  

  Excel Write Cell

   

   

This project type is recommended for simple, linear workflows without multiple decision nodes.

• Choose one of the options below

 

Sequence

 

State Machine

 

Flowchart

 

What activity can you use to write a data table to a string variable?

• Choose one of the options below

 

Generate Data Table

 

Output Data Table

 

Write Range

 

Merge Data Table

 

 

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...

• Choose one of the options below

 

store them a different variable

 

 

store them in a .CSV file

 

store them in the same variable

 

display them in the Output panel

 

 

store them in an Excel file

 

The body of a loop is executed at least once when this activity is used.

• Choose one of the options below

 

While

 

For Each

 

Do While