Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Investment Analysis And Portfolio Management

Authors: Frank K. Reilly, Keith C. Brown

6th Edition

003025809X, 978-3540014386

More Books

Students also viewed these Finance questions

Question

Describe six general characteristics of William Jamess philosophy.

Answered: 1 week ago

Question

=+What do you wish you had known when you were starting out?

Answered: 1 week ago