2. Formulas and Functions 1) Create Range Name using "Define Name..." for Range (A4:F15) call it "Emp_Range" (hint: this can be labeled in the "name box") 3) In cell (B25) Give a Grand Total of the "Salary" and in cell (B27)" New Salary" Columns (put both totals in an Accounting format) Salary Grand Total: New Salary Grand Total: 7) In Cell (B31) Calculate the Average Number of "Years" worked by a salaried employee Average Number of "Years" worked 5) Write a Logical IF function in cell (C36) that can state "Yes" or "No" if a person is of a legal age to vote (Hint: the answer is in the PPT)