uestion 2 The information below shows the profit for a product based on assumptions. Which of the following is TRUE if using a one variable data table to conduct sensitivity analysis on the profit figure? tyet answered Data Price ints out of 1.00 Flag question Demand Unit Cost Fixed Cost Revenue Variable Cost Profit 4.00 18,000.0 0.60 40,000.0 72,000.0 =C9*C10 10,800.0 =C11*C10 21,200.0 =C13-C14-C12 Select one: You must enter data in the 'Row Input Cell' before the profit figures will be displayed You cannot change any of the assumptions in your table of data A data table is only possible if the profit is dynamically linked to changeable assumptions Select one: You must enter data in the 'Row Input Cell before the profit figures will be displayed You cannot change any of the assumptions in your table of data A data table is only possible if the profit is dynamically linked to changeable assumptions You must create copied cells to prevent a circular reference in your data table Question 5 Using the information below, which of the following should be completed first to produce the data table illustrated below: A B C D E F G H Not yet answered 7 Points out of 1.00 8 Demand Unit Price 9 P Flag question 8,000.0 5.0 (22,000.0) (1.8) 10 Fixed Cost 11 Unit Cost 12 13 14 Revenue 40,000.0 Fixed Costs (22,000.0) Variable Costs (14,400.0) Profit 3,600.0 15 16 17 18 19 20 3,600.0 4.00 4.50 21 Units Solds 5,000.0 6,000.0 7,000.0 8,000.0 9,000.0 10,000.0 (11,000.0) (8,800.0) (6,600.0) (4,400.0) (2,200.0) 0.0 (8,500.0) (5,800.0) (3,100.0) (400.0) 2,300.0 5,000.0 (6,000.0) (2,800.0) 400.0 3,600.0 6,800.0 10,000.0 (3,500.0) 200.0 3,900.0 7,600.0 11,300.0 15,000.0 (1,000.0) 3,200.0 7,400.0 11,600.0 15,800.0 20,000.0 5.00 22 23 5.50 24 6.00 Select one: Complete the formula cells to link your data to your assumptions You need to create linked cells for your formula cells to prevent a circular reference in your data table Link cell C15 (profit) to the top right of your table so the table references the formula for the input values Use the shortcut key 'ALT AWT' to bring up the Data Table function