You are creating a two-way data table that will show how many items are actually sold for various types of supply and demand. The partially completed spreadsheet is shown below:

Look closely at the spreadsheet and familiarize yourself with how it works. Then specify below what needs to be done to create the two-way data table.

• Which cell does Excel evaluate to determine what is displayed in the data table? MCQ Choices:

1- e4

2-j4

3- i3

4- e3

5- d6

• Which cell contains the calculation that should be linked to the cell in the previous question? MCQ Choices:

1- f6

2- d6

3- e3

4- i3

5- e4

6- j4

• Once you select the correct cells and open the dialog box, what should be entered into the Data Table dialog box?

Row input cell: MCQ Choices:

1- f4

2- e3

3- d3

4- d4

5- e4

6- f3

Column input cell: MCQ Choices:

1- d4

2- e4

3- f4

4- d3

5- e3

6- f3