In cell E3, write an Excel formula to determine the value of the cost overruns (

Question

In cell E3, write an Excel formula to determine the value of the cost overruns (budget vs. actual expenditure) for the month of January. This value should be positive if the actual amount spent exceeds the budget. Copy the formula down the column for months February through December In cell F3, write an Excel formula to determine (True/False) if the actual expenditures exceeded the budget for this month. Copy the formula down the column. cell E17, write an Excel formula to determine (True/False) if the expenses for all months were over budget rite an Excel formula to determine (True/False) if at least one of the months experienced a cost overrun (over budget). In cell E19, write an Excel formula to determine (True/False) if none of the months were over budget e In cell E20, write an Excel formula to determine (True/False) if both winter and summer each have at least one month with cost overruns. Assume the summer months are June, July and August and winter months are January, February and March Use Conditional Formatting to highlight values in cells F3:F14, if they are True. Use the default (pink, with red text) format. . Use Conditional Formatting to insert light blue data bars in cells E3:E14. The longer the bar the higher the cost overrun. . On the same worksheet adjacent to this table, create a chart showing the values of the cost overruns for each month Use an appropriate chart that compares discrete values. Be sure your chart contains a title and axis labels Insert a second chart, just below the first chart This chart should plot the functional relationship between average · temperature differences from inside/outside versus the budgeted amount for utilities. Use an appropriate chart that shows a functional relationship. Be sure your chart contains a title and appropriate axis labels

Explanation / Answer

1.=D3-C3
2.=if(E3>0,True,False)
3.=if(countif(E3:E14,True)=12,True,False)
4.=if(countif(E3:E14,True)>=1,True,False)
5.=if(countif(E3:E14,True)=0,True,False)
6.=if(and(countif(E3:E5,True)>=1,countif(E8:E10,True)>=1),True,False)

P.S.: I am allowed to answer only 4 questions

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.