Excel File Edit View Insert Format Tools Data Window Help 11 8 ) 75% Tue 10:23 AM QE AutoSave OFF A F ? C ... SMS310 Test 2 - Student File Final Home Insert Draw Page Layout Formulas Data Review View Tell me LE Share Comments Aria v 11 VA A E a Wrap Text v Custom LIX v LY AY - O. Paste BIUVE OvAv Merge & Center v $ ~ % " $00 80 Conditional Format Cell Insert Delete Format Sort & Find & Analyze Formatting as Table Styles ) v Filter Select Data Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No Q15 4 X V J Q W AA AB Bonus Units Sold Bonus Award ? Department Supervisor Bonus Region Bonus Rate Bonus Manager Job Title Bonus Bonus Rate Rodaba ba Name 270 No Award 18.00 RG1 2.0070 Suzanne Advisor 3.009% 38 8 950 Certificate 1.300 Junior Sales Rep Sales Rep Column AA is no Column X and Y are not used this Ter ed this Term Answers DO NOT DELETE DONOT DELETE DO NOT DELETE Column AA is not Column Xand Y are not used this Term used this Term Employee ID Last Name First Name Region Department Job Title Rating Year of Hire Age Salary Gender Units Sold Units Sold Units Sold Units Sold Annual Units Sold Enter Functions below according to Test instructions Qtr 3 Junior Sales STARTUP TEST DATA PIVOT Owner + Ready + 50%