Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A B D E F G H 1 Sales Data March 2020 1 2 3 4 5 6 7 8 9 10 11 12 13
A B D E F G H 1 Sales Data March 2020 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Order ID 12037 12038 12039 12041 12042 12043 12044 12045 12046 12047 12048 12049 12050 Order Date 2/3/2022 4/3/2022 4/3/2022 4/3/2022 4/3/2022 6/3/2022 8/3/2022 9/3/2022 9/3/2022 10/3/2022 10/3/2022 12/3/2022 14/3/2022 Customer ID C123145 C134883 C133252 C137577 C136660 C139085 C127363 C128461 C133252 C134443 C123145 C134999 C123016 Customer State NSW NSW ACT VIC NSW VIC VIC NSW ACT Order Total $6,039.42 $30,438.68 $8,213.61 $2,254.72 $29,311.32 $6,039.42 $8,455.19 $10,367.67 $18,842.99 $6,643.36 $22,365.99 $21,741.91 $25,123.99 Discount 0% 10% 0% 0% 10% 0% 0% 10% 10% 0% 10% 10% 10% Amount Due $6,039.42 $27,394.81 $8,213.61 $2,254.72 $26,380.19 $6,039.42 $8,455.19 $9,330.90 $16,958.69 $6,643.36 $20,129.39 $19,567.72 $22,611.59 Date Due 16/3/2022 18/3/2022 18/3/2022 18/3/2022 18/3/2022 20/3/2022 22/3/2022 23/3/2022 23/3/2022 24/3/2022 24/3/2022 26/3/2022 28/3/2022 NSW NSW VIC Discount Min: $10,000.00 Customer ID C123145 Order Date 10/3/2022 Order Total $22,365.99 Order ID 12037 Amount Due $6,039.42 3 The Order Dates have been changed to centre align, by default they would align: A Bottom Left B Top Right C Top Left D Bottom Right FALSE FALSE FALSE FALSE 4 Payment is due two weeks after ordering, which formula correctly calculates date due? A =C4+14 FALSE B =DAY(C4,14) FALSE C =DATE(C4,14) FALSE D=TODAY()-14 FALSE 5 Which of the following would calculate average order total? A =(F4F16)/8 BEAVG(F4:F16) C '=AVERAGEIFS(F4:F16) D =AVERAGE(F4:F16) FALSE FALSE FALSE FALSE 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started