CHOOSE ONE TRUE IN EACH QUESTION
A B C D E F G H I J 1 Head Office Staff Date: 15/04/2021 2 3 Employee ID Job Title Office Start Date Years Service Days Leave Phone Extension Employee Name Sam Mason 4 S12716 Manager Melbourne 21/09/2015 5.6 18 2782 5 S12717 Lemin Lu Admin Melbourne 09/10/2015 5.5 15 2379 6 S12720 Engineer 26/12/2015 5.3 5 2459 7 S12722 Admin Sydney 3.0 9 2369 James Viney Will Chang Divika Kapoor Bin Wang 8 S12723 Admin Melbourne 2.9 23 2729 20/04/2018 05/05/2018 26/05/2018 29/11/2019 9 S12724 Admin 2.9 24 2148 Sydney Sydney 10 S12725 Andy Forbes Admin 1.4 6 2170 11 S12726 Tom Peters Melbourne 1.2 19 2570 Engineer Manager 12 S12727 Elan Forbes Sydney 3.0 16 2849 23/01/2020 15/04/2018 01/04/2018 22/04/2016 13 S12728 Phil Smith Admin Melbourne 3.0 30 2984 14 S12729 Jason Kerr Admin 5.0 10 2239 15 S12730 Chris Powe Admin Sydney Sydney Sydney 4.8 5 2468 13/07/2016 21/06/2020 S12733 Jordan Riddle Admin 0.8 9 2318 16 17 18 19 20 Exrension for: Will Chang 2369 Use the data above to answer the following multiple choice questions. For each question change the correct option to TRUE (it will change to green), leave the others FALSE 21 22 1 In row 1 the date is being calculated using which Excel function? 23 ANOW FALSE 24 B DATENOW FALSE 25 C TODAY FALSE 26 D DATE FALSE 27 28 2 Which keyboard shortcut creates an absolute reference? 29 A Alt+F4 FALSE 30 B Ctrl+4 FALSE 31 C Shift+4 FALSE 32 D F4 FALSE 33 34 3 The data has all been changed to align centre, what is the default alignment for Dates? 35 A Top Right FALSE 36 B Top Left FALSE 37 C Bottom Right FALSE 38 D Bottom Left FALSE 39 40 4 The formula =COUNT(E4:E16) will return 41 A An error FALSE 42 B 12 FALSE 43 C 13 FALSE 44 D 0 FALSE 45 46 5 Which of the following would calculate average length of service? 47 A =AVG(G4:16) FALSE 48 BEAVERAGEIFS(G4:616) FALSE 49 C =AVERAGE(G4:16) FALSE 50 D (G4:616)/8 FALSE 51 52 6 Which formula when entered in G4 and copied down will correctly calculate Years Service for each staff member 53 A =$I$1-($F$4/365.25) FALSE 54 B = ($I$1-F4)/365.25 FALSE 55 C =(11-$F$4/365.25 FALSE 56 D =(11-F4/365.25) FALSE 57 58 7 The formula =VLOOKUP(C18,B4:116,8,FALSE) returns an error, why? 59 A We have not used an absolute cell reference. FALSE 60 B Our lookup Table/array starts from the wrong column. FALSE 61 C It is an exact match FALSE 62 D It is a range lookup FALSE 63 64 8 To find out how many Admin staff there are in Sydney I should use which function? 65 A VLOOKUP 66 B COUNTIES 67 C SUMIF 68 D COUNTIF 69 FALSE FALSE FALSE FALSE
