Failed Grade Count Problem
Use the For-Each structure and an If statement to determine how many test grades listed below are failing. (below 60) Display the number of people who failed the test. Use the table below to enter the 10 grades into column A of the spreadsheet to be used as data for the For-Each statement. See screen-shots web page.
|
Grades in Column A rows 1 to 10 |
||||
|
66 |
78 |
56 |
88 |
92 |
|
46 |
98 |
76 |
78 |
82 |
Create a flowchart and VBA code to solve this problem. Create a command button on the spreadsheet named cmdFailCount. Place the code under the Click event of a command button titled “Fail Count”.
