Create Data Table , AND Drop Down Cell box ALONG WITH

1) Create an Excel Data Table that lists the projected second-year income and interest expense for your firm under five sales growth scenarios, e.g. 0%, 5%, 10%, 15%, or 20% sales growth. [Variable Data Tables, MacDonald] 2) Create a Drop-Down User Input Cell with five choices for the firms growth prospects: Poor, OK, Expected, Good, & High [Data Validation with Lists, MacDonald]. 3) Place Formulas in two nearby output-cells that display the corresponding net income and interest expense amounts listed in the data table from part (a). Use the Excel Lookup Function [MacDonald] with Nested Excel If Statements [ MacDonald] to extract the data from the data table. Use Nested Excel If Statements to translate the user selection from the drop-down input in part (b) to one of the percentage sales growths used to form the d ata table in part (a), e.g. if the user selects Expected, the if statement returns 10% (0.10). Use the Lookup Function to find and display the net income and interest expense corresponding to the given sales growth in the data table. 4) Generate a Well-Formatted Chart [MacDonald] to display the data listed in the data table from part (a). 5) Use labels and formatting as appropriate to guide the user in using the functionality added in parts (a) (c).

( EXPLAIN TO ME HOW YOU DID IT SINCE I WON'T BE ABLE TO EXTRACT YOUR EXCEL SHEET AND HAVE TO DO IT MANUALLY FROM MY END

( see photo example with info) out of these financial statements. Income and growth rate should be placed in table. then explain to me how you did it step by step than do the other excel portion directions below and tell me how you do it. PLEASE ANSWER THIS QUESTION IF YOU ARE AWARE HOW TO DO THIS.