Which steps describe creating a two-variable data table with Row input B3 and Column input B4?

Which steps describe creating a two-variable data table with Row input B3 and Column input B4?

• A. In the Data Ribbon Tab, Forecast Ribbon Group, What-If Analysis > Data Table... Row input B3, Column input B4
• B. Data > What-If Analysis > Data Table... Row input B4, Column input B3
• C. Data > Data Table > Row B3, Column B4
• D. Formulas > What-If > Data Table... Row B3, Column B4

Answer: (A)

This question focuses on how to set up a two-variable data table using the What-If Analysis feature. To create such a table, you go to the Data tab, choose What-If Analysis, and select Data Table. In the dialog, you specify which cells feed the row and column inputs for the table. The row input is the cell that represents the horizontal variable, and the column input is the cell for the vertical variable. For this scenario, you would set the Row input to B3 and the Column input to B4. That path—Data > What-If Analysis > Data Table—matches the required steps, and placing B3 as the row input and B4 as the column input tells Excel which values to substitute across the table. The other options either point to a different menu path or swap the row and column inputs, which would produce the wrong table setup.

This question focuses on how to set up a two-variable data table using the What-If Analysis feature. To create such a table, you go to the Data tab, choose What-If Analysis, and select Data Table. In the dialog, you specify which cells feed the row and column inputs for the table. The row input is the cell that represents the horizontal variable, and the column input is the cell for the vertical variable. For this scenario, you would set the Row input to B3 and the Column input to B4. That path—Data > What-If Analysis > Data Table—matches the required steps, and placing B3 as the row input and B4 as the column input tells Excel which values to substitute across the table. The other options either point to a different menu path or swap the row and column inputs, which would produce the wrong table setup.