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.

Videos Lectures
Study Notes
Past Papers
Purchase Latest Books