7:07 homeworkforyou.com C File Home Insert Page Lay Formulas Data R Microsoft Excel 2016 9 Formula Auditing, Data Validation, and Complex Problem Solving Objectives You will have mastered the material in this module when you can: Use formula auditing techniques to . Use goal seeking to solve a problem analyze a worksheet . Circle invalid data on a worksheet . Trace precedents and dependents . Use Solver to solve a complex problem . Use error checking to identify and . Use the Scenario Manager to record and correct errors save sets of what-if assumptions . Add data validation rules to cells . Create a Scenario Summary report . Enable the Solver add-in . Create a Scenario PivotTable report Use trial and error to solve a problem on a worksheet Introduction Excel offers many tools that can be used to solve complex problems. In previous modules, simple what-if analyses have shown the effect of changing one value on another value of interest. This module introduces you to auditing the formulas in a worksheet, validating data, and solving complex problems. Formula auditing allows you to examine formulas to determine which cells are referenced by those formulas and examine cells to determine which formulas are built upon those cells. Auditing the formulas in a worksheet can give insight into how a worksheet is structured and how cells are related to each other. Formula auditing is especially helpful when presented with a workbook created by someone else. Data validation allows you to set cells so that the values they accept are restricted in terms of type and range of data. This feature can be set up to display prompts and error messages when users select a cell or enter invalid data. You also can use data validation to circle cells containing data that does not meet the criteria you specified. Microsoft Excel 2016 Insert Page Layout Formulas Data Review View When trying to solve some problems, you can make an educated guess if you are familiar with the data and the structure of the workbook. This process is called trial and error. For simpler problems, you may find a solution using this process. For more complex problems, you might need to use software, such as Excel, to find a satisfactory solution. One of the tools that Excel provides to solve complex problems is Solver, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem. Solver also lets you place limits or constraints on allowable values for some or all of those cells. A constraint is a limitation on the possible values that a cell can contain. Solver will try many possible solutions to find one that solves the problem subject to the constraints placed on the data. Project - Life Coach Services Scheduling Analysis In this module, you will learn how to use the Life Coach Services Analysis workbook shown in Figure 9-1. Life Coach Services provides three types of coaching services to their clients: business coaching individual coaching and mentoring. The company K