ee1-p6 drill

ee1-p6 drill - 680d5fe8959f2241469641ed72f3aa19608193b6.xls...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 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 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...
View Full Document

This note was uploaded on 04/08/2008 for the course ITECH 1103 taught by Professor Mcalpine during the Spring '08 term at Emmanuel.

Page1 / 5

ee1-p6 drill - 680d5fe8959f2241469641ed72f3aa19608193b6.xls...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online