You want to hire some ducks for your new movie, "The Night of the Zombie Ducks." You go to your local duck pond, and ask the ducks to text you the number of times they quack each day. Through the Magic of Technology, the data is collected in an Excel workbook. Each text has the sender's DuId (duck id) added to it automatically.
Here's a sample:
Duck beaks aren't the best for texting, so there could be bad data. Also, some ducks didn't follow the instructions, as in row 7.
Download the workbook, so you can add your own code. Write a program that does two things:
- Draws lines through rows that have bad data. Quacks per day could be nonnumeric, or less than zero.
- Mark the ducks that quack 70 or more times per day.
Here's some output:
Look at row 7. Both cells have strikethroughs.
Hints:
- The first row doesn't have data in it.
- Useful code you can adapt:
Cells(7, 7).Font.Strikethrough = True
Upload your workbook. The usual coding standards apply, as always.
In the text box on the submission form, please answer this question: What did you learn from this exercise?
(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)
