UiPath Foundations: Lesson 9 - Excel & Data Tables

If you need to sort a table from an .xlsx file, what should you use? 1) An Excel Sort data table activity. 2) A Workbook Sort Table activity. 3) An Excel Get Table Range activity. 4) You cannot sort a table.

1) An Excel Sort data table activity.

You have an Excel table with two columns named "PersonName" and "Age". What happens if you use the activity Insert Column with the Column Name property set to "Age"? 1) An exception is thrown 2) A new column with the name "Age" is added at the end of the table 3) A new column with the name "Age" is added at the beginning of the table 4) The Column "Age" is overwritten.

1) An exception is thrown.

What activity should you use if you want to add data to an existing .xlsx document without overwrite existing data? 1) Excel Append Range 2) Workbook Write Range 3) Excel Write Cell 4) Workbook Append Range

1) Excel Append Range 4) Workbook Append Range

How do you specify the Excel file to read from, in a Read Cell activity? (Select all that apply.) 1) In the WorkbookPath property, provide the full path of the workbook, 2) You have to open manually the workbook 3) In the WorkbookPath property, provide a relative path, if the workbook is in the project's folder

1) In the WorkbookPath property, provide the full path of the workbook, 3) In the WorkbookPath property, provide a relative path, if the workbook is in the project's folder

What should you use if you want to get the value of a specific cell from a row in a datatable? 1) Lookup data table 2) Output Data Table 3) Add Data Row 4) Get Data Row

1) Lookup data table

What happens if the AddHeaders option is checked for Read Range Activity? 1) The first row from the specified range is considered to be the column names 2) Nothing happens 3) An exception is thrown 4) A new row is added to the excel sheet

1) The first row from the specified range is considered to be the column names

What is the best approach to filter data from a data table based on a condition? 1) Using the 'Select' method 2) Using the 'Clone' method 3) Using Clear Data Table activity 4) Using Format Value activity

1) Using the 'Select' method

What activity should you use if you want to add data to an existing .xlsx document? 1) Workbook Write Range 2) Excel Append Range 3) Workbook Append Range 4) Excel Write Cell

2) Excel Append Range 3) Workbook Append Range

What activity can you use to create a DataTable from an input string? 1) Build Data Table 2) Generate Data Table 3) Output Data Table

2) Generate Data Table

How do you specify the Excel file to read from, in a Read Cell activity? (Select all that apply) 1) You have to open manually the workbook 2) In the WorkbookPath property, provide the full path of the workbook 3) In the WorkbookPath property, provide a relative path, if the workbook is in the project's folder

2) In the WorkbookPath property, provide the full path of the workbook 3) In the WorkbookPath property, provide a relative path, if the workbook is in the project's folder

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

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

Can Excel related activities be used without having the Excel Application installed? 1) Yes, but only for xls files 2) Yes, but only for xlsx files 3) No, UiPath Studio requires MS Office package 4) Yes and it works for every Excel file

2) Yes, but only for xlsx files

What happens if you use the Write Range activity with the Range property set to "" to write a datatable to an excel file that already contains data? 1) It will throw an error. 2) It will append the new data to the existing data. 3) It will overwrite the existing data.

3) It will overwrite the existing data.

What happens if you use the Excel Read Range activity to read a .xlsx file that is already opened? 1) It will throw an error 2) It will read an empty document. 3) It will read the document successfully

3) It will read the document successfully

What activity can be used to read an entire sheet from a excel file? 1) Get Table Range 2) Write CSV 3) Read Range 4) Read Cell

3) Read Range

You need to read from an Excel sheet and you don't know the range. What do you write in the "Range" property of the Read Range Activity? 1) Write just the end cell 2) It's impossible, you have to specify the range 3) Write an empty string 4) Write some random range

3) Write an empty string

In order to loop through all the rows of a data table, which activity should be used? 1)Do While 2) For Each 3) While 4) For Each Row

4) For Each Row

What activity can be used to read an entire sheet from a excel file? 1) Write CSV 2) Get Table Range 3) Read Cell 4) Read Range

4) Read Range

What is the Output Data Table activity used for? 1) None of the options. 2) Printing the Data Table in the Output panel. 3) Converting data to a Data Table. 4) Saves all data from the Data Table to a string variable.

4) Saves all data from the Data Table to a string variable.