1. In the Years w/ Firm column (K), you will need to use the Now() function* to calculate how many years each employee has been with the firm (Hint: Divide by # of days in a year).

Excel File Edit View Insert Format Tools Data Window Help * E Sat Nov 21 8:27 PM U AutoSave OFF AT3_F20 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments fx V Define Name [? AutoSum Recently Financial Logical Used Calculate Now x AL E Traca Pracadents Trace Dependents Show Remove Arrows Formulas Checking Window Error Watch Insert Function Text Date & Lockup & Math & More Time Reference Trig Functions Create from Selection Calculation calculata Sheet Options F14 fx A L M N P A S T U V W X Y Z F . PLS 21 Associate Sales Employees Report 3 4 5 Shipping UC David Address holda Ave. Davis, CA 95816 Base Salary $25 Commissir SO SSU S76 $100 $125S1LC Sales Commission & 9 Bonus 10 $ $1.00 $6.00 $6.50 $0.00 $10.00 $12.50 Veure Toll Sales Training Fequired Commision & Salary Bonus 107.19 59.74 34.02 47.54 1.se 12 13 Employee 14 Gabriele 15 Mitchell 16 Kyle 17 Courtney 1e Juliana 19 Paul 20 Della 21 Liyan 22 Calcb 23 Jenny 24 Amy 25 Conor 26 Acdc 27 28 29 30 Quarterly Sales in thousands First Second Third Fourth 26.93 14.23 4.12 0.22 22.18 18.94 32.54 7.50 42.03 11.23 30.00 29.81 7.14 11.50 12.87 18.04 16.24 29.41 16.09 20.12 96.GA 32.12 29.10 29 41 38.24 25.62 21.12 20.50 14.17 32.40 53 87 33 33 16.98 9.50 12.47 10.00 33.12 28.67 38 52 28 51 46.02 57.34 40.21 23.56 13 00 33.59 48 20 10 40 40.24 5.99 9.85 22.57 PLS 21 Average Total Sales 52.18 37.29 53. 11 37.43 4A 22 53.25 80 11 29.99 TONI Cule Salary Hrad WFm 28-Jan-17 27-May-97 2-Jul-06 8-May-01 14 hug-16 18-Aug-02 23-Way-US 24.DAC-12 25 Jun 07 29-04-12 15-Mar 11 7-Nov-ne 20 Apr 94 32 33 34 36 36 37 38 40 41 42 43 44 45 46 Report + Ready + 100% 1400 g 21 v A