Assignment #7   (20 points) Watch the video Sorting (CC). Create an application using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image below. Your command buttons should sort data by various columns, extract the lowest sales and highest sales, compute average sales in Oklahoma, and display the number of stores with sales >= $3000. The interface can be downloaded from the Assignment #7 folder. Save your work as "assignment7.xlsm". The "Save as type" should be "Excel Macro-Enabled Workbook (*.xlsm)". Upload this file to your YOUR-CLASS-WEBSITE. Help.

Grading Rubric

Required Elements	Points Possible	Does not meet requirements	Meets some requirements	Meets or exceeds all requirements	Your Score
Effectively created an application using Visual Basic for Applications (VBA) similar to the one developed in the video and shown in the image above. Your command buttons should sort data by various columns, extract the lowest sales and highest sales, compute average sales in Oklahoma, and display the number of stores with sales >= $3000.	20	0	10	20	__/20
Total points					__/20