Practice

EX $3-9$d Visual Workshop

Open IL$\_$EX$\_3-5.$xlsx from the location where you store your Data Files, then save it as IL$\_$EX$\_3\_$Freight. Use the skills you learned in this module to complete the worksheet so it looks like the one shown in Figure $3-21.$ 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\%.($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 $3-21$