A B C D E G H Melbourne Client List Client ID Last Order Days Since Last Region Postcode Account Manager Store Size Client Spend 2021 Region Account Manager Order C1036 2022/7/14 91 Northern Metro 3054 Sakshi Abbott Medium $26,056 Northern Metro Sakshi Abbott C1037 2022/5/7 159 Southern Metro 3188 Ahmed Baroody Large $31,104 Southern Metro Ahmed Baroody C1038 2022/9/16 27 Southern Metro 3206 Ahmed Baroody $83,264 Eastern Metro Patrick Gho C1039 2022/7/9 96 Eastern Metro 3132 Patrick Gho Medium $42,152 10 C1040 2022/7/19 86 Eastern Metro 3084 Patrick Gho Medium $39,712 Current Date 2022/10/13 11 C1041 2022/7/28 77 Eastern Metro 3127 Patrick Gho Medium $28,400 Clients in Melbourne: 10 12 C1042 2022/8/22 52 Northern Metro 3185 Sakshi Abbott Large $51,104 Orders in last 90 Days: 4 13 C1043 2022/9/4 39 Eastern Metro 3131 Patrick Gho Large $30,784 Average Spend 2021 $41,145.60 14 C1044 2022/9/10 33 Southern Metro 3121 Ahmed Baroody Medium $23,328 15 C1045 2022/6/8 127 Northern Metro 305 Sakshi Abbott Medium $55,552 16 17 18 Each question below has one correct answer. Select the correct answer by changing the FALSE to TRUE. 19 20 1 How many columns in an excel worksheet? 21 A 16384 TRUE 22 B Infinite FALSE 23 C 26 FALSE 24 D 1024 FALSE 25 26 2 $B3 is an example of 27 A Relative Cell Reference FALSE 28 B Mixed Cell Reference TRUE 29 C Structured Cell Reference FALSE 30 D Absolute Cell Reference FALSE 31 32 3 The Client IDs have been changed to centre align, by default they would align: 33 A Bottom Left TRUE 34 B Top Right FALSE 35 C Top Left FALSE 36 D Bottom Right FALSE 3738 4 Which formula correctly calculates the average client spend for 2021 in K13? 39 A =AVERAGE(16:115) TRUE 40 B =16:115/10 FALSE 41 C =AVG(16:115) FALSE 42 D =AVERAGEIFS(16:115) FALSE 43 44 5 Which of the following would calculate the most recent Order Date? 45 A =RECENT(C6:C15) FALSE 46 B =MAX(C6:C15) FALSE 47 C =DATE(C6:C15) FALSE 48 D =VLOOKUP(C6:C15) FALSE 49 50 6 Which formula returns the number of clients in the list? 51 A =MAX(B6:B15) FALSE 52 B =COUNTA(B6:815) FALSE 53 C =COUNT(B6:815) FALSE 54 D =COUNTIFS(B6:B15) FALSE 55 56 7 Which calculation will return the number of customers who have not placed an order in the last 90 days? 57 A =COUNTIFS(D6:D15)>90 FALSE 58 B =COUNTIF(D6:D15,90) FALSE 69 C =COUNTIF(D6:D15, >90) FALSE 60 D =COUNTIFS(D6:D15,">90") FALSE 61 62 8 Which of the following is the correct formula to return the 2021 spend for the client at postcode 3055? 63 A =VLOOKUP("3055",$F$6:$1$15,4) FALSE 64 B =VLOOKUP(3055,F6:15,4,0) FALSE 65 C =VLOOKUP("3055",B$6:1$15,8,FALSE) FALSE 66 D =VLOOKUP(3055,$8$6:$1$15,8,1) FALSE