Question: The Data Data can come to you in many different formats. In this assignment, you are presented with a set of customer transactions contained in

The Data Data can come to you in many different formats. In this assignment, you are presented with a set of customer transactions contained in a PDF file. The challenge is to get the data into an Excel spreadsheet, formatted in a usable way, that allows you to do some analysis. As you move through the various sections of the assignment, please copy the spreadsheet tab used in that section to a new tab to work on the next section without disturbing your work from the earlier section. To receive full credit for this assignment, you must show your work for each section. Section 1: Get the Data into Excel Open the pdf document and highlight the data. Copy that data and paste it into a new workbook that you will name "Homework #2 - [Your Name]". Label the tab into which you have copied the data "Section 1". As you copy the data into the worksheet, I recommend you Paste Special-Text. You now can see that the worksheet shows all the information in one column. You want to be able to analyze the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!