Can you pls help. I don't know how can I insert one-variable data table.
This is the full question: Switch to the Builders worksheet. Fernanda wants to calculate the revenue, expenses, and profit based on the number of people attending the Builders Trade Show. She has already set up a structure for a one-variable data table. In the range E5:H10, insert a one-variable data table, using the number of attendees (cell C4) as the Column input cell.
Reading books is a great way to learn. Here are some of the books we recommend.
To insert a one-variable data table, select the range given by her which is E5:H10, and the click on the "Data" tab. After that, click "What-If Analysis" which is in the forecast group.
Then, select "Data Table" from the dropdown and enter C4 in the Column input cell. That's it!