New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey

Exercise 22

A customer table includes columns for name, street address, city, state abbreviation, and zip code. A second table includes state abbreviations and state names from all 50 states (one state per row). You need to add a new column to the customer table with the state name. What is the most appropriate function to use to display the state name in this new column