1 The income statement should be presented at the 'evel 1 roll up summary 2 Give the Chart of Accounts a name that can ve wed to reiere. Ice the table 3 Give the list of cost centers a name to be use to extract the division 4 insert 3 colu ns in front of the Jata table 5 Title the columns as follows A = Division 31 = Title C1 - Level 1 6 Use a combination of INDIA( AND MATCH") to extract the division from the List of C / Use a combination of ...FKRL R and VLOOKUP functions to add Account Title and , ir 8 The VLOOKUP should use the names assigned in 2 above to reference the chart of ac 9 If the account is not found produce a message to add a new account to the chart of 10 Clear all the error messages by adding new accounts to the chart of accounts or _ist You should find one account that is not in the chart of account Add the account as f Account Title Level 1 Level 2 Level 3 Direct Fixed External 1.DirfixNonWages 2 DirFix S.Op Expense 11 "Ise SUMIrS functions to extract the data from the Data table into the income statem 12 Column A contains the criteria for the SUMIFS function This column should be hidd 13 Round the statement in 100u's using a value added to a name range to divide by 100