FOR YOUR INFORMATION: - Your solutions below must be in the form of an Excel formula. If you find yourself manually performing calculations, you are not doing the assignment correctly. For some problems, you may have to use multiple formulas. In these cases, use the cells to the right of the problem, but ensure the solution in column B answers the question. - The next tab includes financial data for all public companies from 2000 to 2020. - All numbers on the next tab are in millions (i.e., "2000" really equals "$2,000,000,000"). This is just for your information. You do NOT need to adjust for this in your solutions below. - Ignore the fact that some of the data on the next tab are missing or incomplete. PROBLEM (complete in the order listed) Example: Compute total revenue for all public companies in 2001 using data from the tab labeled "Company Financial Data." Compute Apple's total revenue for all available years using data from the tab labeled "Company Financial Data