Open the Business Electronics file that follows. Do the following:

In cell F8, create an IF statement that determines whether B5 is greater than 3500. If this is true, include in the IF statement the requirement to subtract B5 from B9. If it is false, include the the IF statement the requirement to print FALSE. In cell E8, type the label IF. In cell E8, type the label IF.

In cell F10, create a formula to print the average of cells B5 through B13. In cell E10, type the label Average. Format the result in F10 as a number with only two decimal places.

In cell F12, create a formula to count the total of numbers in cells B5 through C13. In cell E12, type the label Count.

In cell F14, create a formula to determine the lowest number in cells B5 through C13. In cell E14, type the label Minimum. Make the E column wider if necessary.

In cell F16, create a formula to determine the highest number in cells B5 through C13. In cell E16, type the label Maximum.

Use conditional formatting to highlight cells in column C where the sales data is greater than 9250 with Green Fill and dark green text.