Question
You have created a worksheet (Spending) to help you track your spending for the month of August. You are able to download your debit card
You have created a worksheet (Spending) to help you track your spending for the month of August. You are able to download your debit card transactions from your bank's website, but the information is not presented in a clear way. The transaction information includes a time stamp (a number that the bank associates with a specific date and time), merchant ID, and amount for each of the 63 transactions you made in August. You have decided to use what you know about how Excel handles dates, times, and text to reformat the information you received from your bank and make it easier to read and understand. Complete the table below by performing each of the tasks. In the rightmost column of the table, you will create a statement about each transaction. This statement follows the format of the template in cell D9. Because there may be more than one way to complete each field of the table, use the functions suggested in each of the task descriptions. Template I spent $ at merchant # on: Length Position of "#" Position of "$" Statement P1 Statement P2 Statement P3 Time Stamp Merchant ID Amount Month Day Hour Minute Second Date Transaction Statement 40756.788588 4931 $24.06 40757.455930 4329 $26.99 40757.629305 8103 $24.25 40757.866335 8234 $9.58 40758.693496 4556 $16.59 40759.640262 4277 $22.08 40759.708581 4277 $23.06 40759.777827 6158 $23.00 40760.749738 4931 $15.81 40761.346613 4670 $6.81 40763.369599 6132 $16.80 40763.377290 4931 $5.10 40763.600053 4670 $16.48 40763.698378 4670 $19.96 40764.409008 7927 $8.54 40765.505280 7927 $4.87 40765.890658 4277 $18.70 40765.910262 5031 $3.29 40766.751562 4172 $21.10 40766.841718 5056 $16.46 40767.456824 6329 $22.80 40767.481102 4329 $28.40 40767.539629 6132 $8.17 40767.559364 8103 $6.43 40767.615509 4205 $17.32 40767.658124 5031 $16.62 40767.677884 6329 $24.32 40768.460862 5031 $28.16 40768.799808 8234 $5.95 40770.371531 4556 $12.51 40770.429205 7927 $24.86 40770.438833 8234 $25.00 40770.784586 8234 $23.10 40771.591442 8520 $13.52 40771.670240 4205 $8.84 40773.460275 5031 $13.15 40773.565961 4931 $25.66 40773.880570 4205 $14.54 40774.473899 4172 $20.18 40774.582839 8520 $28.14 40775.492153 4556 $14.99 40775.531251 4556 $25.56 40775.543907 4670 $25.52 40775.780794 6329 $23.98 40777.731126 8103 $19.11 40778.512033 6158 $7.53 40778.589545 4556 $5.10 40778.841680 7927 $6.44 40779.526600 8234 $24.26 40781.681088 4329 $24.13 40781.717628 4205 $12.07 40782.598417 5056 $22.83 40782.740048 5056 $4.14 40784.351818 6132 $10.62 40784.442599 4172 $8.02 40784.882174 4931 $9.00 40784.910421 7927 $24.38 40785.616307 4172 $13.71 40785.830413 4931 $22.14 40786.461586 4172 $23.59 40786.675453 4205 $17.54 40786.683317 7927 $18.98 40786.829942 8234 $28.87 40786.832489 8103 $4.94
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started