Chapter 8, Problem 4EYW

Using Excel and provide screenshot of the excel window

I am currently learning how to use excel VBA and I wondered why I couldn't open the column as shown in the image attached. Could you help?

Data Exchange assignment. Create an Excel Spreadsheet with Column names: LastName FirstName City State Age Major Enter 10 rows of data to populate your spreadsheet with test data. Save this file as an XLSX (standard Excel Format); base spreadsheet. Save and view the data in its ‘raw’ format Save this file as Windows Comma Separated .CSV Close Excel Open this .CSV file using a text editor (e.g. Notepad) Take a screen shot of this and include it in your writeup document What you notice that’s different about this format vs the standard XLSX format?  XML Using your TEXT editor, create a file called ‘studentdata.xml’ Enter the studentdata.xml below as the XML schema and save it Open your original .XLSX file On the Developer tab, open the ‘XML Source’ task pane If you don't see the Developer tab, do the following to display it: Click File > Options. In the pane on the left, click the Customize Ribbon category. Under Main Tabs, check the Developer box, then click OK. Click XML Maps…