Quiz on rpa activities about read range activity

What is the use of Read Range Activity?

It is used to Read the range of sheet in excel

It is used to read the whole excel range

It is used to read a cell in excel

It is used to write the data to excel

Correct! Wrong!

What is the input for Read Range Activity?

It is .txt file

It is .docx file

It is .xlsx file

All of the above

Correct! Wrong!

Can different sheets be read using Read Range Activity?

No

It has a default sheet and can't be changed

YES

None of the above

Correct! Wrong!

How do you define range in Read Range Activity?

"A1;A10"

A1:A10

"A1:A10"

"A:A10"

Correct! Wrong!

How to read data along with headers using Read Range Activity?

Get Headers

Use Headers

Add Headers

Push Headers

Correct! Wrong!

What option will be used to preserve the excel format?

Keep Format

PreserveFormat

Get Format

None of the above

Correct! Wrong!

What is preserve format option in Read Range Activity?

It keeps all the rows one after the other

It keeps the data preserved

It keeps the formatting of the range that you want to read.

All of the above

Correct! Wrong!

Will preserve format slow down the process of reading the excel Range?

No

It speeds up the process

YES

None of the above

Correct! Wrong!

Why preserve format option slows down the process of reading excel range?

Because it reads data in bulk

Because it reads row by row

Because the data is read in two half's

Because the cells are read one by one

Correct! Wrong!