Question

Create a one-variable data table in range D5:G13. In cell D5, use cell B4 as the input cell. In cell G5, use cell B9 as the formula result value. In the Data Table dialog box, use cell B4 as the Column input cell.

A) TABLE(B4, B9, D5:G13)
B) DATATABLE(B4, B9, D5:G13, B4)
C) ONEVARIABLE(B4, B9, D5:G13, B4)
D) DATA(B4, B9, D5:G13, B4)

Answer 1

You can use the DATATABLE function to create a one-variable data table in Excel. Therefore, the correct answer is B) DATATABLE(B4, B9, D5:G13, B4).

Step-by-step explanation:

To create a one-variable data table in the range D5:G13, you can use the DATATABLE function. In cell D5, you should use cell B4 as the input cell. In cell G5, you should use cell B9 as the formula result value.

To open the Data Table dialog box, you can use the DATATABLE function with the range D5:G13 and cell B4 as the column input cell. Therefore, the correct answer is B) DATATABLE(B4, B9, D5:G13, B4).

Based on the instructions provided, you are asked to set up a data table in the range D5:G13, with cell B4 as the input cell and G5 as the cell that will show the formula results. When setting up the data table in Excel, you enter the settings in the Data Table dialog box.

The correct formula to achieve this is not listed among the options A to D that you provided, as none of these match Excel's syntax or function names.