Question: Now your boss is under pressure from the Auditors. They feel that Revenue has not been recorded properly from 2005-2008. Your boss wants your recommendation as to what revenue amounts should be recorded for the years 2005-2008. 6) (4 pts) What is your recommendation to record the Breakdown of the $$$ Amount of Revenue by Year for (and make sure to describe how and why (simple, short explanation) you came up with this breakdown/solution):

a. 2005

b. 2006

c. 2007

d. 2008

I've attached a photo of a piece of the data set, there are more entries, but this will give you the idea. How would I solve the above question in excel?