Create an Excel spreadsheet that will be a teachers companion. It has to have an input area for the grades, rank them, split them into different quartiles, create relevant charts, give all the summary statistics that are relevant, color code grades that need to be looked into, have a conditional format highlighting when a student does better or worse than previous exams, show relevant lookup values for grades according to number and letter, have relevant pivot tables, etc. The goal is that it is a stand-alone tool for teachers to use to assess everything possible about a student. You must use every tool at your disposal. You must use clear, concise and appropriate formulas. You must present your information in a detailed and relevant manner. You will be graded on the level of formulas you used, on your ability to manipulate data, on your ability to present data for the intended audience, on how inventive you employ the tools at your disposal, on how thorough you are in your presentation, etc. The first page should be a cover page with hyperlinks to the other pages and a picture in the background. The second page should be a dashboard. All subsequent pages should display every tool we have used throughout the semester, including a screen shot of your data model measures and calculated columns. In the data model, create measures using CALCULATE, ALL, FILTER, and DISTINCTROWS (at least). You should be using the measures in your pivot table (at the least). include relative absolute and mixed cell reference use all the summary statistics (sum, average, min, max, count, etc.) use at least two different instances of date and time functions use at least three different formats such as number, date, custom etc. use at least three different instances of nested if functions use vlookup and index/match functions