Exam 77-428 Microsoft Excel 2013 EXPERT 3. Create Advanced Formulas 3.4 Create Scenarios: Use What If Analysis Tools Including Goal Seek

Data -> Data Tools 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 2013.xlsx Go to the sheet: Pigs. 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 refer to these three reference Cells. Keep going...