AA10 J 3 4 5 $ 7 5 19 11 12 #3 14 15 16 17...

Transcribed Image Text:

AA10 J 3 4 5 $ 7 5 19 11 12 #3 14 15 16 17 18 19 20 21 22 23 24 25 26 A B Emp ID State 1168 1169 1290 1299 1300 1301 1310 1311 1329 1330 1331 1333 1334 1426 1516 1517 1529 f Note: The questions for this excel file are given in the word document at the same place where you downloaded this file from (see Canvas). Read the questions from that word document and answer them in the respective worksheets of this excel file. When done, upload this excel file in Canvas Alabama Alaska E First Name Department Division Toni Jeremy Linda Arkansas Sanda Caltomia Philp Colorado Randy Connecticut Ellen Alabama Hary Tuome Arizona Deary Alacka F Arkansas Mary Calfomia Tady Colorado Midon Connecticul Pele Callamis Tom Colorado Kwen Arizona Tom G Engneeting Fax Engineering Copier Fax Admin Engneering Coper Accounting Pinter Marketing for Engineeing Fax Marketing Printer Engneeing Pinter Accounting Coper Engineering Pinter Engineering Coper R and D Fax Marketing Fax Accounting Printer Business Peter Engineering Per Salary $63.035 00 158.002.05 126,11386 $34.054.20 $30,451 68 127 081 04 432 410 05 143.406 95 155.410.05 131.539 24 $49.872 15 $59.362 20 H $28,04368 $64.609 00 $28.549 50 $75 509 60 $45.146 68 Start Date 4/10/1999 10/13/1990 1/3/2005 12/21/2005 12/13/1993 8/6/2008 10/4/1900 9/26/2002 2/22/2009 2/14/1999 5/11/1999 4/16/1995 4/8/1998 9/0/1985 3/6/2004 2/26/1989 1/28/2007 01 Birth Date Email Address 2/8/1970 Toni @counbedu 2/21/1920 Jeseny @osumb edu 2/22/1966 Lenda, @counbedu 2/23/1995 Sandian @cumbedu 2/24/1965 Philp, sumbedu 2/25/1961 Randy @cumbedu 2/26/1965 Ellen, @cmb edu 11/13/1954 Hay @cumbedu 2/27/1964 Tuone sub edu 9/23/1968 Deary @csunbedu 5/21/1964 Mary @cumbedu 10/7/1965 Tady @cumbedu 10/18/1565 Mida, @sub edu 9/23/1958 Pete cumb edu 6/26/1963 Tom @csumb.edu 7/7/1963 Karen, @club edu 9/10/1971 Tommie_@ctub edu 02 Birthday today? Wat Wat Wal Wai Wal Wat Wal Wat Wat Wal Wat Wat Wal Wat Wal Wat Wat M 03 New Salary 3. Answer this question in Column L of Database Worksheet where we calculated new salary for employees: If an employee is working in a division named Fax, then her/his new salary (to be calculated in Col L) will be 10.25% more than his old salary (given in Col G). Else, If an employee is working in a division named Copier, then her/his new salary (to be calculated in Col L) will be 5.5% more than his old salary (given in Col G). In all other cases, new salary we are calculating remains the same (i.e., same numeric value) as old salary given in Col G. AA10 J 3 4 5 $ 7 5 19 11 12 #3 14 15 16 17 18 19 20 21 22 23 24 25 26 A B Emp ID State 1168 1169 1290 1299 1300 1301 1310 1311 1329 1330 1331 1333 1334 1426 1516 1517 1529 f Note: The questions for this excel file are given in the word document at the same place where you downloaded this file from (see Canvas). Read the questions from that word document and answer them in the respective worksheets of this excel file. When done, upload this excel file in Canvas Alabama Alaska E First Name Department Division Toni Jeremy Linda Arkansas Sanda Caltomia Philp Colorado Randy Connecticut Ellen Alabama Hary Tuome Arizona Deary Alacka F Arkansas Mary Calfomia Tady Colorado Midon Connecticul Pele Callamis Tom Colorado Kwen Arizona Tom G Engneeting Fax Engineering Copier Fax Admin Engneering Coper Accounting Pinter Marketing for Engineeing Fax Marketing Printer Engneeing Pinter Accounting Coper Engineering Pinter Engineering Coper R and D Fax Marketing Fax Accounting Printer Business Peter Engineering Per Salary $63.035 00 158.002.05 126,11386 $34.054.20 $30,451 68 127 081 04 432 410 05 143.406 95 155.410.05 131.539 24 $49.872 15 $59.362 20 H $28,04368 $64.609 00 $28.549 50 $75 509 60 $45.146 68 Start Date 4/10/1999 10/13/1990 1/3/2005 12/21/2005 12/13/1993 8/6/2008 10/4/1900 9/26/2002 2/22/2009 2/14/1999 5/11/1999 4/16/1995 4/8/1998 9/0/1985 3/6/2004 2/26/1989 1/28/2007 01 Birth Date Email Address 2/8/1970 Toni @counbedu 2/21/1920 Jeseny @osumb edu 2/22/1966 Lenda, @counbedu 2/23/1995 Sandian @cumbedu 2/24/1965 Philp, sumbedu 2/25/1961 Randy @cumbedu 2/26/1965 Ellen, @cmb edu 11/13/1954 Hay @cumbedu 2/27/1964 Tuone sub edu 9/23/1968 Deary @csunbedu 5/21/1964 Mary @cumbedu 10/7/1965 Tady @cumbedu 10/18/1565 Mida, @sub edu 9/23/1958 Pete cumb edu 6/26/1963 Tom @csumb.edu 7/7/1963 Karen, @club edu 9/10/1971 Tommie_@ctub edu 02 Birthday today? Wat Wat Wal Wai Wal Wat Wal Wat Wat Wal Wat Wat Wal Wat Wal Wat Wat M 03 New Salary 3. Answer this question in Column L of Database Worksheet where we calculated new salary for employees: If an employee is working in a division named Fax, then her/his new salary (to be calculated in Col L) will be 10.25% more than his old salary (given in Col G). Else, If an employee is working in a division named Copier, then her/his new salary (to be calculated in Col L) will be 5.5% more than his old salary (given in Col G). In all other cases, new salary we are calculating remains the same (i.e., same numeric value) as old salary given in Col G.

Answer rating: 100% (QA)

It seems you have provided images of an Excel spreadsheet with a list of employees details and a que... View the full answer