Chapter 7, Problem 7.1E

E9 ✓ ✓ fx 5 6 7 8 Date Value و 3835 40468 B Fractional Date 40468.25 10 40468.375 11 40468.625 12 13 14 15 DATE DATA CLEANUP and MANIPULATION D Problem Date Year (YEAR) Month (MONTH) Day (DAY) End of month Start of month Use E6 "Problem Date" for green cells in col. E & I 10/8/2019 Start of next month First day of the year #N/A #N/A # N/A #N/A #N/A #N/A #N/A Month to date fraction of year Day of the week TIP: Use custom date format to display as the name of the day (dddd) Name of month Workdays in current month 30 workdays (excluding weekends) from today Days between today and 30 workdays from now 16 17 Target $2,000 DATE REVENUE MONTH DAY OF WEEK Hit Target? MONTH DAY OF WEEK FORMULAS for TABLE COLUMNS C through E SC Hit Target? 19 10/1/2019 $3,642 #N/A #N/A #N/A 20 10/2/2019 $3,427 #N/A #N/A #N/A 21 21 10/3/2019 $3,842 #N/A #N/A #N/A 22 22 10/4/2019 10/4/2015 $3,525 #INDA #N/A #N/A #N/A 23 10/5/2019 $3.648 20 10/5/2015 99,040 #N/A #N/A #N/A 24 24 10/6/2019 10/6/2015 $3,833 #N/A #N/A…

I am looking for a step-by-step explanation of this financial accounting problem with correct standards.

Hi expert please given correct answer with accounting question