Order ID 12037 Order Date Customer ID Customer State Order Total Discount Amount Due Date Due 3/2/2022 C123145 NSW $6,039.42 0% $6,039.42 3/16/2022 12038 3/4/2022 C134883 NSW $30,438.68 10% $27,394.81 3/18/2022 12039 3/4/2022 C133252 ACT $8,213.61 0% $8,213.61 3/18/2022 12041 3/4/2022 C137577 VIC $2,254.72 0% $2,254.72 3/18/2022 12042 3/4/2022 C136660 NSW $29,311.32 10% $26,380.19 3/18/2022 12043 3/6/2022 C139085 VIC $6,039.42 0% $6,039.42 3/20/2022 12044 3/8/2022 C127363 VIC $8,455.19 0% $8,455.19 3/22/2022 12045 3/9/2022 C128461 NSW $10,367.67 10% $9,330.90 3/23/2022 12046 3/9/2022 C133252 ACT $18,842.99 10% $16,958.69 3/23/2022 12047 3/10/2022 C134443 $6,643.36 0% $6,643.36 3/24/2022 12048 3/10/2022 C123145 NSW $22,365.99 10% $20,129.39 3/24/2022 12049 3/12/2022 C134999 NSW $21,741.91 10% $19,567.72 3/26/2022 12050 3/14/2022 C123016 VIC $25,123.99 10% $22,611.59 3/28/2022 4 Which formula correctly applies the discount % shown in Column G? A =F4-$G$4 B =F4-G4*F4 C =(F4-G4)*F4 D =F4-G4 5 Which of the following would calculate average order total? A =AVERAGE(F4:F16) B =(F4:F16)/8 C =AVG(F4:F16) D =AVERAGEIFS(F4:F16) 6 10% Discount is applied for orders over the amount shown in B19. Which formula entered in G4 and copied down calculates discount rate correctly? A =IF($F$4