PLEASE PROVIDE FORMULAS FOR ALL QUESTIONS LISTED BELOW

Using the concatenation function, combine the first and last names in Columns A and B. Here is the formula: =B11&" "&A11

Using either YearFrac or another formula, calculate the Years with Company

Using Conditional Formatting, highlight in green a date occurring within the past month

Using Conditinal Formmatting, highlight in red the top 10% of the salaries

Using Conditional Formatting, show the bottom 10 percent of years of service in red font

D F G H J 2 B 1 Conditional Formatting Practice 3 Millennium Manufacturing, Inc. 4 Year 2022 Budget Review - Salaries 5 by Your Name, Accounting Temp 3/10/21