Excel 2003 - How do I sort subjects in a worksheet by column?

  • Thread starter computerilliterate!
  • Start date
C

computerilliterate!

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 are:

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top