{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ee1-p6 drill - A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 B C...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
680d5fe8959f2241469641ed72f3aa19608193b6.xls Overview 05/08/2009 Project 6 Challenges: Sorting, Filtering, and Editing Lists What would you like to do? Skill Sheet 1. Sort on three fields #1-Sort3 2. Filter for the highest five items #2-FilterHigh5 3. Filter for the top 10 percent #3-FilterTop10 4. Edit a series of records #4-EditSeries Challenge exercises expand on or are somewhat related to skills presented in Essentials lessons. If you have problems, use on-screen Help. A B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
680d5fe8959f2241469641ed72f3aa19608193b6.xls #1-Sort3 05/08/2009 Project 6 Challenge: Sorting on three fields Indy 500 Motor Works 2-Minute Customer Survey - First Quarter 2002 ID Car Size Date Rented Daily Rate 1 Per cc Truck 1/1/2002 1/5/2002 4 $19.00 $76.00 4 other other 2 Per acct Mid Size 3/3/2002 3/15/2002 12 $11.50 $138.00 3 basketball WSJ 3 Per cc Full Size 2/16/2002 2/25/2002 9 $14.00 $126.00 5 tennis U.S. News 4 Per cc Luxury 3/11/2002 3/14/2002 3 $26.00 $78.00 5 golf WSJ 5 Per cc SubComp 2/6/2002 2/9/2002 3 $7.50 $22.50 1 football Time 6 Per cc Luxury 2/19/2002 2/22/2002 3 $26.00 $78.00 4 golf Fortune 7 Bus acct Mid Size 1/1/2002 1/5/2002 4 $11.50 $46.00 3 tennis Fortune 8 Bus acct Mid Size 1/12/2002 1/13/2002 1 $11.50 $11.50 1 football other 9 Bus cc Truck 2/1/2002 2/7/2002 6 $19.00 $114.00 4 other Fortune 10 Bus acct Full Size 1/23/2002 1/27/2002 4 $14.00 $56.00 2 basketball U.S. News 11 Per cc Luxury 3/1/2002 3/8/2002 7 $26.00 $182.00 2 golf WSJ 12 Per cc Mid Size 2/13/2002 2/14/2002 1 $11.50 $11.50 5 tennis Fortune 13 Bus cc Full Size 1/9/2002 1/12/2002 3 $14.00 $42.00 4 golf U.S. News 14 Per acct Truck 2/6/2002 2/21/2002 15 $19.00 $285.00 4 other other 15 Bus cc Compact 3/2/2002 3/4/2002 2 $8.90 $17.80 1 baseball WSJ 16 Bus cc Full Size 2/28/2002 3/14/2002 14 $14.00 $196.00 4 golf U.S. News 17 Bus cc Truck 2/25/2002 2/27/2002 2 $19.00 $38.00 5 other other 18 Per acct Luxury 1/15/2002 1/30/2002 15 $26.00 $390.00 3 golf U.S. News 19 Bus acct Compact 3/13/2002 3/15/2002 2 $8.90 $17.80 4 baseball Newsweek 20 Bus cc Compact 1/9/2002 1/12/2002 3 $8.90 $26.70 4 football Time 21 Bus acct Full Size 2/8/2002 2/14/2002 6 $14.00 $84.00 2 basketball U.S. News 22 Per cc SubComp 1/8/2002 1/18/2002 10 $7.50 $75.00 4 football Time 23 Bus cc Luxury 2/9/2002 2/16/2002 7 $26.00 $182.00 1 golf WSJ 24 Per cc Compact 2/22/2002 2/28/2002 6 $8.90 $53.40 4 baseball Newsweek 25 Per acct Full Size 3/4/2002 3/14/2002 10 $14.00 $140.00 4 basketball U.S. News 26 Bus cc Truck 2/25/2002 2/27/2002 2 $19.00 $38.00 5 other Newsweek 27 Per acct Luxury 1/15/2002 1/30/2002 15 $26.00 $390.00 3 golf other 28 Bus acct Compact 3/13/2002 3/15/2002 2 $8.90 $17.80
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}