Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Go back to the Statehood sheet. Add a column E called Nicknames. Use a VLOOKUP() function to add the nicknames from the nicknames sheet into

Go back to the Statehood sheet. Add a column E called Nicknames. Use a VLOOKUP() function to add the nicknames from the nicknames sheet into column E of the statehood sheet. Please just give the vlookup function to type in image text in transcribed
image text in transcribed
State # nicknames State Delaware Pennsylvania New Jersey Georgia Connecticut Massachusetts Maryland South Carolina New Hampshire Virginia New York North Carolina Rhode Island Vermont Kentucky Tennessee Ohio Louisiana Indiana Mississippi Illinois Alabama Maine Missouri Arkansas Michigan Florida Texas lowa Wisconsin California Minnesota Oregon Kansas West Virginia Nevada Nebraska Colorado Statehood Date December 7, 1787 December 12, 1787 December 18, 1787 January 2, 1788 January 9, 1788 February 6, 1788 April 28, 1788 May 23, 1788 June 21, 1788 June 25, 1788 July 26, 1788 November 21, 1789 May 29, 1790 March 4, 1791 June 1, 1792 June 1, 1796 March 1, 1803 April 30, 1812 December 11, 1816 December 10, 1817 December 3, 1818 December 14, 1819 March 15, 1820 August 10, 1821 June 15, 1836 January 26, 1837 March 3, 1845 December 29, 1845 December 28, 1846 May 29, 1848 September 9, 1850 May 11, 1858 February 14, 1859 January 29, 1861 June 20, 1863 October 31, 1864 March 1, 1867 August 1, 1876 Statehood Year 1787 1787 1787 1788 1788 1788 1788 1788 1788 1788 1788 1789 1790 1791 1792 1796 1803 1812 1816 1817 1818 1819 1820 1821 1836 1837 1845 1845 1846 1848 1850 1858 1859 1861 1863 1864 1867 1876 State Nickname Alabama The Yellowhammer State Alaska The Last Frontier Arizona The Grand Canyon State Arkansas The Natural State California The Golden State Colorado The Centennial State Connecticut The Constitution State Delaware The First State Florida The Sunshine State Georgia The Peach State Hawaii The Aloha State Idaho The Gem State Illinois The Prairie State Indiana The Hoosier State lowa The Hawkeye State Kansas The Sunflower State Kentucky The Bluegrass State Louisiana The Pelican State Maine The Pine Tree State Maryland The Old Line State Massachusetts The Bay State Michigan The Great Lakes State Minnesota The North Star State Mississippi The Magnolia State Missouri The Show Me State Montana The Treasure State Nebraska The Cornhusker State Nevada The Silver State New Hampshire The Granite State New Jersey The Garden State New Mexico The Land of Enchantment New York The Empire State North Carolina The Tar Heel State North Dakota The Peace Garden State Ohio The Buckeye State Oklahoma The Sooner State Oregon The Beaver State Pennsylvania The Keystone State Nicknames Capitals Statehood +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing A Practical Approach With Data Analytics

Authors: Raymond N. Johnson, Laura Davis Wiley, Robyn Moroney, Fiona Campbell, Jane Hamilton

2nd Edition

1119786045, 978-1119785996

More Books

Students also viewed these Accounting questions