Question $16(5$ pts$)$:

Instructions:

Go to worksheet #$16$ in the Excel Exam data file. Note the Income Statement shown in the range A$3$:B$7.$

Note cells B$5$ and B$7$ are formulas: B$5-$B$3-$B$4$;B$7-$B$5-$B$6.$

You want to find out the different levels of Gross Profit and Net Income given different levels of Sales.

Using the Data Source given in A$3$:B$7$ and the Excel What$-$If Analysis Data Table function, construct a One$-$Variable Data Table in the range A$12$:C$18.\backslash$table$[[,$A$,$B$],[1,$Worksheet #$16,],[2,,],[3,$Sales,$1000],[4,$Less Cost of Sales,$600],[5,$Gross Profit,$400],[6,$Less Operating Expense,$200],[7,$Net Income,$200],[8,,],[9,,],[10,,],[,,]]$