Microsoft-Excel 2007 Study Material Day-Thirty Two

Data Table : A Data Table works with only one or two variables, but it can accept many different values for those variables. 

Steps :

  • Select the above range
  • Click on Data Tab
  • Click on What if Analysis
  • Click on Data Table
  • Row Input Cell : B1
  • Column Input Cell : B2
  • Click on OK