Hi, I am getting ready to take a test. I have a worksheet that I found on
the internet (not related to the test), and I want to work with that to
practice on. I've taken the test before, and the questions asked a

1. Sort by name, years employed, position and region
2. Sort by Sales Rep, name, years employed, region (It asked to pull out
the Sales Rep people, then sort them by name and years employed, and region
3. Take the average of sales by a certain position.

I have the worksheet and can show it to you.

Thanks in advance for any help you can give me!


Here's an example of the worksheet:

Name Years Employed Position Region HW Sales
SW Sales

Smith, Betty 5 Sales Rep Eastern
234,000 150,00
Jones, Steve 4 Sales Rep Central
115,000 105,000
Williams, Tom 2 Telemarketer Western 143,000
120,000
Brown, Bill 6 Sr Sales Rep Central
132,000 225,000
Richards, John 7 Manager Western
125,000 182,000