Question

Excel uses the ____ function when creating a data table mcq

Answer 1

table is the answer for your question

Answer 2

Excel uses the What-if-Analysis function when creating a data table MCQ.

Explanation:

The data tables allow the user to see the result of many different possible inputs at the same time. In Excel data table is created as follows:

• Select the range of cells for the data table.
• Select Data group from the excel toolbar
• Click the What-If Analysis feature and choose the Data Table option.
• Dialog boxes appear, and then enter the Row input cell and Column input cell.
• Finally, click Ok.