Data: Data Tools
This page begins a new discussion on the Data
Tools. Data Tools analyze the information: they ask
questions.
The best known
Data Tool is the What-if? Analysis. Our lesson will begin
with Goal Seek, a simple What-If.
Before You Begin: Open a Sample File
Open a sample spreadsheet:
Legs Eggs Pigs 2010.xlsx
Go to the sheet: Pig.
What Do You See? This is the Pig Sales for Charlotte's
Website. There are three reference Cells for Price (B1), Start (B2)
and Increment (B3). The formulas in Columns C, D, and E refers to
these three reference Cells.
Keep going...