The 3 excel files can be found by going to:

- https://www.dropbox.com/s/j868kd0g5hm2py7/e10c1Rewards.xml?dl=0

- https://www.dropbox.com/s/6iworguzut5e3e5/e10c1VolunteerInfo.csv?dl=0

- https://www.dropbox.com/s/aztnmoshg28d7di/PledgeDrive.xlsx?dl=0

Instructions:

For the purpose of grading the project you are required to perform the following tasks:

Step	Instructions	Points Possible
1	Open the workbook e10c1PledgeDrive.xlsx and save it as e10c1PledgeDrive_LastFirst.	0.000
2	Import the file e10c1VolunteerInfo.csv. Be sure to use a method that creates a connection to the external file. Import the data into cell A1 of the existing worksheet.	10.000
3	Rename the worksheet Volunteer Information.	3.000
4	Use Text to Columns to separate the values in column D into three separate columns for City, State, and Zip. Resize the columns as needed.	6.000
5	Set the External Data Range Properties to Refresh data when opening the file.	0.000
6	Copy the range B2:B7, paste it in the range I2:I7, and delete the original range B2:B7. Although Steps 6 and 7 are not worth any points, you still need to complete them in order to be able to complete Step 8 correctly.	0.000
7	Enter a function in cell B2 that formats the data in cell I2 in a traditionally formal format (i.e. the first letter is uppercase and the rest are lowercase). Copy the function down to complete the column. Although Steps 6 and 7 are not worth any points, you still need to complete them in order to be able to complete Step 8 correctly.	0.000
8	Copy the range B2:B7 and paste the values back into the range B2:B7 to remove the underlying functions. Then delete the values in column I.	8.000
9	Create a new worksheet and name it Rewards.	4.000
10	Create a connection to the e10c1Rewards.xml file in the Rewards worksheet. Make sure to import the data as an xml table.	10.000
11	Apply Accounting Number Format to the dollar amounts imported into column A.	4.000
12	Open the document e10c1Rewards.xml using Notepad. Locate the spelling error in line 18 (Sweet Shirt) and edit the data to Sweat Shirt. Save and close the XML file. Refresh the data in the Rewards worksheet.	5.000
13	Save and close the file. Submit e10c1PledgeDrive_LastFirst as directed.	0.000