QUESTIONS AND CORRECT ANSWERS
Write an empty string - CORRECT ANSWER 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?
Using the 'Select' method - CORRECT ANSWER What is the best approach to filter
data from a data table based on a condition?
It will create that file for you and write the data in it. - CORRECT ANSWER What
happens if you try to use a Write Range activity to a .xlsx file that does not exist?
Saves all data from the Data Table to a string variable. - CORRECT ANSWER What is
the Output Data Table activity used for?
For Each Row - CORRECT ANSWER In order to loop through all the rows of a data
table, which activity should be used?
It will read the document successfully. - CORRECT ANSWER What happens if you
use the Excel Read Range activity to read a .xlsx file that is already opened?
Read Range - CORRECT ANSWER What activity can be used to read an entire sheet
from a excel file?
Yes, but only for xlsx files - CORRECT ANSWER Can Excel related activities be used
without having the Excel Application installed?
The first row from the specified range is considered to be the column names - CORRECT
ANSWER What happens if the AddHeaders option is checked for Read Range
Activity?