Studio Day 2 Training

Choose the correct statement(s)

• While loop exit when condition not meet
• For Each activity loop through all elements in an array without condition
• DataTable can be created using Build Data Table activity
• Do While loop execute the body at least once before evaluate the expression

What will happen if we remove the highlighted Assign activity from While loop?

• Robot stops automatically

• Infinite Loop

• Robot prompts error

• Robot unable to start

Choose the correct expression(s) to concatenate value of 2 string variables with comma delimiter

• varA + "," + varB
• String.Join(",", varA, varB)
• String.Concat(varA, ",", varB)
• None of the above

What is the data type to store the output of this expression varA.IndexOf("t")? varA="Bottas"

• String
• Boolean
• Integer
• Array of Integer

varA="Sainz". What is the output value of this expression varA.IndexOf("k")?

• -1
• Null Value
• 0
• Empty Value

varA.Split("|"c). What should be the data type to store the result of this expression?

• Array of String
• DataTable
• String
• Dictionary

How a DataTable created?

• Data Scraping
• Read Range
• Read CSV
• Build Data Table

When Read-only properties is checked, it prevents editing and writing to the file in Excel Application Scope?

• True
• False

All are common activities between File Access (Workbook) and Excel Application, except

• Read Range
• Read Cell Formula
• Get Cell Color
• Write Range

Below are the DataTable activities, except

• Add Data Row
• Filter Data Table
• Unmerge Data Table
• Add Data Column