Forumlas for the following:

10. calculate the year and totals for all financial categories by selecting the range E6:P29 in using the quick analysis tool to insert the sum of each row into the range Q6:Q29.

11. Stephan wants the monthly averages of each financial category to be displayed in range B6:B29. Select cell B6, and then enter a formula that contains an acid function the first calculate average of the values in the range E6:P6 and then uses the ROUND function to round the average to the nearest 10 dollars.

Draw Page Layout Formulas Data Review View Body - 1 - AA met 1.044 E32 233 verta Cortar mg ater Porto $ -% W 2:28 San Pawy Construction 17.57891 414 10 5920715 0 110 570 Cesto Cast of Goods 1971 3 . 12. 18.06.201 1 Gross Pro 7 2017 23.92187 00 10042025 1408 151537 1.561 interest Expenses Paroles 2004 11,99110 3 15.7143111211114, 10,844 2004 20 1 5114125 Sun 7:40 PM Excel Fle Edit View insert Format Tools Data Window Help Autosave $ 5 . Gorecki BudgetSaved Insert Draw Page Layout Formulas Data Review View Colbert Bon A B e waren eres UV A EEE ration. More Center 5 % Share Comme 93 . 0. oma X GEO 7. 18 Feb 18 Feb 11 10 18 11-1-18 Total Construction 34,308.10 57.207.15 34.711.30 20,78148 10. SGR 92 28,31114 2 334 14 57,108 63 5.009 67 Cost of Goods Sold 2.075.21 2,07521 33,078.28 BEEN 18,706.27 14234.07 21.030,4 29,0925 2981746 21.71293 12,241.34 1421145 11 160.72 23,921.87 12,419.00 18.620.36 1,51587 15.50 1.55321 292 10.1849 15.50 1645 28 29241 1 1,994.10 251781 207 29 24433 20148 11.78187 11,005.18 20042 9521 3510 222.04 21.124.42 1719 4,71432 1045.09 6 ,21271 16.734 31.075.43 100 1046892 Nincome 2.92344 172421 1 7062 1605.11) Documentation Month + MacBook Air