Lab 71 - Excel Qiqi Chen X File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Queries & Connections 21 32 x Clear Show Detail Data Analysis Properties Reapply What-If Forecast Group Ungroup Subtotal -Hide Detail Get From From From Table/ Recent Existing Refresh Z1 Sort Filter ext to Flash Remove Data Consolidate Relationships Manage Data . Text/CSV Web Range Sources Connections All - ley Edit Links Advanced Columns Fill Duplicates Validation Data Model Analysis Sheet Get & Transform Data Queries & Connections Sort & Filter Data Tools Forecast Outline G Analysis G12 X E G H K M N O P Q R S T U V W X Y Z AA AB AC A B C D Graduate ID NSW Salary QUI A W N 50468 5LD CO V G UI A W N 1 5762 5132 4032 31884 41210 45314 48883 38133 10 40852 28313 54351 31528 41373 5223 16 46985 17 54853 18 4752 19 40209 53203 43862 49612 57142 38497 28144 37423 36884 41803 43959 30 41778 31 4547 32 37782 33 38673 34 39607 35 44075 36 o 3738 37 6792 ... VIC SA NSW QLD VIC QLD Sheet1 NSW SA + # 0 J -- 100% Ready Type here to search x ] (7 41) ENG 2:38 PM 3/10/2019Lab 71 - Excel Qiqi Chen X File Home Insert Draw Page Layout Formulas Data Review View Help Search Share Pa Queries & Connections x Clear Show Detail Data Analysis Get From From From Table/ Recent Existing Refresh Properties 21 32 -Hide Detail Filter Reapply Data Consolidate Relationships Manage What-If Forecast Group Ungroup Subtotal All - ley Edit Links Z1 Sort ext to Flash Remove Data . Text/CSV Web Range Sources Connections Advanced Columns Fill Duplicates Validation Data Model Analysis Sheet Queries & Connections Sort & Filter Data Tools Forecast Outline G Analysis Get & Transform Data F11 X E F G H K M N O P Q R S T U V W X Y Z AA AB AC A B C D 36 U 3738 37 36792 38 41365 39 39669 40 3779 41 39744 42 4079 43 50022 44 39488 45 45330 46 43140 47 34628 48 43359 32044 50 34489 ... VIC QLD Sheet1 Sheet2 Sheet3 NSW SA # 0 J -- 100% Ready (7 41) ENG 2:52 PM Type here to search x ] 3/10/2019