\f8:13 K Chapter 2 Excel A... Q Requires your last name! Crain's Consulting Firm Inputs and Constants Today: 7/17/2014 Requires a Date Formula "Today" Years Threshold: 5 Requires Year Frac Function Requires a VLOOKUP (3-points) High Year Rate: 3.25% (2-points) Low Year Rate: 2.00% O O Current Years Rating Rating Date Hired Salary Employed Score Bonus Raise New Salary 4/1/2004 $ 50,000 10.79 5 7/15/2012 $ 75,250 2.01 3.5 10/31/2008 $ 67,250 5.71 4.2 9/8/2003 $ 45,980 10.86 2 3/14/2011 $ 58,750 3.34 1.5 Requires Addition 6/18/2010 $ 61,000 (1-point) 4.08 4.5 Requires an IF Statement (3-points) Bonus Data Rating Bonus This is a table that is a 1 part of your VLOOKUP S 100 (1-point) UI AW 250 500 1,000 0= n Dashboard Calendar To Do Notifications Inbox