Blue Prism Exam AD01 Topic 1 Question 80 Discussion

Actual exam question for Blue Prism's AD01 exam

Question #: 80
Topic #: 1

[All AD01 Questions]

Which of the following is the correct order to collect data using the Excel VBO?

AOpen Workbook > Get Worksheet as a Collection > Close Workbook

BShow Excel > Open Workbook > Get Worksheet as a Collection > Close Workbook

CCreate Instance > Open Workbook > Get Worksheet as a Collection > Close Workbook

DCreate Instance > Show Excel > Get Worksheet as a Collection > Close Workbook

Show Suggested Answer

Suggested Answer: C

Excel VBO Workflow:

The correct order to perform operations using the Excel VBO involves creating an instance, opening the workbook, performing actions (like getting the worksheet as a collection), and then closing the workbook.

Correct Order:

Create Instance: Initializes the Excel application instance.

Open Workbook: Opens the specified Excel workbook.

Get Worksheet as a Collection: Reads the worksheet data into a collection.

Close Workbook: Closes the workbook after operations are completed.

Blue Prism documentation on Excel VBO and its actions.

by Carin at Sep 16, 2024, 10:29 AM

Limited Time Offer

25%

Off

Get Premium AD01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Alesia

7 months ago

Is this a trick question? I'm going to have to say B, just to see if the examiner has a sense of humor.

upvoted 0 times

...

Aracelis

8 months ago

I guess the Excel VBO stands for 'Very Boring Operations'! But I'll still go with C because it makes the most sense to me.

upvoted 0 times

...

Deeanna

8 months ago

Hmm, this is a tough one. I'm going to go with A. It seems like the most straightforward approach.

upvoted 0 times

Lewis

6 months ago

User 4: I'll go with B, just to mix it up.

upvoted 0 times

...

Zachary

6 months ago

User 3: A seems like the best option to me too.

upvoted 0 times

...

Chau

6 months ago

User 2: I'm going with D, it sounds right to me.

upvoted 0 times

...

Antonio

6 months ago

User 1: I think the correct order is C.

upvoted 0 times

...

Rhea

8 months ago

D is the way to go! Creating an instance and showing Excel is the most efficient approach.

upvoted 0 times

Dorothy

7 months ago

I always use option D when working with Excel VBO, it's the best way to go.

upvoted 0 times

...

Helene

7 months ago

Creating an instance and showing Excel first makes the process more efficient.

upvoted 0 times

...

Janet

7 months ago

I agree, option D is definitely the correct order to collect data using the Excel VBO.

upvoted 0 times

...

Zona

8 months ago

I'll go with B. Showing Excel first makes it more user-friendly, and the rest of the steps seem logical.

upvoted 0 times

Sarah

7 months ago

User4: B seems like the best option to me, user-friendly approach.

upvoted 0 times

...

Verdell

7 months ago

The rest of the steps seem logical too.

upvoted 0 times

...

Marquetta

7 months ago

I agree, showing Excel first does make it more user-friendly.

upvoted 0 times

...

Marti

7 months ago

I'm going with D, showing Excel before getting the worksheet.

upvoted 0 times

...

Scarlet

8 months ago

I agree with User1, creating an instance first makes sense.

upvoted 0 times

...

Melvin

8 months ago

I think B is the correct order.

upvoted 0 times

...

Bok

8 months ago

I think C is the correct order.

upvoted 0 times

...

Margret

9 months ago

But creating an instance first makes more sense to me, so I still think C) is the correct order.

upvoted 0 times

...

Jovita

9 months ago

I disagree, I believe it is A) Open Workbook > Get Worksheet as a Collection > Close Workbook.

upvoted 0 times

...

Shalon

9 months ago

I think the correct answer is C. Creating an instance before opening the workbook makes sense, as you need an instance of Excel to work with.

upvoted 0 times

Mitsue

8 months ago

I agree, creating an instance before opening the workbook is the correct order.

upvoted 0 times

...

Tamekia

9 months ago

I think the correct answer is C.

upvoted 0 times

...

Margret

9 months ago

I think the correct order is C) Create Instance > Open Workbook > Get Worksheet as a Collection > Close Workbook.

upvoted 0 times

...