CIS$370$ Information Systems Theory and Practice

Midterm

Problem $2.$ American Freight

Open IL$\_$EX$\_3-5.$xlsx$,$ then save it as IL$\_$EX$\_3\_$Last and First Name. Use the skills learned in the Excel Module $3$ to complete the worksheet so it looks like the one shown in Figure $1.$ To build the formulas in column G$,$ calculate the percentage increase of the second quarter revenue over the first quarter revenue. $($Hint: The percentage increases in column G must be calculated before calculating the average increase in cell B$10.)$ To build the formulas in column I, a warning should be issued if the percentage increase is less than the average increase shown in cell B$10$ AND the on$-$time delivery is less than $75\backslash \%.($Hint: Remember to use an absolute cell reference where necessary.$)$ When you are finished, enter your name in the center footer section, then submit your work to your instructor as directed.

Figure $1.$ American Freight Solution