The Solver.
A worksheet cell with a numeric value is called a data point.
The new worksheet will go in before or in other words to the left of the current worksheet.
You need to do this.
It is known as a Value.
Yes
spellcheck
A data point
Any time a value is changed in a spreadsheet, it automatically recalculates the entire worksheet. This keeps it up to date for the values that are now in the worksheet. A worksheet can have many formulas. Changing one value can affect many of those formulas, so it is important that they do recalculate when changes are made.
Bar chart
Formula
value.