You are creating a part of a spreadsheet that will automatically find customer information based on their Customer_ID. The partially completed spreadsheet is found in the attached file. <-- Click here to download the Excel file. Once the user enters the Customer_ID in cell B1, the spreadsheet should automatically find their Name, Address, City, State, and ZIP_Code in cells B2 through B6. Explain how this can be done. NOTE: When specifying the table, specify the entire table including columns you may not need. In cell B2 find the customer's name: = Answer ( Answer , Answer , Answer , Answer ) In cell B3 find the customer's street address: = Answer ( Answer , Answer , Answer , Answer ) In cell B4 find the customer's city and state: = Answer ( Answer , Answer , Answer , Answer ) In cell B5 find the customer's ZIP code: = Answer ( Answer , Answer , Answer , Answer ) NOTE: When specifying the table, specify the entire table including columns you may not need. Customer_ID 68YJW 7C6D2 Mea Baxter 8728 E. yukon Street Pittsfield, MA 01201 Name 5TAAZ Sacha Rodrigues 512 Birchpond Ave. Fitchburg, MA 01420 Address S64PS Rupert Townsend 977 St Margarets St. Hartford, CT 06106 City and State TL5YL Raphael Wolfe 523 Mill Lane New Haven, CT 06511 ZIP_Code M9CA7 Frances Madden 9261 Woodsman St. Freehold, NJ 07728 JVK9S Amal Valenzuela 561 Vermont St. Baldwin, NY 11510 N7YC5 Daphne Little 23 West Ann Lane Glenside, PA 19038 CWDXB Dawn Hussain 72 Lakeview St. Front Royal, VA 22630 Customer_ID GFC9T Tonisha Emerson 83 High Point Street Thomasville, NC 27360 Name 2QC9Z Junior Rodriquez 243 Dogwood Dr. Fuquay Varina, NC 27526 Address ZLZWG Lukas Brandt 4 Grove St. Lenoir, NC 28645 City and State 68YJW Reggie Greene 9570 Hilldale Court Anderson, SC 29621 ZIP_Code X6QZV Malakai Delaney 42 S. Surrey Lane Fort Walton Beach, FL 32547 PQT2Z Mylie Ferrell 9793 Manhattan Road Loxahatchee, FL 33470 4R31R Otto Clay 627 Sherwood Street Sevierville, TN 37876 AYXBS Ebrahim Albert 696 Briarwood Ave. Highland, IN 46322 31DTZ Destiny Castro 133 Lake St. Kalamazoo, MI 49009 XSTPC Logan Kidd 21 Myers Drive Euless, TX 76039 81DW4 Nick Bridges 3 Pawnee Street Palos Verdes, CA 90274

You are creating a part of a spreadsheet that will automatically find customer information based on their Customer_ID. The partially completed spreadsheet is found in the attached file. <-- Click here to download the Excel file. Once the user enters the Customer_ID in cell B1, the spreadsheet should automatically find their Name, Address, City, State, and ZIP_Code in cells B2 through B6. Explain how this can be done. NOTE: When specifying the table, specify the entire table including columns you may not need. In cell B2 find the customer's name: = Answer ( Answer , Answer , Answer , Answer ) In cell B3 find the customer's street address: = Answer ( Answer , Answer , Answer , Answer ) In cell B4 find the customer's city and state: = Answer ( Answer , Answer , Answer , Answer ) In cell B5 find the customer's ZIP code: = Answer ( Answer , Answer , Answer , Answer ) NOTE: When specifying the table, specify the entire table including columns you may not need. Customer_ID 68YJW 7C6D2 Mea Baxter 8728 E. yukon Street Pittsfield, MA 01201 Name 5TAAZ Sacha Rodrigues 512 Birchpond Ave. Fitchburg, MA 01420 Address S64PS Rupert Townsend 977 St Margarets St. Hartford, CT 06106 City and State TL5YL Raphael Wolfe 523 Mill Lane New Haven, CT 06511 ZIP_Code M9CA7 Frances Madden 9261 Woodsman St. Freehold, NJ 07728 JVK9S Amal Valenzuela 561 Vermont St. Baldwin, NY 11510 N7YC5 Daphne Little 23 West Ann Lane Glenside, PA 19038 CWDXB Dawn Hussain 72 Lakeview St. Front Royal, VA 22630 Customer_ID GFC9T Tonisha Emerson 83 High Point Street Thomasville, NC 27360 Name 2QC9Z Junior Rodriquez 243 Dogwood Dr. Fuquay Varina, NC 27526 Address ZLZWG Lukas Brandt 4 Grove St. Lenoir, NC 28645 City and State 68YJW Reggie Greene 9570 Hilldale Court Anderson, SC 29621 ZIP_Code X6QZV Malakai Delaney 42 S. Surrey Lane Fort Walton Beach, FL 32547 PQT2Z Mylie Ferrell 9793 Manhattan Road Loxahatchee, FL 33470 4R31R Otto Clay 627 Sherwood Street Sevierville, TN 37876 AYXBS Ebrahim Albert 696 Briarwood Ave. Highland, IN 46322 31DTZ Destiny Castro 133 Lake St. Kalamazoo, MI 49009 XSTPC Logan Kidd 21 Myers Drive Euless, TX 76039 81DW4 Nick Bridges 3 Pawnee Street Palos Verdes, CA 90274

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Once the user enters the Customer_ID in cell B1, the spreadsheet should automatically find their Name, Address, City, State, and ZIP_Code in cells B2 through B6. Explain how this can be done. NOTE: When specifying the table, specify the entire table including columns you may not need.

In cell B2 find the customer's name: = Answer ( Answer , Answer , Answer , Answer )

In cell B3 find the customer's street address: = Answer ( Answer , Answer , Answer , Answer )

In cell B4 find the customer's city and state: = Answer ( Answer , Answer , Answer , Answer )

In cell B5 find the customer's ZIP code: = Answer ( Answer , Answer , Answer , Answer )

NOTE: When specifying the table, specify the entire table including columns you may not need.

Customer_ID	68YJW	7C6D2	Mea Baxter	8728 E. yukon Street	Pittsfield, MA	01201
Name		5TAAZ	Sacha Rodrigues	512 Birchpond Ave.	Fitchburg, MA	01420
Address		S64PS	Rupert Townsend	977 St Margarets St.	Hartford, CT	06106
City and State		TL5YL	Raphael Wolfe	523 Mill Lane	New Haven, CT	06511
ZIP_Code		M9CA7	Frances Madden	9261 Woodsman St.	Freehold, NJ	07728
		JVK9S	Amal Valenzuela	561 Vermont St.	Baldwin, NY	11510
		N7YC5	Daphne Little	23 West Ann Lane	Glenside, PA	19038
		CWDXB	Dawn Hussain	72 Lakeview St.	Front Royal, VA	22630
Customer_ID		GFC9T	Tonisha Emerson	83 High Point Street	Thomasville, NC	27360
Name		2QC9Z	Junior Rodriquez	243 Dogwood Dr.	Fuquay Varina, NC	27526
Address		ZLZWG	Lukas Brandt	4 Grove St.	Lenoir, NC	28645
City and State		68YJW	Reggie Greene	9570 Hilldale Court	Anderson, SC	29621
ZIP_Code		X6QZV	Malakai Delaney	42 S. Surrey Lane	Fort Walton Beach, FL	32547
		PQT2Z	Mylie Ferrell	9793 Manhattan Road	Loxahatchee, FL	33470
		4R31R	Otto Clay	627 Sherwood Street	Sevierville, TN	37876
		AYXBS	Ebrahim Albert	696 Briarwood Ave.	Highland, IN	46322
		31DTZ	Destiny Castro	133 Lake St.	Kalamazoo, MI	49009
		XSTPC	Logan Kidd	21 Myers Drive	Euless, TX	76039
		81DW4	Nick Bridges	3 Pawnee Street	Palos Verdes, CA	90274

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here