MS-Excel uses the _____ function when creating a data table.

1. Average
2. count
3. Both A and B
4. Table

Excel uses the ‘TABLE’ function to calculate the results in the data table. This function uses an array formula which you can check in the formula bar.