someone please help. This is the only instructions. I have to put formulas in the yellow boxes. can you tell me what formulas to type in the boxes as well as the answers to boxes? thank you!!!!

1 libese we pressied as sumed Instructions - Determine the numerical answers to questions #122. a. Use formulas andior functions to determine each answer rather than typing in numerical answen - b. Use variables/cell references rather than fyping numbers into the formulas. c. Do not use theiper cells". Your only entries should be in the yellow answer cels. Yout formulas may only reference cels where data is given OR cells where you have previously entered in answers. d. Enter a formuls for answer $1 and so that it can be copied down to answer "i2 through #7. e. Use the SUM function when adding more than two contiguous cells. f. Use the SUMFS function when adding values anly when a condition is true. There are at least five answers where a sumifs function is appropriate. IMPORTANT: Your formulas should work for different data sets, such as a. If the amounts given were cifferent. b. If some of all of the five completed jobs were different ones then the five shown in your version. c. It some or at of the three jobs that were sold were different ones than the three shown in your verion. 41. 1) 14. Sebic wen watelated Jobs were thpiest to cukturan and insritory was abphates Watsand were tiles on actount for phat toid. pased on equ journal orrites abore. 1 libese we pressied as sumed Instructions - Determine the numerical answers to questions #122. a. Use formulas andior functions to determine each answer rather than typing in numerical answen - b. Use variables/cell references rather than fyping numbers into the formulas. c. Do not use theiper cells". Your only entries should be in the yellow answer cels. Yout formulas may only reference cels where data is given OR cells where you have previously entered in answers. d. Enter a formuls for answer $1 and so that it can be copied down to answer "i2 through #7. e. Use the SUM function when adding more than two contiguous cells. f. Use the SUMFS function when adding values anly when a condition is true. There are at least five answers where a sumifs function is appropriate. IMPORTANT: Your formulas should work for different data sets, such as a. If the amounts given were cifferent. b. If some of all of the five completed jobs were different ones then the five shown in your version. c. It some or at of the three jobs that were sold were different ones than the three shown in your verion. 41. 1) 14. Sebic wen watelated Jobs were thpiest to cukturan and insritory was abphates Watsand were tiles on actount for phat toid. pased on equ journal orrites abore