Register
How do you use a what if analysis data table?
150k views
5 votes
How do you use a what if analysis data table?

User Steven Grosmark
by
4.7k points

1 Answer

2 votes

Answer:

  1. Select the range of cells that contains the formula and the two sets of values that you want to substitute, i.e. select the range – F2:L13.
  2. Click the DATA tab on the Ribbon.
  3. Click What-if Analysis in the Data Tools group.
  4. Select Data Table from the dropdown list.

User Ozan Mudul
by
5.7k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

6.0m questions

7.8m answers

Other Questions

A new information system is not considered in production until conversion is complete
a. STOP: What is a technology habit you practice today that you now realize will not help you to be successful? Explain why it’s important to STOP doing this right now.
Why might the government censor what its citizens see on the internet?
Flash drives cds external disks are all examples of storage (memory) devices
What is a spreadsheet program? A spreadsheet program is a computerized version of _________
Link Copied!