answersLogoWhite

0

The Solver. You can also use Goal Seek to get a single value.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

How do you make a result sheet in Excel?

how to create a excel sheet


When you create an Excel chart in PowerPoint what data do you use that is editable in Excel into the presentation?

You can create an excel chart in presentation. This helps to compare a large number of values.


How do you add 2 values in Excel?

The 'sum' function.Type =sum(X,Y) - bold for emphasis - where X and Y are your cell locations or values, and Excel will return the sum (i.e. the result of addition) of those values.


In Excel a what-if analysis in a cell containing the desired result called?

For one individual cell, it can be a Goal Seek.


Can you create a graph in MS Excel if you have one missing result?

All you need to create a chart are values. If some of the values are wrong or you don't have all the values you want, the chart can still be created using the values that are there. Obviously the chart won't be accurate, but if the empty cells are included in the data the chart is based on, once you enter the missing values, the chart will automatically update itself.


When do you need to create a custom list for use with Excels Auto Fill feature?

You need to create a custom list for Excel's Auto Fill feature when you have a specific sequence or set of values that Excel does not recognize as a standard list, such as days of the week or months. This is common for unique lists like project phases, product names, or custom categories. By defining a custom list, you can easily populate cells with these specific values, enhancing efficiency in data entry. To create a custom list, go to the Excel options and input your desired sequence in the Custom Lists section.


What program is used to create and modify spreadsheets on Excel Answer It?

Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.Microsoft Excel is used to create and modify spreadsheets.


How will i enter an excel formula to a row?

To enter a formula in Excel, click on the cell where you want the result to appear. Type the equal sign (=) followed by the formula you want to use, such as =SUM(A1:A10) for summing values in cells A1 to A10. Press Enter, and the formula will calculate and display the result in that cell. To apply the same formula to a row, you can drag the fill handle (a small square at the bottom right corner of the cell) across the desired cells.


What does hypothesis means in Excel?

In the context of a spreadsheet, it can be an idea you want to check out. You can build a series of formulas to carry out a task in order to find a solution You can try different values to see what effect they have and what result you get. To test a hypothesis means to evaluate the gathered facts with the help of an experiment. In a spreadsheet it can be called What-If analysis. What if we enter these values? What result does it give you? That is what you are doing with a hypothesis in Excel.


How do you make a line chart with Excel 2007?

Select the values that you want to chart. Then on the ribbon go to the Insert tab and you can choose a line chart from there to create it.


What displays the lowest values for a range of values in excel?

The MIN function.


When you enter numeric data in a cell Excel recognizes the values as numbers and what the values?

It formats the values.