work on this data - https://docs.google.com/spreadsheets/d/1z3EdHN0BtOqkU3VRwRvoHUiPeNigr0BUTfMRnLD8DP8/edit#gid=1656731931 and complete Requirements:

Consistency across Excel workbooks and worksheets

• use the same Theme for all sheets (minimum 5) on each workbook and (minimum 2) Workbooks (5 marks)
• consistent content, organization, positioning, and formatting across both documents(5 marks)
  • they look clean, professional, and uncluttered

Higher Marks for proper use and presentation/explanation of one or more of the following(up to ten marks):

• What-If Analysis
• 3d References and consolidate workbooks and worksheets
• functioning Data Table(s), Financial Functions (PMT, PV, FV, VLOOKUP, IF)
• Named Reference Formulae

Excel Document

• includes at least ThreeDatabase Tables(10 mark)
  • on separate sheets presenting different information
  • properly formatted, labeled, and titled
  • a non-default Table Style is applied to each
• includesat least threedistinct types of Charts(10 marks)
  • on separate sheets presenting different information
  • properly formatted, labeled, and titled
  • a non-default Chart Style is applied to each
• use of proper Cell Styles and Borders(4 marks)
• use of Absolute, relative, and mixed, Structured (Named) References where appropriate (2 marks)
• include at least three different AutoFunctions in your tables (Math, Stat and Financial)(3 marks)
• includes at least three, different, hand-written Formulae of at least intermediate complexity in your tables(6 marks)
  • formulas should display
    • complex calculations using multiple operations and parentheses and/or
    • non-AutoFunction Formulae (If, PMT, FV, Match, CountIf, etc.)
• make sure that Formulae and other information is properly produced in Series by using the Fill Handle(2 mark),
• use at least three different Number Formats (Accounting, Currency, Dates, etc.) correctly and consistently in your Tables(3 mark)
• use Conditional Formatting at least twice in your Tables, total rows, and subtotals(4 mark)
• Use Page Layout tab to do the following.(5 mark)
  • apply the most appropriate page orientation(s) (portrait or landscape) for simple reading
  • set proper Print Areas to fit your tables and charts neatly on the pages without making them too small to read
  • in the headers of the printed pages, include the project title with the name of the organization)
  • in the footers of the printed pages, include your names and titles, the date, and sheet name.
• Save the file with yourfirst name andlast name in the title(1 mark) and submit via D2L.