Question: In the Work Anniversay column, endter an IF function. If the monthe in the employee's hire date matches the month in the Data Tables worksheet

In the Work Anniversay column, endter an IF function. If the monthe in the employee's hire date matches the month in the Data Tables worksheet (cell B4), YES should appear in the Work Anniversary column; otherwise, the cell should remain blank. All employees receive a card on their work anniversary.

**Show all work/formulas**

Employee ID Last Name First Name Pay Grade Hire Date Years of Service Birth Date Age Store Job Status Current Salary Work Anniversary Eligible for Bonus Comp Days Bonus
1102 Delosreyes Lori B 7/10/2014 3.5 4/11/1961 55 Bonham FT $ 106,010
1106 Goode Bari B 11/6/2015 2.2 11/23/1991 25 Graham FT $ 42,182
1110 Reams Linda B 12/4/2015 2.1 10/15/1966 50 Bonham FT $ 92,254
1114 Rodriguez Richard D 3/24/2003 14.8 12/8/1964 52 Graham FT $ 69,250
1118 Peters Jessica C 5/23/2011 6.6 2/15/1962 54 Bonham FT $ 102,567
1122 Cortez Nick D 8/12/2002 15.4 10/15/1968 48 Bowie FT $ 94,517
1126 Millard Melissa B 11/6/2015 2.2 3/20/1973 43 Garland FT $ 51,791
1130 Burns Brenda C 6/10/2010 7.6 4/20/1966 50 Garland FT $ 32,530
1134 Kimball Susan C 1/20/2016 1.9 3/21/1957 59 Graham FT $ 94,502
1138 Ford Charles A 5/4/2012 5.7 6/28/1967 49 Bonham PT $ 45,671
1142 Vazquez Johnny C 7/16/2011 6.5 2/8/1986 30 Graham FT $ 70,346
1146 Whetstone William C 4/12/2008 9.7 7/13/1986 30 Garland FT $ 34,685
1150 Arnold Leroy C 3/13/2012 5.8 7/8/1949 67 Bonham FT $ 96,944
1154 Basile Santos B 8/8/2015 2.4 12/1/1956 60 Bonham FT $ 92,091
1158 Loftis Robert B 7/17/2015 2.5 7/12/1959 57 Garland FT $ 30,150
1162 Olson Ruth B 1/8/2015 3.0 3/6/1970 46 Bonham FT $ 81,536
1166 Gridley Marjorie B 10/4/2013 4.2 10/25/1959 57 Bowie FT $ 96,021
1170 Estevez Lois C 9/7/2012 5.3 3/11/1961 55 Garland FT $ 58,720
1174 Cannon Eva B 8/7/2014 3.4 10/28/1956 60 Graham FT $ 76,947
1178 Tyler Shirley B 5/29/2015 2.6 8/21/1950 66 Graham FT $ 96,449
1182 Smith Robin D 1/18/2007 11.0 11/8/1951 65 Garland FT $ 45,766
1186 Lee Marvin B 1/1/2016 2.0 6/10/1966 50 Graham FT $ 96,960
1190 Erwin Erin D 1/8/2004 14.0 12/23/1991 25 Graham FT $ 94,346
1194 Godrun Earle D 4/20/2007 10.7 6/30/1956 60 Graham FT $ 94,441
1198 Cannon Ramon D 6/15/2007 10.6 9/29/1950 66 Graham FT $ 90,338
1302 Chavez Jason A 6/15/2012 5.5 7/31/1963 53 Graham PT $ 49,890
1306 Poulsen Catherine B 7/10/2015 2.5 5/5/1960 56 Graham FT $ 68,681
1310 Lunsford Alberta C 1/22/2016 1.9 7/11/1953 63 Graham FT $ 52,244
1314 Marciano Kathy B 10/16/2015 2.2 7/15/1984 32 Graham FT $ 92,221
1318 Miller Billy B 8/28/2015 2.3 11/24/1951 65 Graham FT $ 35,304
1322 Ward Deann D 9/22/2006 11.3 1/5/1959 57 Bowie FT $ 51,675
1326 Wilt Thomas D 3/19/2007 10.8 11/7/1982 34 Graham FT $ 90,283
1330 Young Alfonso A 3/11/2010 7.8 3/3/1958 58 Garland PT $ 45,657
1334 Maddox Nicole B 8/28/2015 2.3 2/5/1976 40 Bowie FT $ 39,545
1338 Escarcega Michael D 8/11/2003 14.4 4/2/1967 49 Graham FT $ 125,068
1342 Mizer Joseph B 4/3/2015 2.7 2/22/1967 49 Graham FT $ 80,407
1346 Larsen Jennifer C 3/7/2009 8.8 2/15/1965 51 Bonham FT $ 83,415
1350 Jackson Edwin C 12/29/2011 6.0 4/4/1953 63 Garland FT $ 75,037
1354 Keefer Cynthia C 3/12/2016 1.8 3/20/1979 37 Garland FT $ 53,826
1358 Melancon Dina B 6/7/2015 2.6 5/8/1976 40 Garland FT $ 38,083
1362 Foley Pamela C 1/22/2016 1.9 4/2/1991 25 Bowie FT $ 54,945
1366 Jean Carlos B 10/30/2015 2.2 4/27/1956 60 Graham FT $ 104,494
1370 Neace Marc B 9/4/2015 2.3 11/7/1974 42 Bowie FT $ 71,446
1374 Swanson Brandon A 10/12/2013 4.2 1/17/1970 46 Graham PT $ 49,598
1378 Simpkins James C 2/12/2010 7.9 7/12/1974 42 Graham FT $ 42,664
1382 Lavalee James C 7/16/2011 6.5 6/11/1970 46 Garland FT $ 55,551
1386 Beals Vanesa B 10/2/2015 2.2 6/10/1968 48 Bowie FT $ 125,235
1390 Pearce James C 2/14/2008 9.9 3/1/1953 63 Garland FT $ 51,065
1394 Gurganus Esther D 8/24/2004 13.4 8/11/1966 50 Graham FT $ 53,186
1398 Toomer Katherine B 6/19/2015 2.5 11/25/1963 53 Graham FT $ 63,491
2002 Mortimer John C 5/24/2010 7.6 9/6/1966 50 Graham FT $ 108,705
2006 Allen Elizabeth B 8/28/2014 3.3 12/15/1985 31 Bonham FT $ 75,818
2010 Smith Helen B 4/24/2015 2.7 9/24/1968 48 Bonham FT $ 46,142
2014 Rodriguez Stephen B 7/18/2014 3.5 8/9/1959 57 Graham FT $ 84,036
2018 Thompson Lane B 8/21/2015 2.4 7/15/1950 66 Graham FT $ 68,470
2022 O'Donnell Robert B 3/5/2015 2.8 5/2/1958 58 Bonham FT $ 93,248
2026 Spaulding Sherri B 3/1/2013 4.8 12/7/1977 39 Bonham FT $ 101,822
2030 McKeown Michael B 12/8/2015 2.1 12/4/1961 55 Graham FT $ 38,420
2034 Benham Paul A 8/11/2011 6.4 1/10/1959 57 Graham PT $ 53,582
2038 Laboy Jayma C 6/12/2009 8.6 1/30/1942 74 Garland FT $ 24,373
2042 Casas Antolin C 5/4/2012 5.7 8/27/1989 27 Garland FT $ 65,181
2046 Guyer Ian B 12/18/2015 2.0 1/6/1968 48 Bowie FT $ 71,020
2050 Ramos Robert C 5/4/2011 6.7 4/28/1958 58 Garland FT $ 60,129
2054 Dunton Robert D 11/26/2004 13.1 10/4/1971 45 Graham FT $ 64,845
2058 Wall Diana C 2/22/2008 9.9 1/4/1960 56 Garland FT $ 49,831
2062 Weaver Leanne B 12/4/2015 2.1 9/16/1970 46 Graham FT $ 76,706
2066 Jung Brenda B 10/12/2015 2.2 12/2/1985 31 Garland FT $ 91,240
2070 Merritt Vernon B 12/4/2015 2.1 5/9/1959 57 Bonham FT $ 96,282
2074 Parham Jose C 11/26/2010 7.1 5/10/1966 50 Graham FT $ 85,412
2078 Hutton Patrice B 3/19/2013 4.8 8/31/1973 43 Graham FT $ 98,341
2082 Davis Carla D 6/18/2004 13.5 10/14/1952 64 Graham FT $ 93,243
2086 Griffin Robert B 7/21/2015 2.4 11/3/1965 51 Bowie FT $ 130,886
2090 Merrill Shannon A 11/27/2014 3.1 6/8/1952 64 Bowie PT $ 64,826
2094 Blackshear Gregory C 4/19/2016 1.7 4/11/1962 54 Graham FT $ 76,677
2098 Palmer Angel C 7/5/2008 9.5 3/17/1959 57 Graham FT $ 46,566
3002 Fallis Ruth C 6/3/2010 7.6 6/16/1953 63 Bonham FT $ 89,391
3206 Montoya Maria C 1/29/2016 1.9 11/1/1982 34 Graham FT $ 54,368
3210 Bennett James C 8/2/2010 7.4 7/26/1962 54 Garland FT $ 36,671
3214 Web Jason B 8/28/2015 2.3 9/24/1974 42 Graham FT $ 58,309
3218 Whiting Jeffery D 11/5/2007 10.2 5/31/1951 65 Garland FT $ 37,090
3222 Lloyd Shanika A 7/17/2015 2.5 10/15/1984 32 Garland PT $ 51,639
3226 Baker Ina C 7/1/2010 7.5 10/9/1991 25 Garland FT $ 59,138
3230 Rosenberg Robert B 7/17/2015 2.5 2/1/1949 67 Bowie FT $ 114,254
3234 George Robert A 3/13/2011 6.8 5/12/1969 47 Graham PT $ 64,598
3238 Trottier James B 7/24/2015 2.4 10/25/1959 57 Graham FT $ 94,896
3242 Elamin Martin B 2/5/2014 3.9 1/18/1947 69 Graham FT $ 58,291
3246 Pope Richard C 3/15/2009 8.8 3/3/1961 55 Garland FT $ 58,161
3250 Burgess Charlotte D 11/11/2005 12.1 5/13/1978 38 Graham FT $ 99,539
3254 Floyd Bobbi B 9/12/2014 3.3 9/24/1986 30 Graham FT $ 102,609
3258 Guerrero Maudie D 9/18/2006 11.3 6/16/1953 63 Graham FT $ 52,125
3262 Roeder Larry B 11/13/2015 2.1 10/11/1955 61 Graham FT $ 94,452
3266 Joe Ronald B 12/11/2014 3.1 3/3/1974 42 Graham FT $ 97,543
3270 Holland Patricia C 5/13/2010 7.6 6/5/1959 57 Bonham FT $ 98,219
3274 Parham Theresa A 11/26/2013 4.1 3/2/1955 61 Graham PT $ 41,204
3278 Williamson Santina A 8/25/2004 13.4 5/13/1964 52 Bowie PT $ 65,978
3280 Bennett June A 9/6/2008 9.3 6/26/1967 49 Bowie PT $ 96,354
3282 Wolfe Larry D 11/20/2004 13.1 11/2/1950 66 Graham FT $ 38,683
3286 Bradley Thomas B 4/10/2015 2.7 7/15/1982 34 Bonham FT $ 77,468
3294 Martinez John C 10/17/2009 8.2 3/20/1967 49 Bonham FT $ 111,426
3298 Bean Douglas B 5/29/2015 2.6 4/15/1953 63 Graham FT $ 95,552

DATA TABLES Sheet

Employee Dates
Years of service as of 12/31/2017
Work Anniversary this month 4
Age as of 1/1/2017
Comp Days
<=1 Years of Service 0
>1 and <=5 Years of Service 1
>5 and <=10 Years of Service 2
>10 Years of Service 3
Bonus
A 0
B 300
C 600
D 800

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

oyees.pdf - Adobe Acrobat Reader DC Help --Case Review ... x PRACTICE Data File needed for the Review Assignments: Employees.xlsx Vanessa wants you to analyze the MBHC employee data to determine each...

Q:

In the Work Anniversary column, enter an IF function. If the month in the employee s hire date matches the month in the Data Tables worksheet ( cell B 4 ) , Yes should appear in the work anniversary...

Q:

On the Employee Data worksheet, create a function for the Work Anniversary column that will state Yes if it is the employees work month anniversary and will otherwise be blank. Use the Work...

Q:

Paragraph Styles LKE Distribution 1. On the Documentation worksheet enter your name in the Author cell and current date in the Date cell. 2. In the Sales Commission column of the Invoices worksheet,...

Q:

pls help with explanation!! inportant. Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, lake sure to extract the files after...

Q:

Can someone please help me with this? In this project, you will work with sales data from Topt Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will...

Q:

Steps to complete this project: Important : Download the resource files needed for this project from the Resources link. If the files download in a zipped folder, make sure to extract the files after...

Q:

Open the start file EX2019-Capstone-Level3 . Note: If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the worksheet so you can modify it The...

Q:

3. Copy the OldTownStore worksheet from the OldTownSales workbook (downloaded from the Resources link) to the capstone project. a. Open the Excel file OldTownSales. b. Copy the worksheet...

Q:

EX 5-9aSkills Review 1. Create and format a table. 1. Start Excel, open IL_EX_5-2.xlsx from the location where you store your Data Files, then save it as IL_EX_5_Scientific. 2. Using the data in the...

Q:

An employee has an average wage of $60,000 and has worked for the firm for 28 years. The defined benefit pension plan pays retirees 2.3%. The average wage times the years of service. How much can...

Q:

Outline a synthesis of each of the following compounds from the indicated strating material and any other reagents. (a) N-(sec-buty1) -N-ethylaniline from chlorobenxene (b) (c) (CH,),C from phenol NH...

Q:

PLEASE Only Write code for selection 6 ! ! ! ! Java Select one of the options: 0 . Quit Determine if 3 user - defined numbers are a Pythagorean triplet? Determine if a user - defined number a prime...

Q:

please dont use chat gpt or other AI 4 0 5 .

Q:

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Q:

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Q:

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...