Question: 4. Sort the Beta file by age, from oldest youngest. Have the first tiebreaker be Beta experience (lowest to highest), and have the second tiebreaker
4. Sort the Beta" file by age, from oldest youngest. Have the first tiebreaker be Beta experience (lowest to highest), and have the second tiebreaker be annual salary (lowest to highest). Home Insert Page Layout Formulas Data Review View Cut Calibri 11 A- A- Copy Paste B I U A ili Format A2 fox D E F G H Education 6 UINO Beta Experience 12 8 2 1 25 10 N 6 16 1 4 8 6 4 6 4 6 0 4 6 O on 5 4 15 17 6 1 6 4 4 4 B 2 3 Gender Age Prior Experience 4 Female 39 5 5 Male 44 12 6 Male 24 7 Female 25 8 Male 56 9 Female 41 9 10 Female 33 6 11 Male 37 11 12 Female 51 12 13 Male 23 14 Male 31 5 15 Female 27 16 Male 47 17 Female 35 5 18 Female 29 5 19 Male 46 4 20 Female 50 10 21 Male 30 3 22 Female 34 10 23 Female 42 11 24 Female 51 10 25 Male 63 16 26 Male 28 27 Female 32 4 28 Male 55 11 29 Female 45 20 30 Male 34 2 31 Male 33 2 32 Female 23 0 33 Male 40 4 34 Female 48 6 35 Female 27 0 36 Female 36 5 37 Male 58 9 38 Male 31 1 39 Female 21 0 40 Male 47 5 41 Female 35 3 42 Female 52 12 43 Male 29 3 44 Female 42 11 45 Male 60 10 46 Female 50 8 47 Female 33 1 48 Male 26 49 Male 38 6 50 Female 44 7 51 Male 25 52 Female 37 53 Male 53 13 54 Male 46 7 55 Female 20 15 20 5 1 16 2 12 7 1 13 15 6 5 22 1 1 16 7 14 3 7 21 13 2 5 6 12 3 5 13 OAAAANAAANDAANA OAAANAAAAA Annual Salary $38,450 $50,912 $29,356 $27,750 $109,285 $48,442 $40,207 $42,331 $87,489 $26,118 $41,956 $17,439 $49,638 $43,184 $14,371 $54,613 $76,927 $38,556 $37,183 $50,712 $90,473 $93,588 $36,901 $33,100 $89,867 $51,259 $19,106 $39,224 $28,743 $54,965 $53,388 $18,014 $39,205 $88,763 $35,829 $17,784 $54,199 $36,932 $93,278 $22,100 $49,987 $85,471 $51,194 $36,109 $21,750 $39,455 $49,861 $30,327 $31,008 $90,874 $57,966 $15,945 OOOOO 1 4. Sort the Beta" file by age, from oldest youngest. Have the first tiebreaker be Beta experience (lowest to highest), and have the second tiebreaker be annual salary (lowest to highest). Home Insert Page Layout Formulas Data Review View Cut Calibri 11 A- A- Copy Paste B I U A ili Format A2 fox D E F G H Education 6 UINO Beta Experience 12 8 2 1 25 10 N 6 16 1 4 8 6 4 6 4 6 0 4 6 O on 5 4 15 17 6 1 6 4 4 4 B 2 3 Gender Age Prior Experience 4 Female 39 5 5 Male 44 12 6 Male 24 7 Female 25 8 Male 56 9 Female 41 9 10 Female 33 6 11 Male 37 11 12 Female 51 12 13 Male 23 14 Male 31 5 15 Female 27 16 Male 47 17 Female 35 5 18 Female 29 5 19 Male 46 4 20 Female 50 10 21 Male 30 3 22 Female 34 10 23 Female 42 11 24 Female 51 10 25 Male 63 16 26 Male 28 27 Female 32 4 28 Male 55 11 29 Female 45 20 30 Male 34 2 31 Male 33 2 32 Female 23 0 33 Male 40 4 34 Female 48 6 35 Female 27 0 36 Female 36 5 37 Male 58 9 38 Male 31 1 39 Female 21 0 40 Male 47 5 41 Female 35 3 42 Female 52 12 43 Male 29 3 44 Female 42 11 45 Male 60 10 46 Female 50 8 47 Female 33 1 48 Male 26 49 Male 38 6 50 Female 44 7 51 Male 25 52 Female 37 53 Male 53 13 54 Male 46 7 55 Female 20 15 20 5 1 16 2 12 7 1 13 15 6 5 22 1 1 16 7 14 3 7 21 13 2 5 6 12 3 5 13 OAAAANAAANDAANA OAAANAAAAA Annual Salary $38,450 $50,912 $29,356 $27,750 $109,285 $48,442 $40,207 $42,331 $87,489 $26,118 $41,956 $17,439 $49,638 $43,184 $14,371 $54,613 $76,927 $38,556 $37,183 $50,712 $90,473 $93,588 $36,901 $33,100 $89,867 $51,259 $19,106 $39,224 $28,743 $54,965 $53,388 $18,014 $39,205 $88,763 $35,829 $17,784 $54,199 $36,932 $93,278 $22,100 $49,987 $85,471 $51,194 $36,109 $21,750 $39,455 $49,861 $30,327 $31,008 $90,874 $57,966 $15,945 OOOOO 1
Study Help