Register

How do you use a what if analysis data table?

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

User Steven Grosmark
by
6.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
8.0k points
← Prev Question Next Question →

No related questions found

Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

9.4m questions

12.2m answers

Categories

Other Questions

“What does it mean when we “rework” copyrighted material?”
Please help me ! All you do is just put it it all in your own words ! Please this is for my reported card!i don't know how to put it in my own words because my English is not that good!
describe an advance in technology that makes life more enjoyable. what discoveries contribute to this technology?
Link Copied!