Excel: Countif, IF, Nested IF, VLOOKUP_Exact Match; Approximate Match, Index and Match, PMT

In the attached excel workbook there are 3 tabs. Complete the following tasks on each tab on the excel attached and return it complete.

Part 1 –
Task 1: Use formula to calculate the final grade and the
letter grade

Task 2: Use function to calculate Computer Skills. Both
skills Yes: show “Sufficient”, only one skill: show “Good”,
no skill: show “Poor”

Part 2 –
Task 3: Generate a column
chart with the States showing as X-axis. Create a chart title “Units
Produced”. Place the chart on right side of the data.

Task 4: Generate a
pie chart with legend and title “Sales in Pounds”, showing the percentage
of each quarter. Place your chart on the right side of the data.

Part 3 –
Task 5: Create Line sparklines in column H in the Summary
sheet to display six-month trends for each agent. Show the high point in each
sparkline.

Task 6: Insert an IF function in column I that
displays a $600 bonus if an agent’s average sales are greater than the
average of all sales for the six months. Use two nested AVERAGE
functions in the logical _test argument of the IF function to
make the comparison. Use cell reference for Bonus

Last Completed Projects