Excel Practice Homework Data Validation and Intro to Functions
person145ExcelHomework4-DataValidation.xlsx
CustomerT
| Employee Last Name | Employee ID | Customer First Name | Customer Last Name | Customer Street Address | Customer City | Customer State | Customer Zip Code | Customer Phone Number | Customer E-Mail |
| | 1 | Billy | Gates | 120 Vine Street | Cupertino | CA | 95014 | (805) 467-2259 | bgates@innovate.com |
| | 2 | Leonard | McCoy | 1277 Lombard Street | San Francisco | CA | 95101 | (818) 485-5623 | lmccoy@federation.com |
| | 3 | Jennifer | Lopez | 13 Main Street | Bel Air | CA | 90049 | (805) 723-4578 | jlopez@jloproduction.com |
| | 4 | Jaden | Smith | 13 Avant Garde Row | Portland | OR | 97201 | (951) 234-7754 | jsmith@portlandia.com |
| | 5 | John | Dillinger | 144 Raven Lane | Oak Park | IL | 60301 | (224) 567-8834 | jdillinger@badboyz.com |
| | 6 | Scottie | Pippen | 67 Victory Street | Northbrook | IL | 60062 | (331) 445-3276 | spippen@nike.com |
| | 7 | Phil | Donohue | 20 Miracle Mile | Chicago | IL | 60290 | (312) 546-3281 | pdonahue@omagazine.com |
| | 8 | Salman | Rushdie | 5 Wacker Drive | Chicago | IL | 60290 | (217) 567-2345 | srushdie@laureate.com |
| | 9 | Soledad | O'Brien | 8 Maple Street | Barrington | IL | 60010 | (262) 278-8436 | sobrien@cnn.com |
| | 10 | Edward | Koch | 5577 Bedford Ave | Brooklyn | NY | 11228 | (718) 544-2737 | ekoch@politik.com |
| | 11 | Jon | Bongiovi | 22 Seaside Avenue | Asbury Park | NJ | 22918 | (201) 391-8432 | jbongiovi@bonjovi.com |
| | 12 | Lou | Reed | 89 Sea Spray Drive | Cold Spring Harbor | NY | 11724 | (516) 676-2453 | lreed@madison.com |
| | 13 | Washington | Irving | 455 Mannesmann Drive | Huntington | NY | 11743 | (516) 454-6758 | wirving@headless.com |
| | 14 | Louis | C.K. | 500 Central Park West | New York | NY | 10026 | (212) 456-3782 | lck@comedycentral.com |
| | 15 | Luis | Litt | 25 Buffalo Avenue | New York | NY | 10516 | (345) 190-7889 | llitt@madison.com |
| | 16 | Harvey | Specter | 1015 Orange Street | New York | NY | 11211 | (985) 634-5120 | hspecter@expert.com |
| | 17 | Mike | Ross | 30 Rochester Park Street | New York | NY | 11034 | (790) 321-2463 | mross@sarcasm.com |
| | 18 | Jimmey | Jones | 115 Cherry Street | Milford | CT | 06604 | (212) 456-4390 | jjones@nike.com |
| | 19 | Smith | Taylor | 11 Essex Avenue | Jersey City | NJ | 07707 | (321) 578-4500 | staylor@hotmail.com |
| | | Shawn | Roberts | 124 Boston Post Road | Providence | RI | 02802 | (540) 123-1289 | sroberts@gmail.com |
EmployeeT
| Employee Last Name |
| Collins |
| Moore |
| Smith |
| Modell |
| Knowles |
| Walker |
| Marley |
| Decker |
| Prophet |
| Colon |
| Hartmann |
| Jones |
| Dawson |
| Mertz |