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.
