5. In the range B12:E12, Benicio wants to display a rating depending on the total sales for each quarter. He listed the rating criteria in the range A14:F15. For example, if total sales in Quarter 1 are between $5900 and $5999, the Performance rating is Good. Enter the performance ratings as follows: a. In cell B12, start to enter a formula using the HLOOKUP function.

Tony prince is the project manager for the recreation and wellness intranet project. team members include you, a programmer/analyst and aspiring project manager; patrick, a network specialist; nancy, a business analyst; and bonnie, another programmer/analyst. other people are supporting the project from other departments, including yusaff from human resources and cassandra from finance. assume that these are the only people who can be assigned and charged to work on project activities. recall that your schedule and cost goals are to complete the project in six months for under $200,000.task 2identify at least eight milestones for the recreation and wellness intranet project. write a short paper describing each milestone using the smart criteria. discuss how determining these milestones might add activities or tasks to the gantt chart. remember that milestones normally have no duration, so you must have tasks that will lead to completing the milestone.