Add a new calculation in column AE for the Final score percent for each student. Final score percent = total points earned / total points possible Dashboard sheet The dashboard is set up for you and should allow you to spend most of your time filling in the correct formulas, number formatting, and-most importantly-creating charts! Please ensure you solve for all of these items: In the shaded section below the label student name, create a drop-down list that allows the user to pick a student from the list on the Grades sheet. Many of the other functions used on the dashboard will reference this cell so consider using a named range. In the merged cells below the label Final Score use a lookup function to get the selected student's final score from Grades sheet-formatted as a percent (for example: 89.7%). In the merged cells to the right of the label First name use a lookup function to get the selected student's first name from Grades sheet. You could also use text functions to parse this from the cell with the drop-down list