1- Using the data provided below you are to input formulas in the area designated below to calculate: % complete, revenue to be recognized in each year, and gross profit to be recognized in each year.

2- Using the data given and the solutions your spreadsheet generated, prepare all journal entries for 2022.Whevenver possible, the amounts for your journal entries should be formulasthat reference the appropriate cells in the calcuations below.

NOTE: I need to answer both questions in excel, or do the problem in excel. Thanks