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.