1.37 Tech Tool: Spreadsheet Software Software Video: Spreadsheet Data Tables EspressoCoffee has given you the following work assignment.

1. Using spreadsheet software and the following information, create a CUSTOMER table for EspressoCoffee.

2. Identify the primary key by highlighting the column in yellow.
3. Populate the CUSTOMER table by entering the following customer information.
Customer No.: 127127 Name: Angela Ashuer Address: 13 Joseph Ave, Appleton, WI, 54911 Customer No.: 913691 Name: Vincent Pico, EspressoBar Address: 58 Dante, Pisa, Tuscany, 56100 Customer No.: 127000 Name: Becky Cornell Address: 1203 N Lake Shore Drive, Chicago, IL 60610 Customer No.: 1958361 Name: David Kolse, Creamy Coffee Address: 702 Ensenada Street, Orlando, FL 32825 Customer No.: 532700 Name: Fred Olhman, Coffee Shoppe Address: 7011 Second Street, San Francisco, CA 94102

F G H STATE ZIP B C D E 1 CUSTOMER NO. LAST NAME FIRST NAME COMPANY NAME STREET ADDRESS CITY 2 3 4 5 6 7 B