Page 16 of 24PREVNEXT

Get in the loop with Excel macros

Test yourself

Complete the following test so you can be sure you understand the material. Your answers are private, and test results are not scored.

If you want a loop to run until it finds a specified value, what type of loop would you use?

A For Each…Next Loop

A Do...Loop

A Loop-dee-Loop

When looping through a list in Excel, is it easier to use the Cells property or the Range property?

The Cells property

The Range property

When is it best to use a Do…Loop?

When your range of data can grow or shrink.

When the end of your data range is shown by a specific value or condition.

When you don't need to loop through every cell.

All of the above.

Page 16 of 24PREVNEXT